We have been using MyISAM tables with MySQL merrily for about 18 months. Recently we upgraded to MySQL 4.1, and even more recently, we converted some of our MyISAM tables (which needed transactional support) to InnoDB.
After some configuration issues - the worst of which was the need to use a symbolic link to redirect the data directories for MySQL to another disk partition (our /usr/lib directory did not have sufficient space allocated to support the data stores), we got things working, and they have been working for about a month. Today, however, we lost all of the InnoDB tables in one of our databases. Upon examining the MySQL data directory, we discovered that the .frm files for these three tables were gone (although the ibdata1 file was still there). These same tables were still working fine in another of our databases (dev1 vs. dev2 - both of which share the same ibdata1 file), so we copied the .frm files from that database's data directory over, and once we did this, the tables re-appeared, complete with the correct data that had been originally loaded into these tables prior to their disappearing. So, it appears that while the data file was fine, the .frm files were somehow deleted. Anyone seen this happen before? Any insights would be very much appreciated! Regards, Geoff Thompson Avaion Support [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> http://www.avaion.com <http://www.avaion.com/>
