How to keep update one Mysql database with another MySQL database?

How to keep update one Mysql database with another MySQL database?

Post by Water Li » Fri, 20 Mar 2009 12:24:17


I have two Mysql databases. One is the master and the other is slave.

I need to keep update with slave database to keep some tables the same
as master database.

The first idea in my mind is to write a php script to read datas from
these tables and write into slave database.

But I still think it is a little complex to judge which code I need to
write into slave databse.

So, any good idea to do this job? Any tool I can use?


--
Water Lin

http://www.yqcomputer.com/
 
 
 

How to keep update one Mysql database with another MySQL database?

Post by Jerry Stuc » Fri, 20 Mar 2009 12:43:13


Database replication. Try comp.databases.mysql.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
XXXX@XXXXX.COM
==================