MySQL Server Migation

dbs.php

<?php

$host = 'remotehost.com';

$servers = array(
	'db/username' => 'password',
);

foreach ($servers as $db => $pw)
{
	$command = strtr('mysqldump -u:db -p:pw :db | ssh :sv "mysql -u:db -p:pw :db"', array(
		':sv' => escapeshellarg($host),
		':db' => escapeshellarg($db),
		':pw' => escapeshellarg($pw),
	));
	shell_exec($command);
}

This works best when your server is set up to login using pubkeys, so that you don't have to type your password for every database.