> -----Mensagem original----- > De: Renato Cramer > Enviada em: quarta-feira, 2 de junho de 2004 11:07 > Para: Lista MySQL (E-mail) > Assunto: Restore from Backup done with Replication features > > Dear Friends, > > Considering what a backup is done with the method following: > 1. One master server replicate to one slave server. > 2. The master server handle all manipulations and transactions of > data (all tables are InnoDB type). > 3. The slave server is exclusively used for to make backups. > 4. The replication of the slave server is interrupted (stop slave > statement). > 5. The slave server is correctly shutdown. > 6. One copy of the MySQL's data directory is done via operating > system commands. > 7. The slave server is started. > 8. The replication of the slave server is started (start slave > statement). > > In case problems with the master server, where is needed restore data from > backup, is done the following: > A. One copy is restored to MySQL's data directory in master server > and also in slave server. > B. The master server is started. > C. The slave server is started. > D. The replication of the slave server is started. > > My questions are: > - The copy restored (A) will function in both servers? > - The restart of the slave's replication (D) must be done with reset slave > or start slave statement? > - Exist a better method (1-8) to make consistents backups of the > transactional databases without interrupt or block the master server and > without use the InnoDB Hot Backup tool? > > All sugestions will be welcome. > > Thanks in advance, > > Renato Cramer.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]