Unable to find file
Posted 15 February 2006 - 06:48 PM
We are having problems with our mysql database. Random sites display the message "Unable to open file blahblah.MYI"
Now I know normally this can be sorted by repairing the table. This helps temporarily but the problem then appears somewhere else.
I created a php script to go through every table in every database and repair then optimize each table. I run that but we are still getting the random errors.
Does anybody have any ideas?
Posted 15 February 2006 - 09:39 PM
We had a similar problem a few months back but it wasnt as bad as this. It seemed to sort itself out.
Its extremely frustrating as im sure you can imagine.
Posted 16 February 2006 - 08:27 PM
Just a question that one of the MySQL gurus can answer. What error message/erratic behaviour would a database generate when the MySQL server is tragically overloaded?
Posted 16 February 2006 - 10:09 PM
Posted 17 February 2006 - 02:29 PM
These are the repairs I would attempt, in order:
Try dumping all the data into a backup file with mysqldump and then use it to create fresh tables with all the same data.
Try dropping the whole database and recreating it from backup.
Try reinstalling mysql.
Try another hard drive.
Try another server.
Posted 17 February 2006 - 02:37 PM
It is a dedicated server. We are getting Error no 24.
I will try the dump and recreate the tables but there are about a hundred databases and several of them are huge so it may take a while.
Posted 17 February 2006 - 08:58 PM
Are these MyISAM tables or InnoDB tables? Is there nothing suspicious in the error log? What version of MySQL are you running (there are some known bugs regarding errno 24)?
Posted 25 February 2006 - 01:28 AM
I think I know how it has happened... My fault... We moved the databases from another server a while back and I was lazy and just copied the folders from the mysql data folder to the data folder on the new server. It worked but I think over time it has caused errors.
D'oh, I wont be as lazy in future and do things the proper way.
Ill let you know how I get on for future reference.
Posted 25 February 2006 - 08:46 AM
Posted 25 February 2006 - 09:42 PM
Anyway, I dumped the DB, removed MySQL and reinstalled everything. This hasnt helped.
I noticed when restoring the data that a few of the databases have invalid column names such as "fulltext" "date" etc etc. They errored out when I was trying to restore them. Could these be the cause of the problem?
Posted 25 February 2006 - 11:49 PM
Posted 28 February 2006 - 08:10 AM
What hardware would cause them sort of errors?
Many thanks for all you help with this.
Posted 02 March 2006 - 07:18 PM
Posted 02 March 2006 - 07:40 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users