Restore Problems

[netman]

My server crashed last night and the host had to recover my db files from the old hd. I am trying to restore my forum now and get an error.

There seems to have been a problem with the RC-Monster Forums database.
Please try again by clicking the Refresh button in your web browser.
An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.
We apologise for any inconvenience.



The db the host gave me were all the frm, MYD, and MYI files. I uploaded all these files after recreating the db but still get this error. What else do I need to do to get this to work?



thanks.

[Colin F]

It seems you didn't restore the entire database. Best you ask your host to restore the database.

[jasonlitka]

Your `session` table is missing. You should fill out a support ticket to get the SQL query needed to recreate it.

They should send you back something like the following (which is for 3.6.4):

CREATE TABLE `session` (
  `sessionhash` char(32) NOT NULL default '',
  `userid` int(10) unsigned NOT NULL default '0',
  `host` char(15) NOT NULL default '',
  `idhash` char(32) NOT NULL default '',
  `lastactivity` int(10) unsigned NOT NULL default '0',
  `location` char(255) NOT NULL default '',
  `useragent` char(100) NOT NULL default '',
  `styleid` smallint(5) unsigned NOT NULL default '0',
  `languageid` smallint(5) unsigned NOT NULL default '0',
  `loggedin` smallint(5) unsigned NOT NULL default '0',
  `inforum` smallint(5) unsigned NOT NULL default '0',
  `inthread` int(10) unsigned NOT NULL default '0',
  `incalendar` smallint(5) unsigned NOT NULL default '0',
  `badlocation` smallint(5) unsigned NOT NULL default '0',
  `bypass` tinyint(4) NOT NULL default '0',
  `profileupdate` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`sessionhash`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1;

[netman]

I think my problem is I dont have a full backup. It only gives me 53 tables.

[Steve Machol]

That is definitely a problem. I'm afraid that db is worthless. You will need to get the complete database.