Problem restoring backup

[lange]

I restored my vb 3.0.0. All seems working but I have no searchindex and session tables.

How to fix it ?

thanks

[Zachery]

Did you just upgrade? or import?

[lange]

No.

Backup 18 MB database done with CP admin. Backup was not completed.

[Steve Machol]

I don't understand. If the backup was not completed then restoring it will not work.

[lange]

My VB is working.

I just check the default vB3 tables http://www.vbulletin.com/forum/showp...73&postcount=6 and compare the list with the list in my AdminCP Import&Maintenance/Repair Optimize tables.

I don't see searchindex and session in the list.

[Steve Machol]

Well there is no searchindex table in vB3. To recreate the session table, run this query:

CREATE TABLE session (
sessionhash varchar(32) NOT NULL default '',
userid int(10) unsigned NOT NULL default '0',
host varchar(15) NOT NULL default '',
lastactivity int(10) unsigned NOT NULL default '0',
styleid smallint(5) unsigned NOT NULL default '0',
location varchar(255) NOT NULL default '',
althash varchar(32) NOT NULL default '',
badlocation tinyint(3) unsigned NOT NULL default '0',
inforum smallint(5) unsigned NOT NULL default '0',
inthread int(10) unsigned NOT NULL default '0',
incalendar int(10) unsigned NOT NULL default '0',
loggedin smallint(5) unsigned NOT NULL default '0',
idhash varchar(32) NOT NULL default '',
useragent varchar(100) NOT NULL default '',
bypass smallint(6) NOT NULL default '0',
PRIMARY KEY (sessionhash)
) TYPE=HEAP;

[lange]

I don't understand. In Import & Maintenance/Repair Optimize Tables, I don't see a session table.

In phpMyAdmin, I see a session table (3.6 kb).

[Steve Machol]

The session table is HEAP and as such it does not respond to the Repair/Optimize commands. This is normal.