Hello. Anybody there?.OK. I'll go some way to solving my own problem.
Found this chunk of code
[PHP] // Source server settings
$from_user = "Put User Here";
$from_password = "Put password here";
$from_database = "Put Database name here";
$from_server = "Put Source Server here";
$from_41 = False;
// Destination Server Settings
$to_user = "Put User here";
$to_password = "Put Password here";
$to_database = "Put Database name Here";
$to_server = "Put Source Server here";
// $to_server = "localhost";
// Don't Edit below here!!!! (Unless you know what your doing).
if ($from_41) {
$theOpt = "--skip-opt ";
} else {
$theOpt = "";
}
$Results = system( "mysqldump $theOpt -h$from_server -u$from_user -p$from_password $from_database | mysql -u$to_user -p$to_password -h$to_server $to_database", $ResultErr );
echo "Results from MySQL import of $DatabaseName with User $User with file $TheFile:\r\n $Results\r\n $ResultErr";[/PHP]At the following address. Will try to make it work then report back!
- http://wiki.i40.com/MigratingmySQL