- Development-And-Live-Database-Comparison-Script is a phpMyAdmin MYSQL Database Table & Column comparison script that will check the difference of tables and columns between 2 different DBs.
- The common use case for this is to compare the live DB and the test DB to check and see if there's any missing tables or columns between the two.
- Clone this project in whatever directory you want.
- Make sure to have PHP install in your system beforehand.
- Edit the php.ini and enable the mysqli extension. Sauce: https://stackoverflow.com/questions/54500881/how-do-i-enable-mysqli-for-my-php-script/54501457
- Make sure to allow remote MYSQL for your IP to access the DBs
- Go into the Development-And-Live-Database-Comparison-Script folder you just installed.
- Edit the cross_checker.json for the DBs you want to cross check
- Run this in your favourite terminal
cd "[your_directory]\Table_Column_Cross_Checker"
php db_cross_check.phpEnjoy! o(=´∇｀=)o