Question : I’m running out of space from my hard drive which has a 18GB PostgreSQL database. When I try […]
Tag: dump
how to track progress of a large postgres dump
Question : Is there a way to see the progress of a pg_dump operation on a big db (ie > […]
Multiple concurrent sql dumps in mysql
Question : My question is whether it is safe to perform multiple dumps at the same time in mysql, i.e. […]
Restore large MySQL dump thorugh EasyPHP
Question : I am trying to upload large files on easyphp but as there is limitation on this software and […]
Moving data between Oracle and PostgreSQL
Question : For a future project I need to use the following setup: Some small (offline) data boxes (collecting data […]
Change pg_dump directory output to table name instead of object number
Question : pg_dump -F d will result in multiple <number>.dat.gz files which represent the object number in the database. I […]
Postgres database dump and restore on different database [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Dump Oracle database into a textual SQL script
Question : I am thinking on what mysqldump or pg_dump are doing. So, they dump an active database into a […]
How to import only a specific database from a .sql file?
Question : I have a file dump.sql with many databases in it: mydb1, mydb2, mydb3, etc. How to import only […]
Restoring dump(backup): ERROR 1022 (23000) at line 44: Can’t write; duplicate key in table
Question : I’m doing tests to change a current table from my InnoDB database to Archive, but I had a […]