Title: Database exists
Last modified: August 19, 2016

---

# Database exists

 *  Resolved [team_mda](https://wordpress.org/support/users/team_mda/)
 * (@team_mda)
 * [15 years, 6 months ago](https://wordpress.org/support/topic/database-exists/)
 * I’m transferring a blog to a new server. The current blog is running on 2.9.1.
   I’m using Plesk 8.3 on the old server and 9.0.1 on the new server.
 * 1. I created the new blog (wordpress 3.0) from the application vault.
    2. I used
   the same db name as the old one as well as the same passwords from the old one.
   3. I backed up the old db from the 2.9.1 blog following the instructions at wordpress.
   4. I then proceeded to open phpmyadmin on the new server, clicked import (radio
   button for SQL was on) after browsing for the backed up version.
 * After that, I received this error:
 *     ```
       SQL query:
   
       --
       -- Database: <code>marc_mysql...(removed for security)</code>
       --
       CREATE DATABASE <code>marc_mysql...(removed for security)</code> DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
   
       MySQL said: Documentation
       #1007 - Can't create database 'marc_mysql...(removed for security)'; database exists
       ```
   
 * Any help is much appreciated.
    Thanks,

Viewing 8 replies - 1 through 8 (of 8 total)

 *  [esmi](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [15 years, 6 months ago](https://wordpress.org/support/topic/database-exists/#post-1676786)
 * You need to install 2.9.1 – not 3.0.1 – import your database and then upgrade
   to 3.0.1
 *  Thread Starter [team_mda](https://wordpress.org/support/users/team_mda/)
 * (@team_mda)
 * [15 years, 6 months ago](https://wordpress.org/support/topic/database-exists/#post-1676814)
 * Are you sure? I found that I was exporting the database rather than a table dump.
   Once I did, the table dump and imported the new tables, the database took correctly.
 * I haven’t been able to test the blog due to the domain not being hooked up yet.
   It keeps wanting to redirect to the original blog.
 * Thanks–
 *  [esmi](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [15 years, 6 months ago](https://wordpress.org/support/topic/database-exists/#post-1676821)
 * There were database changes between 2.9 and 3.0. This means that you will hit
   problems if you try to import a 2.9 db backup into a 3.0 database.
 *  Thread Starter [team_mda](https://wordpress.org/support/users/team_mda/)
 * (@team_mda)
 * [15 years, 6 months ago](https://wordpress.org/support/topic/database-exists/#post-1676822)
 * I did and no problems came up during data dump or import into the new database.
   Does that mean everything is fine, or should I follow your instructions above?
   
   Thanks–
 *  [esmi](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [15 years, 6 months ago](https://wordpress.org/support/topic/database-exists/#post-1676875)
 * I suggest importing into a 2.9 install and then upgrading post-import.
 *  Thread Starter [team_mda](https://wordpress.org/support/users/team_mda/)
 * (@team_mda)
 * [15 years, 6 months ago](https://wordpress.org/support/topic/database-exists/#post-1676885)
 * Thanks for your help and here is what I did.
 * I followed the instructions for a manual upgrade from 2.9 to 3.0.
    The db did
   need to be updated which WP handled correctly. Once I upgraded, I dumped the 
   db via an export. I copied the entire site to the new server. Finally, I imported
   the data into the new server.
 * Everything worked perfectly. Your right, there are DB changes in 3.0.
 * Thanks again,
 *  Thread Starter [team_mda](https://wordpress.org/support/users/team_mda/)
 * (@team_mda)
 * [15 years, 6 months ago](https://wordpress.org/support/topic/database-exists/#post-1676893)
 * Actually, everything did not go great. The site is down. I’m getting two errors
   now that the DNS is resolving properly.
 *     ```
       Notice: Use of undefined constant OT_LIBRARY - assumed 'OT_LIBRARY' in D:\inetpub\vhosts\mySite\httpdocs\blog\wp-content\plugins\category-icons\category_icons.php on line 1837
   
       Notice: load_plugin_textdomain was called with an argument that is deprecated since version 2.7 with no alternative available. in D:\inetpub\vhosts\mySite\httpdocs\blog\wp-includes\functions.php on line 3323
       ```
   
 * Any suggestions?
 *  Thread Starter [team_mda](https://wordpress.org/support/users/team_mda/)
 * (@team_mda)
 * [15 years, 6 months ago](https://wordpress.org/support/topic/database-exists/#post-1676896)
 * I found the problem. Some of the files did not get copied onto the new server.
   Once I did this, the proper site came up. Phew!
 * All problems solved completely.

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘Database exists’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [exists](https://wordpress.org/support/topic-tag/exists/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 8 replies
 * 2 participants
 * Last reply from: [team_mda](https://wordpress.org/support/users/team_mda/)
 * Last activity: [15 years, 6 months ago](https://wordpress.org/support/topic/database-exists/#post-1676896)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics