Is this a total loss? Database issue...
 

Hello, I was directed to post here from vB.org:

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:

Quote:
Database error in vBulletin :

mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '10.10.10.11' (4)
/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:

Quote:
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:

Quote:
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:

Quote:
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
====

Looking into it more in phpmyadmin now I see that my THREAD table is empty, and my USER table only has 21 entries out of nearly 80k. The POST table does seem to be okay along with several others. I don't suppose there is anyway to regenerate either table is there?

Also, is there a way to setup a user through phpmyadmin so I could make it an admin to log into my AdminCP to pull down my latest style file at the very least?