I am trying to complete the multi-db install but when I go to move-blogs page I get the following message:
Houston, we have a problem!
Looks like you need to create your new db's! If you're lucky, this link still works - click me
Database Error: Access denied for user 'admin_admin'@'%' to database 'WORDPRESS1_global'

I do see the following menu but there are no databases listed underneath:
Tested on PHP 5 & MySQL 5
Make sure all of your new db's exist (green text next to table name in db column below)
In the status section, each table should show not in new db (unless you've already run this script)
To start the copy process click here
Be patient, depending on how many blogs you have, this could take a while
Once completed, refresh this page by clicking here
Check to make sure that in the status section all tables say table in new db
Rejoice, I probably just saved you hours of your life!
If this didn't work, don't blame me. Sometimes life is just like that..

table name table info new db status

As far as I know, I put all of my scripts in the right place:

db.php and db-config.php in wp-content/
move-blogs.php in wp-content/scripts
Is that correct? I did notice that I had another db.php file in my wp-content file so I renamed the new one db-multi.php.

I don't know if this is a file placement issue or a SQL issue. Thanks ahead of time for your help!


  • sharesteading
    • Flash Drive

    Thanks Phil! Ok, I changed my log-in information and it worked, however, the only database showing up is the global database. There are no other ones listed. all of the wordpress tables are showing connected to the global database. Did I place something in the wrong place? I know that all of my databases exist. Or is it supposed to be this way?

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.