Dumb MySql Database from Parent to child

rubyonrails-talk
1

Hi, I am creating such an application in which there is multipal servers. Now there is parent server which has multipal child server . My original data is in parent server’s database. My problem is I want to dump all the data from parent database to child database. How would i do this?

My database is MySql 5.0

2

Have a read in the MySQL manual about Master / Slave replication. You (or your DBA) can set up this relationship in a few "clicks", and then the two databases will become identical and stay that way.

Walter

3

This link ought to help you quite a bit, as it did for me when I had to set up replication servers: http://dev.mysql.com/doc/refman/5.0/en/replication.html

Good luck.