SQL restore error
-
Hi there
In an attempt to upgrade from 2.9.1 to 3.0.1 my site crashed.
I tried to restore my database but got this error:“Error
SQL query:
CREATE TABLE
wp_StatSurfer
(
id
mediumint( 9 ) NOT NULL AUTO_INCREMENT ,
date
tinytext,
time
tinytext,
ip
tinytext,
urlrequested
text,
agent
text,
referrer
text,
search
text,
nation
tinytext,
os
tinytext,
browser
tinytext,
searchengine
tinytext,
spider
tinytext,
feed
tinytext,
user
tinytext,
timestamp
tinytext,
threat_score
smallint( 6 ) default NULL ,
threat_type
smallint( 6 ) default NULL ,
UNIQUE KEYid
(id
)
) ENGINE = MYISAM AUTO_INCREMENT =1374 DEFAULT CHARSET = latin1;MySQL said: Documentation
#1050 – Table ‘wp_StatSurfer’ already exists “I haven’t attempted to restore the site’s files yet from my backup as I thought the database would be better to do first.
(prior to the upgrade attempt I installed StatSurfer plugin and as it blocked my access to the dashboard I just deleted the files from my webspace)
please help
thanks a lot,
Yolanda
- The topic ‘SQL restore error’ is closed to new replies.