Transfer data in one of mysql table

propertyagent · 06-14-2012, 09:48 AM

Hallo I need a php script to make one of the table in mysql always update among server. I have one server that have continual data entry and need to be transfer to other hosting. any ideas is welcome. thanks

Kustom42 · 06-14-2012, 12:12 PM

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

Kustom42 · 06-22-2012, 11:20 AM

MySQL replication actually isn't that hard to implement, I don't know of another solution.

Here are some third party guides that might help a bit more:

http://www.howtoforge.com/mysql_mast...er_replication -- how to setup master-master where both mysql servers replicate to each other.

http://www.ovaistariq.net/565/settin...on-with-mysql/ -- how to setup master-slave where only one mysql serve replicates to the other.

Kustom42 · 06-22-2012, 11:21 AM

If you run into a question along the way let us know and we can point you in the right direction. First thing to do is make sure both servers have mysql installed.

Habitual · 06-22-2012, 02:06 PM

http://steveswanson.wordpress.com/20...l-mysql-table/

Kustom42 · 06-22-2012, 02:32 PM

That's not what hes looking for habitual. Exporting and importing a database manually do not keep the tables in sync. This solution was discussed in my original posting via cron jobs.