Skip navigation links

MySQL Forums :: Newbie :: Is mysqldump the best practice for migrating ?


Advanced Search

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


Subject Written By Posted
Is mysqldump the best practice for migrating ? Atnhony Gordon 01/28/2013 04:21PM
Re: Is mysqldump the best practice for migrating ? Rick James 01/30/2013 08:53AM


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.