Problem in importing database

Поиск
Список
Период
Сортировка
Искать

Problem in importing database

От:
Archana K N <archanakknn@gmail.com>
Дата:
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

От:
Raymond O'Donnell <rod@iol.ie>
Дата:
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

От:
Archana K N <archanakknn@gmail.com>
Дата:


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