Hi Baron, If the database is huge, the restoring from mysqldump would take lot of time. Is there any other alternative.
egards anandkl On 9/26/07, Baron Schwartz <[EMAIL PROTECTED]> 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. > > Baron > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >