Thread: Problem in importing database

Problem in importing database

From
Archana K N
Date:
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
--------------------

Re: Problem in importing database

From
Raymond O'Donnell
Date:
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

Re: Problem in importing database

From
Archana K N
Date:


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
--------------------