I cannot think of any safe alternative. Trying to recover files that
are in memory strikes me as very unwise with InnoDB.
Ananda Kumar wrote:
> Hi Baron,
> If the database is huge, the restoring from mysqldump would take lot of
> Is there any other alternative.
> On 9/26/07, Baron Schwartz <baron@stripped> wrote:
>>>> How do I recover them, and do you think this is wise? At this point, I
>>>> still think it might be a better idea to do a complete reinstall /
>>>> restore / transaction log run.
>> There's no need to reinstall :-) It's not MS Windows, it's just InnoDB.
>> As others have said, I'd try to do a global LOCK TABLES (I wouldn't do
>> a FLUSH TABLES because I'm not sure how missing files might be handled
>> -- it could crash) and a full dump. Then just shut down MySQL and
>> delete *all* the InnoDB files and let it initialize with fresh files on
>> restart, and import. You should be fine. But I'd do it ASAP because in
>> the meantime you could have a crash.
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=1