Mysql 5.0 to Percona Server 5.1 (no SQL dumps)

davidb2002 · March 18, 2011, 4:36am

I am currently running MySQL 5.0.x and would like to move to the latest Percona Server 5.1 version. However, from what I understand, it has to be done through SQL dump files. This could take quite sometime due to the size of the databases I am running.

Is there any way to do the upgrade without the need to SQL dump files so the upgrade finishes faster and thus less downtime?

Thanks!

sterin71 · March 18, 2011, 5:30am

davidb2002 wrote on Fri, 18 March 2011 11:06

Why do you say that?
Within the 5.x tree you should be able to just be able to run the mysql_upgrade script and switch out the old binary and in with the new one.

davidb2002 · March 18, 2011, 5:31am

Yea, i noticed shortly after posting that I was completely wrong. Sorry to waste anyone’s time.

Topic		Replies	Views
Migrating from MySQL 5.5.9 to Percona 5.5 Other MySQL® Questions	2	443	February 13, 2012
Upgrade 5.0.98 to 5.x Other MySQL® Questions	2	684	March 8, 2013
MySQL to Percona Server Other MySQL® Questions	1	1216	July 20, 2013
Easiest way to go from mysql 5.0.77 to percona 5.5 Other MySQL® Questions	4	725	August 25, 2011
Updating Percona Server Other MySQL® Questions	2	463	October 10, 2013

Mysql 5.0 to Percona Server 5.1 (no SQL dumps)

Related topics