• My web host moved my server so I’m in the process of reinstalling my blog. I’ve uploaded the newest WP version and my theme without problem. However, in attempting to restore my database I got the following error.

    SQL query:

    — phpMyAdmin SQL Dump
    — version 2.6.3-pl1
    http://www.phpmyadmin.net

    — Host: localhost
    — Generation Time: Nov 03, 2005 at 07:01 PM
    — Server version: 4.0.26
    — PHP Version: 4.3.11

    — Database: visitor_wordpress

    — ——————————————————–

    — Table structure for table blacklist

    CREATE TABLE blacklist (

    id int( 11 ) NOT NULL AUTO_INCREMENT ,
    regex varchar( 200 ) NOT NULL default ”,
    regex_type enum( ‘ip’, ‘url’, ‘rbl’, ‘option’, ‘auto-url’, ‘auto-ip’, ‘regex-url’, ‘regex-ip’ ) NOT NULL default ‘url’,
    PRIMARY KEY ( id ) ,
    KEY id ( id ) ,
    FULLTEXT KEY regex ( regex )
    ) TYPE = MYISAM AUTO_INCREMENT =2239
    MySQL said:

    #1050 – Table ‘blacklist’ already exists

    Any ideas? Thanks.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Did you install WP then try to import ?

    Thread Starter ealvin

    (@ealvin)

    Yes, I installed the newest version of WP on this new serever. I then added my personal theme, then attempted to restore my db from the backup. It was at this point where I receive the error. Any ideas?

    Thread Starter ealvin

    (@ealvin)

    Help! I’m still stuck with this. Does anyone have any ideas or suggestions for me?

    Thanks in advance for your help.

    Try opening the db file and deleting the complete blacklist part – the table_create part and the chunk of data that follows.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Restoring Problem’ is closed to new replies.