Copying remote tables to local database

[nicdp]

Is there a query/string to copy all the remote tables of a remote database to a local database?

[Pig]

AFAIK, there is no command to copy remote to local in one step. There are applications that do that (mysql front, I think). You can also just get a dump of the online data and run the resulting .sql file on your local db.

[leetcrew]

this code might help you

$cid1 = mysql_connect ("192.168.0.4", "root", "K4HVD01365");
$cid2 = mysql_connect ("localhost", "root", "K4HVD01365");

$db1 = mysql_select_db("hci", $cid1);
$db2 = mysql_select_db("hci", $cid2);


##############
# copy users #
##############

$sql1 = "SELECT * FROM `_hci_users`";
$retid1 = mysql_query ($sql1, $cid1);
while ( $row1 = mysql_fetch_array($retid1) )
{
	echo "<br>Importing user " . $row1['username'] . "... ";
	$sql2 = "INSERT INTO `_hci_users` VALUES('" . $row1['id'] . "', '" . $row1['username'] . "', '" . $row1['password'] . "', '" . $row1['email'] . "', '" . $row1['group'] . "')";
	if ($retid2 = mysql_query ( $sql2 , $cid2 ) )
		echo "done!";
	else
		die ( mysql_error() );
}

[nicdp]

You're right. This way I can also put in a script to check if the same row already exist locally... getting newer rows from remote and deleting local rows not prsent on remote.

Great! It was so simple.. but I didn't think about it! 🙂