Restoring Error

  • Resolved larobbie

    (@larobbie)


    17 years, 9 months ago

    I have a problem with restoring my old database.

    I made a copy after I upgraded to the latest WordPress (two – three weeks ago).

    After the successful backup – (made two for just in case) and everything working fine, now I’m trying to restore the database on a new blog, and when going through the whole process of restoring (phpmyadmin) .

    It gives me this Error:

    MySQL said:
    #1050 – Table ‘wp_categories’ already exists

    I tried removing the wp_categories from the database, but this just keeps on going forever, everytime a different table allready exsists.

    Any solutions to this?

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter larobbie

    (@larobbie)

    I tried playing with it some more yesterday, no luck, every table seems to already exsist.

    When you say

    now I’m trying to restore the database on a new blog

    what does that mean?

    You likely want to restore your database tables into a database that has no tables (techinically, you would want to restore into a database that doesn’t already have the wp_categories and other WordPress tables).

    If you’ve already installed WordPress as your new blog, then tried to restore the database, remember the WordPress installation would have already created the tables.

    Thread Starter larobbie

    (@larobbie)

    My blog is krneky.com.

    Now I installed another version of it on thedomain.com/new-blog-here .

    I made a backup of the krneky.com blog and tried to restore it on thedomain.com/new-blog-here .

    I understand what you’re saying, but how can I restore the database on a new wordpress blog if it allready has those tables?

    Thread Starter larobbie

    (@larobbie)

    So that means, if I would want to restore an old database, on a fresh installed version of WordPress that allready has those tables installed (by default I guess) – I’d have to remove those tables from the database?

    Basically, yes. Otherwise you get all kind of errors saying XYZ table already exists…
    So, keep the database and “drop” the tables. Then import the backup .sql file. (Make sure the config file is pointing to the right table prefix!)

    Thread Starter larobbie

    (@larobbie)

    That’s what I forgot to do, drop the tables. Works like a charm.
    Thanks Michael and moshu.

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