. 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
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月
y
initial question of can I roll forward the changes to both table types ... Am I
missing something? Please clarify
SB
Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Friday, June 27, 2003 11:39 AM
To: [EMAIL PROTECTED]
Subject: Re: Best Practices for mySQL Backups in Enter
Ok, update log.
Jeremy Zawodny wrote:
On Fri, Jun 27, 2003 at 08:08:40AM -0500, gerald_clark wrote:
Yes, if you have transaction logging turned on.
You can edit the transaction log, and run it against the restored database.
MyISAM doesn't have transactions.
Jeremy
--
MySQL General M
On Fri, Jun 27, 2003 at 08:08:40AM -0500, gerald_clark wrote:
> Yes, if you have transaction logging turned on.
> You can edit the transaction log, and run it against the restored database.
MyISAM doesn't have transactions.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yah
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 ta
Hi Subhakar,
I would be interested to know what you mean with roll forward ?
In case you have another backup let's say @10AM you could use this one, but if
you dont have another backup where do you want to do a roll forward from ??
Do I miss something here ??
Best regards
Nils Valentin
Tokyo/
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 aft
