mysql 本地库 远程库 同步,使用phpMyAdmin同步MySQL远程和本地数据库

打开phpMyAdmin / config.inc.php,并添加关于“服务器配置”的这些​​行.

$i++;

$cfg['Servers'][$i]['host'] = ''; // Remote MySQL hostname or IP address

$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port

$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket

$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')

$cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli')

$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection

$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?

$cfg['Servers'][$i]['user'] = ''; // Remote MySQL user

$cfg['Servers'][$i]['password'] = ''; // Remote MySQL password

Now there is a ‘servers’ dropdown on your phpMyAdmin front page. Pick your sever and bingo!

而且,有很多例子,也许有帮助：