I don't know Linux that well, but I know that HP-UX lets you do most anything to an open file, including deleting it. The file will continue to exist as long as it is open by at least one process. If I remember correctly, this is all about the inode use count vs. the directory entry, or something like that. The file will actually be safe so long as it is not closed by the last user.
Those files will go away as soon as they are closed, so the database should be dumped before shutting down mysqld. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -----Original Message----- > From: Martijn Tonies [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 26, 2007 10:07 AM > To: Ananda Kumar; Baron Schwartz > Cc: Gary Josack; Daniel Kasak; mysql@lists.mysql.com > Subject: 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. > > Well, not deleting the InnoDB files would be a good start. > > The files were deleted, what do you expect?? Just continue running and > hoping no-one finds out? > > Re-creating them sure sounds the safest option to me! > > Martijn Tonies > Database Workbench - tool for InterBase, Firebird, MySQL, > NexusDB, Oracle & > MS SQL Server > Upscene Productions > http://www.upscene.com > My thoughts: > http://blog.upscene.com/martijn/ > Database development questions? Check the forum! > http://www.databasedevelopmentforum.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]