Database Schema Comparison Tool/Script

Database Schema Comparison Tool/Script


Job Description

I am backing up, restoring and cloning websites and have found myself needing a quick and dirty tool to test that my MySQL tables match. The set of tables on database A may be prefixed by jhG7A5_ while the set of tables on database B may be prefixed by pGh56d_.

My idea is to have a script sitting on the same server as the MySQL server. I enter the names of both databases along with the prefixes (so it ignores them) and the script then outputs any isses to the screen. The data itself does not need to be checked, just the schemas and the script will not make any changes but simply be a reporting tool.

Not a massive job but hopefully interest someone.

Note: This script is to run a Linux server.

Skills: linux