Compare two databases for any differences
<p>I have one mysql database on staging server and another one on production server. Initially both were exactly same. Later there were some modifications made on staging database in terms of change in schema, adding or removing some tables etc. Now I need to compare staging server's database with the production database so that I can deploy and make changes in production.</p>

<p>I know there are some external tools that are available for this.
But I wanted to know if I can achieve this using some mysql commands, or write python programs to do this.</p>

<p>Please let me know if some one knows the solution for this. </p>