Allow DB synchronisation in PHPMyAdmin

phpmyadmin has a useful feature to allow the ability to synchronise dbs from different servers. This is useful if you want to sync your production db to you dev db for example.

In the phpmyadmin in your dev machine, add the following

$cfg['AllowArbitraryServer'] = 1;

then go to the phpmyadmin dashboard and click on the synchronize option. the source db is your production db.

After clicking on the synchronize button and waiting for a while, you will be presented with a comparison table consisting of the differences between the 2 dbs. check the “Would you like to delete all the previous rows from target tables?” As we want similar tables. Then click on “synchronize database” again.