dbTalk Databases Forums  

[PHP] Problem in importing database

mailing.database.pgsql-php mailing.database.pgsql-php


Discuss [PHP] Problem in importing database in the mailing.database.pgsql-php forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Archana K N
 
Posts: n/a

Default [PHP] Problem in importing database - 06-05-2012 , 12:21 AM






Hello,

I got a text file when i exported a database in postgres using
pgadmin it was named 'dump.sql'. And when i tried to import the same to
postgres using pgadmin i got the following error.

"dump.sql:1: ERROR: syntax error at or near "Dumping"
LINE 1: Dumping of complex table and schema names on Windows is not ...
^

Total runtime: 9.419 ms'

I cant figure wat is the problem...plss help..

--
-------------------
regards
archana
--------------------

Reply With Quote
  #2  
Old   
Raymond O'Donnell
 
Posts: n/a

Default Re: [PHP] Problem in importing database - 06-05-2012 , 04:51 AM






On 05/06/2012 06:21, Archana K N wrote:
Quote:
Hello,

I got a text file when i exported a database in postgres
using pgadmin it was named 'dump.sql'. And when i tried to import the
same to postgres using pgadmin i got the following error.

"dump.sql:1: ERROR: syntax error at or near "Dumping"
LINE 1: Dumping of complex table and schema names on Windows is not ...
Reading the contents of the file will give you the answer... :-) Looks
like you got an error message instead of a dump.

Also, I'd guess from the above that you used PhpPgAdmin, not pgAdmin;
they're two very different animals.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod (AT) iol (DOT) ie

--
Sent via pgsql-php mailing list (pgsql-php (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

Reply With Quote
  #3  
Old   
Archana K N
 
Posts: n/a

Default Re: [PHP] Problem in importing database - 06-05-2012 , 05:17 AM



Reading the contents of the file will give you the answer... :-) Looks
Quote:
like you got an error message instead of a dump.

Also, I'd guess from the above that you used PhpPgAdmin, not pgAdmin;
they're two very different animals.

Ray.

You are right I got an error message instead of data but yesterday i got a
text file which contained database information I dont know today the text
file looked like this.
And am using phppgadmin.

Can i export data correctly???




--
-------------------
regards
archana
--------------------

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.