Thread: Problem in importing database
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 ...
^
--
-------------------
regards
archana
--------------------
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
--------------------
On 05/06/2012 06:21, Archana K N wrote: > 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@iol.ie
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.
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
--------------------