OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
missing ibd files on upgrade of mysql from 4.1.9 to 4.1.12a

From: Jason Pyeron (jpyeronpdinc.us)
Date: Mon Jul 04 2005 - 12:13:16 CDT

I just lost a bunch of personal and work development projects whilst
upgrading to MySQL 4.1.12a (msi script).

I get errors like:
  ERROR 1016 (HY000): Can't open file: 'files.ibd' (errno: 1)

there are no .ibd files in any of the data directories.

I do have 3 very large files at the top.

[jpyeronMrLaptop data]$ du -h i*
18M ib_logfile0
18M ib_logfile1
10M ibdata1

I guess I am just not thinking straight enough to solve this one.

All MyISAM tables are fine.

oh, yes my backup was taking backups on the 'old' data location. DOH!!!

TIA

--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218 -
- -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information. If you
have received it in error, purge the message from your system and
notify the sender immediately. Any other use of the email by you
is prohibited.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql