Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Can't touch two files.. i/o errors!

[Dan Grossman]

In one of my MySQL databases, I have several thousand tables. MySQL stores each table as a separate file (well, files). I noticed in my normal routine of running mysqlcheck over the database that two had become corrupted, which isn't that unusual. It happens.

Usually I just run mysqlcheck --repair on the table, it fixes it, and I move on. That didn't work. OK, next step, I shut down MySQL and run myisamchk on the table file, that *always* fixes it. No good, gives me an error writing to the file I've never seen before.

Then I go and see if I can copy the file out and take a look at it alone. I try moving one of the two corrupted table files:

cp: reading `counter_premium/_3928_log.MYI': Input/output error

What could mess up two individual files so bad that they give I/O errors?

[Scott.Mc]

If you are getting I/O errors it's possible there is something wrong with that partition, I suggest you back it up first and then fsck it. It's highly likely that you may even loose those files(well they may be somewhere in lost+found).

-Scott

[rghf]

If you run dmesg is there aything obvious in there?

[Dan Grossman]

Originally Posted by Scott.Mc

If you are getting I/O errors it's possible there is something wrong with that partition, I suggest you back it up first and then fsck it. It's highly likely that you may even loose those files(well they may be somewhere in lost+found).

-Scott

Thanks for the tips. This drive is just a single large partition. Is it safe to run fsck on it while in use? If not, what's the best way to do so?

[rghf]

You can't do a live fsck it has to be taken down to single user mode. I would do a full backup right now before doing anything else

[Dan Grossman]

Originally Posted by a2b2

You can't do a live fsck it has to be taken down to single user mode. I would do a full backup right now before doing anything else

And how do I do that without physical access?

[rghf]

Is it just those files that are playing up or are there other. Hit me up on AIM (a2b2support) and happy to guide you through it