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

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

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.