WordPress.org

1. Soreng
   Member
   Posted 4 years ago #

   Hi,

   I am struggling with importing a database that I'm using in another WP blog in order for me to create an identical copy with the same content.

   Here's the situation:

   I have "blog1" working 100% and want to use this DB in "blog2". I have created blog2 and try to import the DB from blog1 using my phpMyAdmin. Except it comes up with errors:

   1044 - Access denied for user 'demoblog2'@'%' to database 'information_schema'

   I have already changed my wp-config.php file to contain the right info (name, location, etc), so all that is cool.

   In the DB I'm importing, I have also changed everything from blog1 to blog2 - including location, password, etc.

   What am I doing wrong? What is the correct way to import a new DB? Do I drop tables/Database? Where do I put this.

   Perhaps I have to do something special when I EXPORT the one from blog1?

   I'm lost completely, and believe me, I've been at this for hours now.

   Help :-)

   Cheers,
   Soren

2. MichaelH
   Volunteer
   Posted 4 years ago #

   Restoring_Your_Database_From_Backup explains database restoration.

   If information_schema is another database, that is not part of WordPress.

3. Soreng
   Member
   Posted 4 years ago #

   Hi Michael,

   Okay. I did EXACTLY as per the article you referred to, and I get the following error message:

   #1050 - Table 'wp_comments' already exists

   Do I need to "drop" something or what do I do (and where do I put this)? Please help.

   Thanks,
   Soren

4. MichaelH
   Volunteer
   Posted 4 years ago #

   I'd try the restore with no tables in the database.

5. Soreng
   Member
   Posted 4 years ago #

   Michael, how do I do that (restore with no tables)?

   I just tried again and got this message:

   #1044 - Access denied for user 'demoblog2'@'%' to database 'information_schema'

   If you would tell me how to restore witn no tables, I will get right to it.

   THANKS.

6. MichaelH
   Volunteer
   Posted 4 years ago #

   Not much help here:

   Review Backing_Up_Your_Database to make sure you are only getting your WordPress tables.

7. Soreng
   Member
   Posted 4 years ago #

   Actually, it was a great help. I am done done done :-) It worked.

   THANKS, Michael.

   Cheers,
   Soren

Topic Closed

This topic has been closed to new replies.