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!