Saturday 28 July 2007 9:42:54 pm

Hello Greg!

I would backup all your work the best you know how to first. I would also backup your entire mysql installation, specifically directory where your database files are saved.

To test that you can restore this backup I would move these files asside, extract your backup and start your mysql server. With the backup confirmed functional for your needs I would then continue to seek a solution to this specific error.

Google has a number of related references, http://www.google.com/search?q=+Can%27t+open+file%3A+%27.ibd%27+&ie=utf-8&oe=utf-8&aq=t&rls=com.ubuntu:en-US:official&client=firefox-a

And this one seems to be fairly specific on how to solve the problem,
http://forums.mysql.com/read.php?22,34050,52933

MySQL AB :: MySQL 5.0 Reference Manual :: 5.9.1 Database Backups
http://dev.mysql.com/doc/refman/5.0/en/backup.html

Reference which mentions briefly renaming the mysql dir as a way to backup the whole thing
http://www.analysisandsolutions.com/code/mybasic.htm#backup

I have not used that OS in some time so I can't speak with certainty but when every I need to mess with mysql storage files I backup the whole thing, which in the past has worked very well for me in similar situations. hth ...

Cheers,
Heath

Brookins Consulting | http://brookinsconsulting.com/
Certified | http://auth.ez.no/certification/verify/380350
Solutions | http://projects.ez.no/users/community/brookins_consulting
eZpedia community documentation project | http://ezpedia.org