open source tool for comparing database schemas

Question

i need good open source tool for comparing two databases schema in Mysql

Answer 1

Export everything into a .sql file (those are pure text)

Then use a normal text diff program like kdiff3, meld or kompare.

Answer 2

You can use mysqldump with the --no-data option, save the output to a file for each DB, then diff the output using your preferred text diff tool.

Other options:

• Toad
• MySQLdiff

Answer 3

Try http://liquibase.org/.

UPDATE:
Here's how you do diff with liquibase: http://liquibase.org/manual/diff

Answer 4

Try mysql-diff: http://bitbucket.org/stepancheg/mysql-diff/ . It is command-line, and it can extract schema info from database or from SQL script file.