A MySQL table definition diff tool?

[eluser]Daniel H[/eluser]
Guys -

OT from CodeIgniter here, but can anyone think of a tool that compares the definition of two MySQL databases and generate the appropriate MySQL statements to amend the tables of the 'target' database while leaving the data untouched?

Any ideas?

Thanks,

Dan.

[eluser]Sean Murphy[/eluser]
Looks like this will do what you want: http://www.mysqldiff.org/

Also, there's the perl route: http://www.adamspiers.org/computing/mysqldiff/

[eluser]Daniel H[/eluser]
This is a great help thanks. I'm going to experiment with Navicat's sync functionality first and then move onto this if it doesn't perform.