You need to setup mysql slave replication if you want to implement the correct solution. Otherwise you can setup a cron on the current server to use mysqldump to dump the table, then scp it to the remote server and have a cron on the remote server to import it.
The second solution is not advisable due to table locks, etc. that can cause issues.
Read about replication here: dev.mysql.com/doc/refman/5.1/en/replication-howto.html
|