WordPress.org

1. larobbie
   Member
   Posted 4 years 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?

2. larobbie
   Member
   Posted 4 years ago #

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

3. MichaelH
   Volunteer
   Posted 4 years ago #

   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.

4. larobbie
   Member
   Posted 4 years ago #

   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?

5. larobbie
   Member
   Posted 4 years ago #

   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?

6. moshu
   Member
   Posted 4 years ago #

   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!)

7. larobbie
   Member
   Posted 4 years ago #

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

Topic Closed

This topic has been closed to new replies.