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.

We are in the process of preparing a data migration of some fairly big DB (200GB), InnoDB tables from our old server to the new servers. The data is very index heavy and trying to migrate the data via the preferred way, using mysqldump, takes a misserable 3-4 days. Most time is spend working the indexes. This also made us think about the data recovery in case we ever need to restore from a backup. 3-4 days is not really acceptable.

Q1. Does anyone have some good advice / experience regarding the migration / dumping / recovery of large, index heavy InnoDB databases?

We are now thinking about copying the binary data files from one server to the other. But I'm very unsure if this will be handled well using 2 different versions of the MySql server.

Q2. Does anyone have experience regarding this type of migration. Did it go well?

Any tips are greatly appriciated!

share|improve this question
add comment

2 Answers

Check this: http://dev.mysql.com/doc/refman/5.6/en/innodb-migration.html Imho, best way is create mysqldump, and after upgrade database. If something goes bad, just load dump back.

share|improve this answer
add comment

If you are looking for a fastest way, you can try mysql_upgrade program. Copy the binaries and run the program to check and fix compatibility. Don't forget to backup first.

share|improve this answer
add comment

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.