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?
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.