Support » Fixing WordPress » 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 KEY id ( 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

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘SQL restore error’ is closed to new replies.