Re: MySQL upgrade with mysqldump
If you have procs, triggers and events it could be best to also ensure you dump those. Granted you are dumping everything though.
This dump is primarily a backup. If you are doing an rpm update your data should remain in tack. Granted I do not know what versions you are updating to and from though. The mysql installer will do a mysql_upgrade to fix and update the current tables.
If you had to replace data by loading your file back you also can run mysql_upgrade to fix tables and conflicts.
Might also be a good idea to dump your data per database ( including the --routines --triggers --events ) so you can only replace aspects of each if required.
Just trying to help....
http://anothermysqldba.blogspot.com
Subject
Written By
Posted
Re: MySQL upgrade with mysqldump
January 28, 2014 05:48PM
February 05, 2014 09:14AM
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.