Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Can I use the mysqlhotcopy backup files to different machine which different MySQL version?

Thank you.

share|improve this question

if it's within same minor number of mysql (ie, 5.1.12 and 5.1.24 should be fine, but not 5.2.1) - should work without problems.

if you are going from older to newer version - should work without problems.

for both cases - run repair table on imported tables.

to be on the safe side - preferably set up virtual machine with same version of mysql as source host, restore your backup there. run proper mysqldump and import the date on the destination machine.

share|improve this answer

Your Answer


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