Hiya,

but should i really have to add the old database user to all the new databases?

You'll need to add the user to all of the new databases. 99% of the people who switch to Multi-DB don't change the MySQL user.

Thanks,
Andrew

Hmm, I'm getting the following error

Database Error: Access denied for user 'press111_wpmu'@'localhost' to database 'press111_c8'

This is the same thing that happened before. The thing is though the user press111_wpmu is the user for my old database i used when i set up the wpmu in the first place.

I added that user to press111_c4 and that seemed to work, but should i really have to add the old database user to all the new databases? Shouldn't that be the new user i created for all of those databases?

hey andrew all the information in the code has been edited to "fake" information

I edited your post to remove your db pass. You definitely don't want someone grabbing that ;)

As for the problem, try switching out the IPs in your connection lines to 'localhost'.

Thanks,
Andrew

I was also working with my host and they added both the user from the old Database and the new databases to one of the new databases and it worked for that database loading in the move blogs.

However i feel like this shouldn't be necessary and i probably messed something up in the above scripts to cause this problem.

For some reason it's still not working.

Here's a look at my db-config

//---DB Scaling-----------------------------------------------------------//<br />
//------------------------------------------------------------------------//<br />
//	16,256,4096<br />
define ('DB_SCALING', '256');<br />
//------------------------------------------------------------------------//<br />
//---DC IPs---------------------------------------------------------------//<br />
//------------------------------------------------------------------------//<br />
//	Usage: add_dc_ip(IP, DC)<br />
//	EX: add_dc_ip('123.123.123.', 'dc1');<br />
add_dc_ip('223.32.151.', 'dc1');<br />
//------------------------------------------------------------------------//<br />
//---Global Tables--------------------------------------------------------//<br />
//------------------------------------------------------------------------//<br />
//	Do not include default global tables<br />
//	Leave off base prefix (eg: wp_)<br />
//<br />
//	Usage: add_global_table(TABLE_NAME)<br />
//	EX: add_global_table('something');<br />
add_global_table('press111_global');<br />
//------------------------------------------------------------------------//<br />
//---DB Servers-----------------------------------------------------------//<br />
//------------------------------------------------------------------------//<br />
//	Database servers grouped by dataset.<br />
//	R can be 0 (no reads) or a positive integer indicating the order<br />
//	in which to attempt communication (all locals, then all remotes)<br />
//<br />
//	Usage: add_db_server(DS, DC, READ, WRITE, HOST, LAN_HOST, NAME, USER, PASS)<br />
//	EX: add_db_server('global', 'dc1', 1, 1,'global.mysql.example.com:3509','global.mysql.example.lan:3509', 'global-db', 'globaluser',  'globalpassword');<br />
//<br />
//	Note: you can also place this section in a file called db-list.php in wp-content</p>
<p>add_db_server('global', 'dc1', 1, 1,'223.32.151.136','223.32.151.136', 'wpmu_global', 'press111_multidb',  'xxxxxxxxxxxxx');</p>
<p>add_db_server('00', 'dc1', 1, 1,'223.32.151.136','223.32.151.136', 'press111_00', 'press111_multidb',  'xxxxxxxxxxxxx');<br />
add_db_server('01', 'dc1', 1, 1,'223.32.151.136','223.32.151.136', 'press111_00', 'press111_multidb',  'xxxxxxxxxxxxx');<br />
add_db_server('02', 'dc1', 1, 1,'223.32.151.136','223.32.151.136', 'press111_00', 'press111_multidb',  'xxxxxxxxxxxxx');</p>
<p>(this repeats for all DB's)<br />

Here's the move-blogs.php

///DB Settings<br />
$dbname = "press111_multidb";  //This is your current database<br />
$blog_table_prefix = 'wp_';  //Prefix of your wpmu blog tables, most likely this won't need to be changed<br />
$newdb_prefix = 'press111_';  //This is the prefix of the db's you're moving your tables into - we assume they are all the same, if not, you're in trouble</p>
<p>//We need info to connect to the databases<br />
$dbhost = '223.32.151.136';<br />
$dbuname = 'press111_wpmu';<br />
$dbpass = 'xxxxxxxxxxxxxxxx';</p>
<p>//How many db's are you moving into (16, 256, or 4096)?<br />
$db_scaling = '256';<br />

256(!!!) db:s.... wow, are you using 256 servers, or do you have 256 WM:s, or do you run 256 instanses of mysql in the same box (if so, does it do any good then)?

I need to do something with my system, I just need to know how and what I should do (2000 blogs right now).

It looks like you just need to add your db login information for the user with full rights to access your old db in the move-blogs.php file.

I'm currently installing multidb on a new wpmu network (only my main domain and a test blog), i set up 258 DB's (the 256 plus an extra vip for the main blog and a global database) however when i try to navigate to the move-blogs.php i'm getting the following error

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 'my_old_DB'@'localhost' to database 'a_new_database'

Then it shows none of the new databases in the lower section of the error page

This is the setup i have on the move-blogs.php page

///DB Settings
$dbname = "original_old_database"; //This is your current database
$blog_table_prefix = 'wp_'; //Prefix of your wpmu blog tables, most likely this won't need to be changed
$newdb_prefix = 'new_db_prefix'; //This is the prefix of the db's you're moving your tables into - we assume they are all the same, if not, you're in trouble

//We need info to connect to the databases
$dbhost = 'localhost';
$dbuname = 'old_db_username';
$dbpass = 'old_db_password';

//How many db's are you moving into (16, 256, or 4096)?
$db_scaling = '256';

I'm thinking i probably messed up something here, hopefully it's not something i messed up on the main db-config file but i'm not much of a mysql expert so i'm not sure