MySQL Forums
Forum List  »  Backup

Should we use mysqldump or mysqlpump?
Posted by: Gardner Hui
Date: March 22, 2017 05:59PM

We export an entire database, gz compress the files, transfer to another network, and reload the DB. Currently we use mysqldump and the export took about 2 hours. I noticed that mysqlpump does essentially the similar thing and wonder what are the differences of the two utilities. Should we use mysqlpump instead since it allows multi-thread? Is mysqlpump similar to the Oracle data pump where the dump files are generated on the DB server rather than on the client computer where the utility program, such as mysqldump, is running?

We may not have the UNIX login to access the source DB's server so if mysqlpump generates the files on the server, then we can't use it.

Any suggestions?

Options: ReplyQuote


Subject
Views
Written By
Posted
Should we use mysqldump or mysqlpump?
1014
March 22, 2017 05:59PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.