Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm running MySQL 5.0 in production on CentOS. How do I migrate to Percona Server 5.1 safely?

The documentation of Percona Server doesn't include any information on migrating. Any help is greatly appreciated.

share|improve this question

3 Answers 3

up vote 0 down vote accepted

At a guess I'd say mysqldump your database from MySQL and reimport it into the Percona server.

I don't know if you can just fire up Percona server pointed to the same datadir as MySQL. Might be worth investigating.

share|improve this answer
1  
You can just install Percona Server over MySQL. It is binary compatible. –  Aaron Brown Jan 29 '12 at 22:17

The data files are compatible with percona server. You just need to start percona server mysqld and everything will work.

Only when you enable some features (like extra rollback segments) on percona server, you might not be able to go back to mysql. but you rarely need to change this parameter.

share|improve this answer

It's pretty much the same upgrade path from 5.0 to 5.1, of course to make better use of Percona enhancements you should consult the wiki.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.