How do you track database changes?

Is there any tool that can compare the development database and the public database开发者_JAVA百科?

Redgate software have a schema comparison tool called MySQL Compare, which I have used to great effect before. When we had an issue with our databases getting out of sync. It is in early access/beta so it is currently free.

Unfortunately it is Windows only and I have not tried it under Wine on linux.

Redgate Software bundle has both data and schema compare. I've been using them happily without looking back.

PS: It is for SQL Server only though...

I ended up using Navicat for MySQL.