export af databasen

pg_dump utility

jeg vil tro at lidt simpel soeg og erstat kan goere denMySQL kompatibel

hvor finder jeg pg_dump? og vil d hjælpe med hvad der skal søges og erstattes?

MVH
DKR

jep

men det kan foerst blive senere

pg_dump ligger i PostgreSQL's bin dir

du kalder det med:

pg_dump -Ubrugernavn databasenavn > filnavn

du skal bruge CREATE TABLE sætningerne uden de helt store ændringer

og så skal COPY FROM STDIN erstattes af INSERT sætninger og hvis du bruger
multiple VALUES så er det heller ikke så tricky

databasen ligger hos surftown.dk, så jeg har den ikke lokalt.

MVH
DKR

så skal du jo kigge på surftowns database administrations værktøj

der er ikke nulighed for export/dump i deres phpPgadmin.

MVH
DKR

http://phppgadmin.sourceforge.net/index.php?page=faq

Q: What happened to the database dump feature?

A: You need to configure phpPgAdmin (in the config.inc.php file) to point to the location of the pg_dump and pg_dumpall utilities on your server. Once you have done that, the database export feature will appear.

Q: I would like to use the pg_dump integration for database and table dumps on Windows. How do I get pg_dump.exe on Windows?

A: To get the pg_dump utilities on Windows, you need to install PostgreSQL 8.0 for Windows. It is available for download here. Once you have installed that, set the pg_dump and pg_dumpall locations in the config.inc.php file to 'C:\\Program Files\\PostgreSQL\\8.0\\bin\\pg_dump.exe' and 'C:\\Program Files\\PostgreSQL\\8.0\\bin\\pg_dumpall.exe', or wherever you installed them.

Q: Why can't I reload the SQL script I dumped in the SQL window?

A: The following limitations currently exist in SQL script execution:

    * Only uploaded SQL scripts can contain COPY commands and for this to work, you must have PHP 4.2 or higher.
    * 'psql' commands such as '\connect' will not work at all.
    * Multiline SQL statements will not work, eg:

          CREATE TABLE example (
              a INTEGER
          );

    * You cannot change the current database or current user during the execution of the script.

We do intend to work on some of these limitations in the future, but some of them are PostgreSQL restrictions and we recommend using the 'psql' utility to restore your full SQL dumps.

dkr ?

lukket