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

I have spent most of the day optimizing a Mysql 5.0.x database – now I need to get the changes on to the production server

How do I make a backup of table’s index settings and then restore them on the production database server?

share|improve this question

1 Answer 1

You can do a mysqldump --no-data on both databases and diff them by hand. Alternatively, you could use something like SQL Fairy, which can diff two databases and output the SQL required to change one database's schema to match the other. I believe it can either work directly with the databases, or with the SQL generated with mysqldump --no-data.

share|improve this answer

Your Answer


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.