MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

Re: How to resync the databases after a period of offline
Posted by: Dominik Klein
Date: September 29, 2006 04:58AM

If you use MyIsam tables, you can use "load data from master" to get all data from the master.

If you are using InnoDB tables, you can either dump all data and re-insert it or you could copy database files while the master is offline (or use innodb hotcopy which is not free).

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
How to resync the databases after a period of offline
5563
Madeleine Thach
September 28, 2006 03:01AM
Re: How to resync the databases after a period of offline
2476
Dominik Klein
September 29, 2006 04:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.