New to the community? Start here

Problem With Multi-DB isntall

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

Tue, 27 Apr 2010 8:07:16
  • skolbloggen
    • Site Builder, Child of Zeus

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

  • sjrenn
    • Flash Drive

    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 />

  • sjrenn
    • Flash Drive

    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.

  • sjrenn
    • Flash Drive

    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?