Database exists

  • Resolved team_mda

    (@team_mda)


    15 years, 6 months ago

    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

    (@esmi)

    15 years, 6 months ago

    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

    (@team_mda)

    15 years, 6 months ago

    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

    (@esmi)

    15 years, 6 months ago

    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

    (@team_mda)

    15 years, 6 months ago

    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

    (@esmi)

    15 years, 6 months ago

    I suggest importing into a 2.9 install and then upgrading post-import.

    Thread Starter team_mda

    (@team_mda)

    15 years, 6 months ago

    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

    (@team_mda)

    15 years, 6 months ago

    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

    (@team_mda)

    15 years, 6 months ago

    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.