Michael, ----- Original Message ----- From: ""Michael T. Babcock"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, November 05, 2002 6:00 PM Subject: InnoDB recovery
> I have a table that accidentally had a query run on it that NULL'd a > certain field of the entire table. I have the data on old versions of > the binary table files from backup tapes, but have no idea how to get > this information out of those old binary table files. I unfortunately > don't have the update logs for a subset of the time period (but I've > recovered about 3/4 of the data from those already). > > Any ideas? if you have on tape old images of ibdata files and ib_logfile's, you can try crash recovery from them, possibly using innodb_force_recovery=6. > -- > Michael T. Babcock Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query > C.T.O., FibreSpeed Ltd. > http://www.fibrespeed.net/~mbabcock --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php