Can't open file:'post.MYD'.(errno: 145)

[allan]

Hey VBulletin experts...Roseanne suddenly started having all sorts of errors on her board. I think the errors are related to a backup that went bad (I think the server reached 100% disk capacity during the backup).

My thought was to delete the database, and restore from the previous backup, but when I try to delete the database, I get the following error:


Can't open file:'post.MYD'.(errno: 145)


Umm...help :cry: (and quickly, so Roseanne doesn't kill me :cry2: )

[allan]

Oh, and one other thing I tried to google a solution and saw that someone suggested repairing table thread:


mysql> REPAIR TABLE thread;
+------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+------------------+--------+----------+----------+
| newmommie.thread | repair | status | OK |
+------------------+--------+----------+----------+
1 row in set (0.35 sec)


But, that did not help

[Chicken]

vB has a repair file that you can *try* to use to fix *some* things. It has worked for one problem I had, not worked for another. It's either already in the admin folder, or you have to upload it from the zip file. If you just type in the URL (domain.com/forumdir/admin/repair.php) it has very few instructions on how to use it. Very few.

[David]

You may have to use myisamchk to repair it depending on the damage.

[OKIHost]

Are you sure mysql has the correct permissions? I could not delete any databases and the issues ended up being that somehow the permissions for mysql were not owned by mysql anymore (this is an ensim box) mine was .(errno: 13)

If you are running Cpanel and have it to auto update you might want to take a look at this thread. I have set my updates for manual recently due to a few quirks in some of the updates like this.

http://forums.cpanel.net/showthread.php?s=&threadid=8740&

There was also someone at the Rackshack forums getting this error on a ibf forum so you might want to try this also if you can't find any other fix.

http://forum.rackshack.net/showthread.php?threadid=24212&highlight=errno+145

[suppleSupport]

Did you recently upgrade to mysql4? (= recurring table corruption)

[David]

Originally posted by elevation:

Did you recently upgrade to mysql4? (= recurring table corruption)
That was a CPanel issue that was fixed a while ago.

[allan]

Originally posted by Chicken:
If you just type in the URL (domain.com/forumdir/admin/repair.php) it has very few instructions on how to use it. Very few.

This seems to have worked :) -- at least for now. I am going to have to figure out another backup strategy though since I am running into diskspace limitations :(.

[Chicken]

Speaking of backups... I get a db backup via SSH and it creates a file, but any idea why I wouldn't be able to download that file via FTP? It doesn't show up in the listing (not even with -a).

To clarify: It DOES show up when you list the directory in SSH, but NOT when you FTP in.

[David]

Check your permissions.

[Chicken]

Ahhhhhh! DUH! That's why! I created the file as root! DUH DUH DUH! Was driving me crazy! It's there... but it's not... but it is... but it's not! ARRRRRGH!!!

:banghead: