similar tools to mysqldiff

Hi,

I’m using percona mysql now, and i would like to check the table definition for tables in my database and i was browsing through the Percona toolkit.
I am looking for tools which works similar like mysqldiff, which diff only the definition (including partition), and print out the ALTER statement after comparing.

I couldnt find any tools to this in the Percona kit.

Is it that it’s not available, or i missed out something?

Thank you.

No, there is no tool from percona toolkit to do this.

Anyway, you can easily find the differences with mysqldump --no-data and diff.

Regarding mysqldiff… if it works for Community MySQL version it should work for Percona Server too.

Martin.

martin.arrieta wrote on Wed, 25 July 2012 11:47

ic, thank you so much for the reply :slight_smile: