1) MySQL Workbench method:
Open workbench > File Menu > New Model. Then Database Menu > Compare Schemas. Select the source and destination database connection details (stored already; enter details if not stored). And keep on going to Next step till database comparison result/report is generated at the last step.
2) Command line method:
mysqldump --skip-comments --skip-extended-insert -u root -p dbName1>file1.sql
mysqldump --skip-comments --skip-extended-insert -u root -p dbName2>file2.sql
diff file1.sql file2.sql
Open workbench > File Menu > New Model. Then Database Menu > Compare Schemas. Select the source and destination database connection details (stored already; enter details if not stored). And keep on going to Next step till database comparison result/report is generated at the last step.
2) Command line method:
mysqldump --skip-comments --skip-extended-insert -u root -p dbName1>file1.sql
mysqldump --skip-comments --skip-extended-insert -u root -p dbName2>file2.sql
diff file1.sql file2.sql
No comments:
Post a Comment