By hadishon on
I need the mysql sql to drop and add a fresh sessions table into my database. My current one has crashed and using the repair function isn't working.
I think it's something like this but this isn't working, something is wrong:
DROP TABLE 'sessions'
CREATE TABLE 'sessions' (
'uid' int unsigned NOT NULL,
'sid' varchar(64) NOT NULL default '',
'hostname' varchar(128) NOT NULL default '',
'timestamp' int NOT NULL default '0',
'cache' int NOT NULL default '0',
'session' longtext,
KEY uid ('uid'),
PRIMARY KEY ('sid'),
KEY timestamp ('timestamp')
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Can anyone help?
Comments
I also need it to be
I also need it to be compatible with D5.10