Database corrupted, need professional assistance.

[Theater]

Hello,

Unfortunately some tables in my database got corrupted and died a painful death. It happened at 7PM CST yesterday, and the initial cause was a network switch failure. This is the error message at that time:

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to MySQL server on '10.10.10.11' (4)
<<snipped my path>>/class_core.php on line 311

I have two servers for my community. One for the files, and the other for the database. The site was still up but not the database. After 8 minutes it seemed the switch issue had been resolved, but then I started getting several weird error messages:

Database error in vBulletin 3.8.2:

Invalid SQL:

SELECT IF(visible = 2, 1, 0) AS isdeleted,



thread.*


FROM thread AS thread






WHERE thread.threadid = 36357;

MySQL Error : Can't find file: 'thread' (errno: 2)
Error Number : 1017

Also:

Database error in vBulletin 3.8.2:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_adv_portal AS phrasegroup_adv_portal,
language.phrasegroup_calendar AS phrasegroup_calendar,
language.phrasegroup_postbit AS phrasegroup_postbit,
language.phrasegroup_prefix AS phrasegroup_prefix,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
, cmpspages.layout AS cmpslayout
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
LEFT JOIN adv_pages_user AS cmpspages ON (user.userid = cmpspages.userid AND cmpspages.pageid = 1)
WHERE user.userid = 69970;

MySQL Error : Can't find file: 'user' (errno: 2)
Error Number : 1017

Etc, etc. Anyway, I tried to have my managed host provider fix this with a repair option through the server since I wasn't able to log into my admin account to do it from AdminCP. They said they could not, so at this point I was going to have them use a backup. The only problem is that when they setup the new database server for us, they never implemented any backup procedure for that box so the only backup I have available is from 2 months ago.

I'm missing 15,000+ posts, a few thousand member registrations, not to mention a heck of a lot of work to the forum itself. So I do have the corrupted current database, and if anyone is willing to help I'd appreciate it. These are the tables they had listed as corrupted:

mydatabasename_dbase.postparsed mydatabasename_dbase.profilevisitor mydatabasename_dbase.search mydatabasename_dbase.strikes mydatabasename_dbase.tagsearch mydatabasename_dbase.thread mydatabasename_dbase.threadviews mydatabasename_dbase.user mydatabasename_dbase.useractivation mydatabasename_dbase.word

I have several mods installed, more recently vBExperience, and I think that mod in particular might have played a part in this if say the database server stopped communicating with the file server halfway through a cronjob. I don't know for sure, but I just have a gut feeling. I've PM'd the mod author to find out for sure.

Any ideas?