Site down after repair and optimizing tables

[Xplosive60]

Received this error and site went down.

Database error in vBulletin 3.8.4:

Invalid SQL:
REPAIR TABLE `attachment`;

MySQL Error : Query execution was interrupted
Error Number : 1317
Request Date : Saturday, March 17th 2012 @ 12:10:10 AM
Error Date : Saturday, March 17th 2012 @ 12:11:47 AM
Script : hxxp://xxxxxxxxx/admincp/repair.php?do=dorepair
Referrer : hxxp://xxxxxxxxx/admincp/repair.php?do=
IP Address : xxxxxxxxxx
Username : xxxxxxxxxx
Classname : vB_Database
MySQL Version : 5.1.53

I have recently migrated from a linux shared server to a windows cloud hosting server and has been a nitemare since.
Also found attached errors ...
Any ideas?

[King Justice]

Can you try and repair and optimize the entire database and all it's tables in your server control panel or at least in phpMyAdmin?

[Simon Lloyd]

Don't do the entire database, just the ones that show in use (normally corrupt or crashed, if none show in use or corrupt then repair any that you had a database error for), if you cannot repair a crashed table you will need to get your host to search via ssh for the .TMD of that table and delete it, you will then be able to repair it.

[Xplosive60]

Sorry but i can't find anywhere to access these things. I'm new to this WebsitePanel
Can't find my.cnf file, there is no ect. folder. Site been down 3 days now and server saying it's a vbull issue..... sigh

[kh99]

I'm not familiar with WebsitePanel - I searched and found doc but didn't see anything about databases. Do you have any way to see your database (outside of vbulletin)?

[Xplosive60]

No i can't find any way to access database at all.

[Simon Lloyd]

Its a Dot Net Panel, check here http://support.othellotech.net/kb/in...d=448&relid=42

[Xplosive60]

Yes, when i do that is when i get the error.

[kh99]

Originally Posted by Xplosive60

Yes, when i do that is when i get the error.

Which error? In the first post you included an error that's from vbulletin so I don't understand why you'd get that error from phpMyAdmin. In any case, maybe you should contact your host and tell them you need to repair the database but you don't know how.

[Xplosive60]

The errors come when i try to get into databse. The host has finally fixed it but i don't know how or where. I have moved my attachments to file system to take the load off the database. I think that may have been root of the problem. Thanks for your help guys.