On Thu, Jul 1, 2010 at 5:44 PM, Grant Peel <gp...@thenetnow.com> wrote: > Hi all, > > I have serveral servers running mysql 4, and need to update to mysql 5. > It would be good if mentioned what release of the various series you were using or wanting to upgrade to.
> I have version 5 setup on a new dev server and will be cloning that to the > old servers, then restoring all the data from backups (mysql databases > included). By restoring from backup for mysql a sql dump, or a filesystem backup? > > Once I have restored the data from backups, I will neeed to run > mysqlupgrade. > > My question is, will the mysqlupgrade script update all the mysql tables, > (grant tables etc), as well as update all the users databases, or will there > be other things that need to be done? > > -Grant It depends. The way I generally do upgrades is the following: 1. Identify the backup point for the current server. Do a 'mysqldump --all-databases --complete-insert' from it using the mysqldump from the version of mysql I will be using after the upgrade and record the 'show slave status' while it is running. 2. Import the backup on to the new server after removing any commands that would perform ddl on the mysql schema. 3. Setup replicaton and fail over to the new server at an opportune time. So, you should keep in mind a few things: 1. Between version of MySQL the table format changes, and it is generally worthing while to take advantage of the changes. 2. mysqlupgrade runs REPAIR TABLE which acts differently in different versions of MySQL See http://www.mysqlperformanceblog.com/2010/05/14/mysql_upgrade-and-innodb-tables/. -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
