If you can identify the log files to apply, you can issue the following command: mysqlbinlog log_file_to_apply | mysql -h server-name
hth, SB -----Original Message----- From: Nils Valentin [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 5:53 PM To: gerald_clark; Subhakar Burri Cc: Keith C. Ivey; [EMAIL PROTECTED] Subject: Re: Best Practices for mySQL Backups in Enterprise Hi Gerald, Do you know some good information about it, seems like I need to brush up a bit on this. I dont understand how you want to do a roll forward for a MySQL table - especially if the backup is lets ay from 8 AM and the crash is at 2 PM. Best regards NIls Valentin Tokyo/Japan 2003年 6月 27日 金曜日 22:08、gerald_clark さんは書きました: > Yes, if you have transaction logging turned on. > You can edit the transaction log, and run it against the restored database. > > Subhakar Burri wrote: > >Can I roll forward if I do backups using Mysqldump? Say, I did backups > > using Mysqldump @ 8:00 AM and my instance crashed @ 2:00 PM. I can > > restore the tables (both Innodb and MyISAM tables) from my 8:00AM backup, > > but can I roll forward the data that changed after 8:00 AM or do I lose > > the data after 8:00 AM. Pls clarify... a link to relevant information > > would be just fine too... > > > >Thankx in advance > >SB -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils
