Menu
And how do I restore from my dump back to the db?
715
It is not possible to import an Oracle (binary) dump to PostgreSQL.
To dump/export a MySQL database, execute the following command in the Windows command prompt: mysqldump -u username -p dbname > filename. sql . After entering that command you will be prompted for your password.
You should have a look at the pg_dump and pg_restore commands.
pg_dump - extract a PostgreSQL database into a script file or other archive file.
pg_restore - restore a PostgreSQL database from an archive file created by pg_dump.
Please look at pg_dump(1) and pg_restore(1).
6
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
