UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support mySQL snag - need assist!

I need a little mySQL help!

My forums aren't working as a result of a mySQL snag. Three of my tables are somehow locked ...or something.... and I can't make head or tail of it, not being a mySQL kind o' guy.

Using "phpMyAdmin", when viewing the main details page for all the tables, some tables indicate "in use" where normally there would be three fields populated with info in the columns "Records", "Type", and "Size".

When I click (from the phpMyAdmin left frame) to look at one of these tables (the "users" table for instance), I get an error message saying: "Can't open file: 'im_Users.MYD'. (errno: 144)".

When I try to Telnet a whole restore, I get "...ERROR 2000 at line 11: Error writing file './db28316e/im_AddressBook.frm' (Errcode: 28)".

My web host has been going though changes and I suspect that's how this happened, and getting through to them is not an option apparently, so I'd appreciate any help.

Thanks!

Joel

That usually has to do with some damaged tables.

Sometimes this happens if you are out of space with your web host. Verify that you aren't over your disk quota.

I would verify that first.

Then you can try running this Query in the SQL section of phpMyAdmin

REPAIR TABLE
w3t_Users


Do that for each table that's corrupt.

But I'm 95% certain that errno: 144 & errcode 28 is related to disk space. If that's the case... once you fix the space issues and repair the tables you should be good to go.

Sometimes you need to do some More Advanced repair functions to get things back on track. <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />

Hope that helps. <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />

Josh
www.joshuapettit.com
ThreadsDev.com Administrator | InfoPop Community Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
My threads 'tweaking' abilities are for hire for upgrades, tweaks and modifications.

Josh thanks a lot for your help.

It turns out it was beyond repair and I was able to create a new database and use my previous days' backup to get up and running again.

I think the data server crashed right in the middle of either a backup or an "optimize" and corrupted a few tables, rendering the whole thing a mess.

I can't stress the word BACKUP enough, folks! Saved my site!

Thanks again Josh for your excellent help.

Joel