replication

2003-07-25 Thread Nova Sano S. Surbakti
Hi all, I would like to replicate some tables from a database once a week. The slave server will dial-in to the master server. The tables type is InnoDB. - How could I know if the slave has finished the replication process? - How is the best way to recover data, if the connection broken while doin

Replication/Synchronization Scheme

2003-07-23 Thread Nova Sano S. Surbakti
I have a MySQL master server; it has some tables from a database that needed to be replicated once a day by some slave server, through a dial-in connection. How do you think is the best way to do that? Is the replication scheme in MySQL manual safe enough to do this? Anybody want to share some e