Re: Ouch! ibdata files deleted. Why no catastrophe?

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 <baron@xaprb.com> 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/mysql?unsub=anandkl@gmail.com
>
>
Received on Wed Sep 26 09:04:02 2007