Not the answer you need?
Register and ask your own question!

similar tools to mysqldiff

rei125rei125 EntrantCurrent User Role Beginner
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.

Comments

  • martin.arrietamartin.arrieta Member Inactive User Role Beginner
    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.
  • rei125rei125 Entrant Current User Role Beginner
    <cite>martin.arrieta wrote on Wed, 25 July 2012 11:47</cite>
    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.

    ic, thank you so much for the reply :)
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.