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

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

Thank you.

share|improve this question

1 Answer 1

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

 
discard

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