Title: Restoring Problem
Last modified: August 18, 2016

---

# Restoring Problem

 *  [ealvin](https://wordpress.org/support/users/ealvin/)
 * (@ealvin)
 * [20 years, 5 months ago](https://wordpress.org/support/topic/restoring-problem/)
 * 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](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)

 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [20 years, 5 months ago](https://wordpress.org/support/topic/restoring-problem/#post-278825)
 * Did you install WP then try to import ?
 *  Thread Starter [ealvin](https://wordpress.org/support/users/ealvin/)
 * (@ealvin)
 * [20 years, 5 months ago](https://wordpress.org/support/topic/restoring-problem/#post-278875)
 * 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](https://wordpress.org/support/users/ealvin/)
 * (@ealvin)
 * [20 years, 5 months ago](https://wordpress.org/support/topic/restoring-problem/#post-278964)
 * Help! I’m still stuck with this. Does anyone have any ideas or suggestions for
   me?
 * Thanks in advance for your help.
 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [20 years, 5 months ago](https://wordpress.org/support/topic/restoring-problem/#post-278965)
 * 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.

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 4 replies
 * 2 participants
 * Last reply from: [Mark (podz)](https://wordpress.org/support/users/podz/)
 * Last activity: [20 years, 5 months ago](https://wordpress.org/support/topic/restoring-problem/#post-278965)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics