Dumb MySql Database from Parent to child

Rails
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

On Jun 25, 2011, at 2:37 AM, News A. wrote:

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

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.