Tracking MySQL Database Changes

Question

What tools do you use to track changes to your MySQL database?
I am currently participating in a project where we use a simple text file (the version is controlled via SVN), in which we manually add SQL statements when making changes to the database.
Many changes magically disappear every time and then, and now we are looking for the best way to change the tracking of our database.

EDIT:
One thing I forgot to mention is that we use stored procedures and functions, so not only the database structure we want to track changes to / version controll.

Answer 1

There is a simple solution:

• Make all changes to the database schema and static data through scripts
• Version controls scripts

Answer 2

Toad for MySQL has a great schema comparison tool

http://www.quest.com/toad-for-mysql/

Answer 3

, - ( Firebird, ): http://www.upscene.com/products.audit.index.php , MySQL, NO: (

MySQL, : http://solutions.mysql.com/solutions/partner.php?partner=1532

, , , ,

Answer 4

mysql-diff compares tables, but does not yet store procedures.