Peer review maatkits mk-parallel-dump and mk-parallel-restore usage?

Question

Hiya

Im trying to make use of maatkit as a means of dumping a database and then restoring to another database.

For dumps: mk-parallel-dump --user abc --password xyz --databases $db --base-dir /tmp/dump

For restore: mk-parallel-restore --create-databases --user abc --password xyz --database devdb /tmp/dump

My question is, is my logic and understanding correct, and would it be ok to do it like this.

Kind Regards Brent

Answer 1

Yes, that should work as expected. However, do some benchmarks on the time using Mysqldump and Maakit's parallel dump. It is not always faster in our experience.