mysql error number: 1146

[Bass Cadet]

My host, Site5.com recently restored a database for me to fix your copyright information and when they did so I started getting this error:

Invalid SQL: 
		SELECT 
		userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
		IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
			language.phrasegroup_holiday AS phrasegroup_holiday,
			language.phrasegroup_global AS phrasegroup_global,
			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
		FROM user AS user
		INNER JOIN userfield AS userfield ON (user.userid = userfield.userid)
		INNER JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 
		WHERE user.userid = 1
	
mysql error: Table 'midsouth_sunshine.user' doesn't exist

mysql error number: 1146

After submitting a trouble ticket to you guys I was told they user table didn't exist. Well after 5 days of bouncing emails back with my provider (www.site5.com) I was told their backup was no good. Actually better yet here's the email I got from them...



Hello,
Sorry for late reply. We have the backup from November/12, do you want us to restore it for you?. If you want we can copy into your home directory as well. Please let us know.

Best Regards,
David Kathiramalai





Hello,

I have restored this database, you may need to reassign the user its permissions on it before it can acccess it.
--
Julian Villan





The user table here is gone, we may need to recreate from backup here.
Wish to proceed?

Warm regards,
Joe S.





Hello,

After multiple attempts to restore the database backup, it appears that the data required is not actually present within the backup or is beyond restoreable. Unfortunately this means you will need to restore this database from your own local backup.
Let us know if we can assist you with anything further.
--
Beau Henderson




Hi,

Neither the daily nor the weekly backup archives appear to contain a "user" or "users" table.
Could this table have been called something else?
Unfortunately we do not have any older backups available.
--
Vince Stratful







. . .

So is there ANYTHING you guys can recommend because my 5 year old website, members... donating members... everyone, everything is gone and I'm really upset, esp with Site5.

[Steve Machol]

If the backup is incomplete then I'm afraid the only option is to use one that is complete.