MySQL Forums
Forum List  »  Newbie

Is mysqldump the best practice for migrating ?
Posted by: Atnhony Gordon
Date: January 28, 2013 04:21PM

The company I work for has a staging and production environment. They want me to create a script that eventually migrates the staging DB to the Production DB. I would like for this to be in a script so I can either setup a cron job or add it to a build server. My question is, using mysqldump the best way to do this ? Would this be something a OPT team would consider doing? What type options would I need to include to get it to only append new DB structures and Data instead of deleting everything and rebuilding the database all over again ?

Thanks in advance.

Options: ReplyQuote

Written By
Is mysqldump the best practice for migrating ?
January 28, 2013 04:21PM

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.