Announcement

Announcement Module
Collapse
No announcement yet.

similar tools to mysqldiff

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.

  • #2
    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.

    Comment


    • #3
      martin.arrieta wrote on Wed, 25 July 2012 11:47
      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

      Comment

      Working...
      X