If you choose to copy the files I would ensure that you are getting the innodb binary logs as well if they do not exists in the mysql data directory. The innodb backup tool or even mysqldump may provide a more consistent snapshot. ... If you restore to the master and you want to ensure a replication is starts again one solution is: Master Server: *Apply backup *Clear binary logs *Start master
Slave Server: *Apply backup *Clear binary and relay logs *Delete master.info file *Start slave *Check to see if slave is running and connected to the master -----Original Message----- From: Renato Cramer To: Lista MySQL (E-mail) Sent: 6/3/04 6:52 AM Subject: My question is too idiot for nobody answer? > -----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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
