Restore visitors table!

[Cosmo]

Hey,

I just deleted the visitors table in mysql... (little mistake :D)

How can I restore the table? what is the needed query?

I'm using MySQL 4.0.24


Greetz
Cosmo

[Joe[y]]

you'll have to check with your host for a back up of that table - there's no such script to bring back the data...

if you just want the table itself back as it would have been brand new then:


CREATE TABLE IF NOT EXISTS {$prefix}visitors (
id int(11) NOT NULL auto_increment,
datetime datetime NOT NULL default '0000-00-00 00:00:00',
host varchar(100) NOT NULL default '',
referer varchar(255) NOT NULL default '',
ua varchar(255) NOT NULL default '',
ip varchar(255) NOT NULL default '',
ruri varchar(150) NOT NULL default '',
PRIMARY KEY (id)
ADD INDEX ( `datetime` ), ADD INDEX ( `referer` ), ADD INDEX ( `ip` )
)

[Cosmo]

When i enter this in the query, i get this:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '{$prefix}visitors (
id int(11) NOT NULL auto_increment,
d

[Connie]

when you do this try to find out, sometimes there is an option "MYSQL40"

if so use that, maybe that helps. It helped me after a syntax error like that

[Joe[y]]

yeah. would be better to just use phpymadmin

[Cosmo]

And what do I have to fill in in the phpmyadmin? Create myself a new table?
Or add it with the "query window'" (i'm noob:))