First you need to add the following line into config.inc.php, the configuration file of phpMyAdmin.

$cfg['AllowArbitraryServer'] = true;

This will allow you to connect to remote server. Or you can just synchronize between local databases.

http://toyhouse.cc/profiles/blogs/synchronize-databases-by-phpmyadmin

Advertisements