How to install Multi-DB?

<?php
// Plugin Name: Multi-DB
// Plugin URI: https://premium.wpmudev.org/project/Multiple-Databases
// Author: Andrew Billits (Incsub)
// Version: 2.7.0
//------------------------------------------------------------------------//
//---DB Scaling-----------------------------------------------------------//
//------------------------------------------------------------------------//
// 16,256,4096
define ('DB_SCALING', '16');
//------------------------------------------------------------------------//
//---DC IPs---------------------------------------------------------------//
//------------------------------------------------------------------------//
// Usage: add_dc_ip(IP, DC)
// EX: add_dc_ip('123.123.123.', 'dc1');
add_dc_ip('118.129.170.47', 'dc1');
//------------------------------------------------------------------------//
//---Global Tables--------------------------------------------------------//
//------------------------------------------------------------------------//
// Do not include default global tables
// Leave off base prefix (eg: wp_)
//
// Usage: add_global_table(TABLE_NAME)
// EX: add_global_table('something');
add_global_table('buddyceo_ceo');
//------------------------------------------------------------------------//
//---DB Servers-----------------------------------------------------------//
//------------------------------------------------------------------------//
// Database servers grouped by dataset.
// R can be 0 (no reads) or a positive integer indicating the order
// in which to attempt communication (all locals, then all remotes)
//
// Usage: add_db_server(DS, DC, READ, WRITE, HOST, LAN_HOST, NAME, USER, PASS)
// EX: add_db_server('global', 'dc1', 1, 1,'global.mysql.example.com:3509','global.mysql.example.lan:3509', 'global-db', 'globaluser', 'globalpassword');
//
// Note: you can also place this section in a file called db-list.php in wp-content
// EX: add_db_server('global', 'dc1', 1, 1,'global.mysql.example.com:3509','global.mysql.example.lan:3509', 'global-db', 'globaluser', 'globalpassword');
add_db_server('buddyceo', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', '*****');
add_db_server('0', 'dc1', 1, 1,'localhost','localhost', 'buddyceo_ceo0', 'buddyceo_ceo', '*****');
add_db_server('1', 'dc1', 1, 1,'localhost','localhost', 'buddyceo_ceo1', 'buddyceo_ceo', '*****');

.
.
.

[Mon Apr 27 02:08:39 2009] [error] [client 125.177.95.154] PHP Warning: Invalid argument supplied for foreach() in /home/buddyceo/buddyceo.com/html/wp-content/db.php on line 770, referer: http://buddyceo.com/
[Mon Apr 27 02:08:39 2009] [error] [client 125.177.95.154] PHP Warning: Invalid argument supplied for foreach() in /home/buddyceo/buddyceo.com/html/wp-content/db.php on line 770, referer: http://buddyceo.com/
[Mon Apr 27 02:08:39 2009] [error] [client 125.177.95.154] PHP Warning: Invalid argument supplied for foreach() in /home/buddyceo/buddyceo.com/html/wp-content/db.php on line 770, referer: http://buddyceo.com/
[Mon Apr 27 02:08:39 2009] [error] [client 125.177.95.154] PHP Warning: Invalid argument supplied for foreach() in /home/buddyceo/buddyceo.com/html/wp-content/db.php on line 770, referer: http://buddyceo.com/
[Mon Apr 27 02:08:39 2009] [error] [client 125.177.95.154] PHP Warning: Invalid argument supplied for foreach() in /home/buddyceo/buddyceo.com/html/wp-content/db.php on line 770, referer: http://buddyceo.com/
[Mon Apr 27 02:08:39 2009] [error] [client 125.177.95.154] PHP Warning: Invalid argument supplied for foreach() in /home/buddyceo/buddyceo.com/html/wp-content/db.php on line 770, referer: http://buddyceo.com/
[Mon Apr 27 02:08:39 2009] [error] [client 125.177.95.154] PHP Warning: Invalid argument supplied for foreach() in /home/buddyceo/buddyceo.com/html/wp-content/db.php on line 770, referer: http://buddyceo.com/
[Mon Apr 27 02:08:39 2009] [error] [client 125.177.95.154] PHP Warning: Invalid argument supplied for foreach() in /home/buddyceo/buddyceo.com/html/wp-content/db.php on line 770, referer: http://buddyceo.com/
[Mon Apr 27 02:08:40 2009] [error] [client 125.177.95.154] PHP Warning: Invalid argument supplied for foreach() in /home/buddyceo/buddyceo.com/html/wp-content/db.php on line 770, referer: http://buddyceo.com/
[Mon Apr 27 02:08:40 2009] [error] [client 125.177.95.154] PHP Warning: Invalid argument supplied for foreach() in /home/buddyceo/buddyceo.com/html/wp-content/db.php on line 770, referer: http://buddyceo.com/

  • drmike

    Again, it would be a plus if you walked us through what specifically you;ve done to install the plugin. There are install instructions in the download. Please review them.

    There are some mistakes though:

    add_dc_ip('118.129.170.47', 'dc1');

    As per the example right above it, you use the class c, not the actual IP address. Please try the following:

    add_dc_ip('118.129.170.', 'dc1');

    buddyceo_ceo

    Is this a database table or an actual database? i have a feeling that it;s a database. if so, that line shouldn't be there. If it is a table and buddyceo_ is the prefix that you;re using on your site, the line should read:

    add_global_table('ceo');

    Please try those changes, review the setup instructions, and let us know how things are working.

  • thiswell

    Mon Apr 27 08:32:37 2009] [error] [client x.x.x.x.] WordPress database error No database selected for query SELECT * FROM wp_blogs WHERE domain = 'buddyceo.com' made by require_once
    [Mon Apr 27 08:32:37 2009] [error] [client x.x.x.x.] WordPress database error No database selected for query SELECT * FROM wp_blogs WHERE domain = 'buddyceo.com' made by require_once
    [Mon Apr 27 08:32:37 2009] [error] [client x.x.x.x.] WordPress database error No database selected for query SELECT * FROM wp_blogs WHERE domain = 'buddyceo.com' made by require_once
    [Mon Apr 27 08:32:37 2009] [error] [client x.x.x.x.] WordPress database error No database selected for query SELECT * FROM wp_blogs WHERE domain = 'buddyceo.com' made by require_once
    [Mon Apr 27 08:32:37 2009] [error] [client x.x.x.x.] WordPress database error No database selected for query SELECT * FROM wp_blogs WHERE domain = 'buddyceo.com' made by require_once
    [Mon Apr 27 08:32:37 2009] [error] [client x.x.x.x.] WordPress database error No database selected for query SELECT * FROM wp_blogs WHERE domain = 'buddyceo.com' made by require_once
    [Mon Apr 27 08:32:37 2009] [error] [client x.x.x.x.] WordPress database error No database selected for query SELECT * FROM wp_blogs WHERE domain = 'buddyceo.com' made by require_once

    My db-config.php are below;

    <?php
    // Plugin Name: Multi-DB
    // Plugin URI: https://premium.wpmudev.org/project/Multiple-Databases
    // Author: Andrew Billits (Incsub)
    // Version: 2.7.0
    //------------------------------------------------------------------------//
    //---DB Scaling-----------------------------------------------------------//
    //------------------------------------------------------------------------//
    // 16,256,4096
    define ('DB_SCALING', '16');
    add_dc_ip('118.129.170.', 'dc1');
    add_global_table('ceo');
    add_db_server('global', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', 'xxxxx');
    add_db_server('0', 'dc1', 1, 1,'localhost','localhost', 'buddyceo_ceo0', 'buddyceo_ceo', 'xxxxx');
    add_db_server('1', 'dc1', 1, 1,'localhost','localhost', 'buddyceo_ceo1', 'buddyceo_ceo', 'xxxxx');
    .
    .
    add_db_server('1', 'dcf', 1, 1,'localhost','localhost', 'buddyceo_ceo1', 'buddyceo_ceo', 'xxxxx');

    add_db_server('vip1', ‘dc1?, 1, 1,'localhost','localhost', 'buddyceo_vip1', 'buddyceo_ceo', ‘xxxxx’);

    How to create Multi-DB?

  • Andrew

    Hiya,

    Why does this say "dcf"?:
    add_db_server('1', 'dcf', 1, 1,'localhost','localhost', 'buddyceo_ceo1', 'buddyceo_ceo', 'xxxxx');

    Please take a look at the example db-config.php for 256 databases.

    And,
    I don't select below one, Under WPMU Package.
    Sub-domains (like blog1.example.com)
    Sub-directories (like example.com/blog1

    Why not selectable?

    I'm afraid I don't understand what you're asking.

    Thanks,
    Andrew

  • thiswell

    Hi!
    My db-config.php is below;

    // Plugin Name: Multi-DB
    // Plugin URI: https://premium.wpmudev.org/project/Multiple-Databases
    // Author: Andrew Billits (Incsub)
    // Version: 2.7.0

    define ('DB_SCALING', '16');

    add_dc_ip('118.129.170.', 'dc1');

    add_global_table('ceo');

    add_db_server('global', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', '00000');
    add_db_server('0', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', '00000');
    add_db_server('1', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', '00000');
    add_db_server('2', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', '00000');
    add_db_server('3', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', '00000');
    add_db_server('4', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', '00000');
    add_db_server('5', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', '00000');
    add_db_server('6', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', '00000');
    add_db_server('7', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', '00000');
    add_db_server('8', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', '00000');
    add_db_server('9', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', '00000');
    add_db_server('a', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', '00000');
    add_db_server('b', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', '00000');
    add_db_server('c', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', '00000');
    add_db_server('d', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', '00000');
    add_db_server('e', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', '00000');
    add_db_server('vip1', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', '00000');

    add_vip_blog(1, 'vip1');
    ?>

    It is Error.

    WordPress database error Table 'buddyceo_ceo.wp_blogs' doesn't exist for query SELECT * FROM wp_blogs WHERE domain = 'buddyceo.com' made by require_once, referer: http://buddyceo.com/index.php

  • Andrew

    Hiya,

    Did you even look at the example files? Your mistake should be pretty obvious.

    Basically you're sending everything to the same database "buddyceo_ceo".

    Also, until you get it up and running I wouldn't put the main blog in a vip database. So remove these lines:

    add_db_server('vip1', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', '00000');

    add_vip_blog(1, 'vip1');

    Thanks,
    Andrew

  • thiswell

    Recoding below;

    add_db_server('global', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', '00000');
    add_db_server('0', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo0', 'buddyceo_ceo', '00000');
    add_db_server('1', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo1', 'buddyceo_ceo', '00000');
    add_db_server('2', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo2', 'buddyceo_ceo', '00000');
    add_db_server('3', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo3', 'buddyceo_ceo', '00000');
    add_db_server('4', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo4', 'buddyceo_ceo', '00000');
    add_db_server('5', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo5', 'buddyceo_ceo', '00000');
    add_db_server('6', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo6', 'buddyceo_ceo', '00000');
    add_db_server('7', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo7', 'buddyceo_ceo', '00000');
    add_db_server('8', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo8', 'buddyceo_ceo', '00000');
    add_db_server('9', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo9', 'buddyceo_ceo', '00000');
    add_db_server('a', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceoa', 'buddyceo_ceo', '00000');
    add_db_server('b', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceob', 'buddyceo_ceo', '00000');
    add_db_server('c', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceoc', 'buddyceo_ceo', '00000');
    add_db_server('d', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceod', 'buddyceo_ceo', '00000');
    add_db_server('e', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceoe', 'buddyceo_ceo', '00000');

    But, same result

    WordPress database error Table 'buddyceo_ceo.wp_blogs' doesn't exist for query SELECT * FROM wp_blogs WHERE domain = 'buddyceo.com' made by require_once, referer: http://www.buddyceo.com/

  • thiswell

    I am trying to install wpmu and Multi-DB to create a new website without installing wordpress mu.
    1. Do I install Wordpress Mu or WPMU first and then Multi-DB?

    So, I installed wordpress mu(WordPress MU 2.7.1.
    ) and then installed Multi-DB.

    1) Wordpress MU status;
    Database name : buddyceo_ceo
    Database user name : buddyceo_ceo
    Database password : xxxxx
    2) db-config.php;
    <?php

    define ('DB_SCALING', '16');

    add_dc_ip('118.129.170.', 'dc1');

    add_global_table('ceo');

    add_db_server('global', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', 'xxxxx');
    add_db_server('0', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo0', 'buddyceo_ceo', 'xxxxx');
    add_db_server('1', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo1', 'buddyceo_ceo', 'xxxxx');
    add_db_server('2', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo2', 'buddyceo_ceo', 'xxxxx');
    add_db_server('3', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo3', 'buddyceo_ceo', 'xxxxx');
    add_db_server('4', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo4', 'buddyceo_ceo', 'xxxxx');
    add_db_server('5', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo5', 'buddyceo_ceo', 'xxxxx');
    add_db_server('6', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo6', 'buddyceo_ceo', 'xxxxx');
    add_db_server('7', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo7', 'buddyceo_ceo', 'xxxxx');
    add_db_server('8', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo8', 'buddyceo_ceo', 'xxxxx');
    add_db_server('9', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo9', 'buddyceo_ceo', 'xxxxx');
    add_db_server('a', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceoa', 'buddyceo_ceo', 'xxxxx');
    add_db_server('b', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceob', 'buddyceo_ceo', 'xxxxx');
    add_db_server('c', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceoc', 'buddyceo_ceo', 'xxxxx');
    add_db_server('d', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceod', 'buddyceo_ceo', 'xxxxx');
    add_db_server('e', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceoe', 'buddyceo_ceo', 'xxxxx');
    add_db_server('f', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceof', 'buddyceo_ceo', 'xxxxx');

    ?>

    3) move-blogs.php in /html/wp-content/scripts ;

    <?php
    /*
    Plugin Name: Multi-DB (Conversion Tool)
    Plugin URI: https://premium.wpmudev.org/project/Multiple-Databases
    Description:
    Author: Ron Dillehay
    Version: 2.7.0
    .
    .
    .
    $dbname = "buddyceo_ceo"; //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 = 'wpmu_'; //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 = 'buddyceo_ceo';
    $dbpass = 'xxxxx';

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

    4) BUT, Multi-DB do not created, appeared error ;
    PHP Warning: file_put_contents(/home/buddyceo/buddyceo.com/html/wp-content/plugins/wp-options-manager/../../uploads/.wpom.dat) [function.file-put-contents]: failed to open stream: No such file or directory in /home/buddyceo/buddyceo.com/html/wp-content/plugins/wp-options-manager/wp_options_manager.php on line 839, referer: http://buddyceo.com/wp-admin/plugins.php?deactivate=true

  • Andrew

    1. Do I install Wordpress Mu or WPMU first and then Multi-DB?

    1) WordPress MU = WPMU - They're the same thing. Just clarifying this.

    2) WPMU/WordPress MU needs to be installed prior to setting up Multi-DB.

    add_global_table('ceo');

    Do you have a table called 'ceo'?

    $newdb_prefix = 'wpmu_'; //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

    This needs to be set to 'buddyceo_ceo';

    4) BUT, Multi-DB do not created, appeared error ;
    PHP Warning: file_put_contents(/home/buddyceo/buddyceo.com/html/wp-content/plugins/wp-options-manager/../../uploads/.wpom.dat) [function.file-put-contents]: failed to open stream: No such file or directory in /home/buddyceo/buddyceo.com/html/wp-content/plugins/wp-options-manager/wp_options_manager.php on line 839, referer:

    That error doesn't seem to be Multi-DB related.

    Thanks,
    Andrew

  • thiswell

    wp_1_comments 4 MyISAM utf8_general_ci 9.3 KB -
    wp_1_links 2 MyISAM utf8_general_ci 4.2 KB -
    wp_1_options 247 MyISAM utf8_general_ci 53.3 KB -
    wp_1_postmeta 34 MyISAM utf8_general_ci 9.2 KB -
    wp_1_posts 50 MyISAM utf8_general_ci 61.7 KB -
    wp_1_post_to_smf 0 MyISAM utf8_general_ci 1.0 KB -
    wp_1_terms 47 MyISAM utf8_general_ci 10.2 KB -
    wp_1_term_relationships 91 MyISAM utf8_general_ci 8.9 KB -
    wp_1_term_taxonomy 47 MyISAM utf8_general_ci 5.1 KB -
    wp_blogs 1 MyISAM utf8_general_ci 4.1 KB -
    wp_blog_versions 0 MyISAM utf8_general_ci 1.0 KB -
    wp_bp_activity_sitewide 17 MyISAM utf8_general_ci 21.4 KB -
    wp_bp_activity_user_activity 17 MyISAM utf8_general_ci 7.0 KB -
    wp_bp_activity_user_activity_cached 17 MyISAM utf8_general_ci 22.4 KB -
    wp_bp_friends 0 MyISAM utf8_general_ci 1.0 KB -
    wp_bp_groups 0 MyISAM utf8_general_ci 1.0 KB -
    wp_bp_groups_groupmeta 0 MyISAM utf8_general_ci 1.0 KB -
    wp_bp_groups_members 0 MyISAM utf8_general_ci 1.0 KB -
    wp_bp_groups_wire 0 MyISAM utf8_general_ci 1.0 KB -
    wp_bp_messages_messages 0 MyISAM utf8_general_ci 1.0 KB -
    wp_bp_messages_notices 0 MyISAM utf8_general_ci 1.0 KB -
    wp_bp_messages_recipients 0 MyISAM utf8_general_ci 1.0 KB -
    wp_bp_messages_threads 0 MyISAM utf8_general_ci 1.0 KB -
    wp_bp_notifications 0 MyISAM utf8_general_ci 1.0 KB -
    wp_bp_user_blogs 1 MyISAM utf8_general_ci 4.0 KB -
    wp_bp_user_blogs_blogmeta 3 MyISAM utf8_general_ci 7.2 KB -
    wp_bp_user_blogs_comments 7 MyISAM utf8_general_ci 6.3 KB -
    wp_bp_user_blogs_posts 10 MyISAM utf8_general_ci 5.4 KB -
    wp_bp_xprofile_data 1 MyISAM utf8_general_ci 4.0 KB -
    wp_bp_xprofile_fields 1 MyISAM utf8_general_ci 7.0 KB -
    wp_bp_xprofile_groups 1 MyISAM utf8_general_ci 3.0 KB -
    wp_bp_xprofile_wire 0 MyISAM utf8_general_ci 1.0 KB -
    wp_registration_log 1 MyISAM utf8_general_ci 3.1 KB -
    wp_signups 0 MyISAM utf8_general_ci 1.0 KB -
    wp_signup_language 0 MyISAM latin1_swedish_ci 1.0 KB -
    wp_site 1 MyISAM utf8_general_ci 6.0 KB -
    wp_sitecategories 48 MyISAM utf8_general_ci 8.5 KB -
    wp_sitemeta 63 MyISAM utf8_general_ci 133.5 KB 416 B
    wp_usermeta 14 MyISAM utf8_general_ci 8.0 KB -
    wp_users 1 MyISAM utf8_general_ci 4.1 KB -

  • Andrew

    It probably would have been a good idea to mention that sooner

    There's a known problem with using Multi-DB on BuddyPress installs. We hope to take care of this in the next version of Multi-DB.

    If you want to try and get it to work with the current version you'll need to declare all of the global BuddyPress tables in db-config.php.

    add_global_table('bp_xprofile_fields');
    etc.

    Again though it may just not work with the current version.

    Thanks,
    Andrew

  • Andrew

    Hiya,

    I've checked my email and have replied. Members sending unsolicited emails is exactly why I don't really do support via email anymore. So we'll need to keep the discussion going here.

    Have you reran the move-blogs.php script after fixing this issue?:

    $newdb_prefix = 'wpmu_'; //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

    I explained what that variable needs to be set to a few posts up.

    Thanks,
    Andrew

  • thiswell

    move-blogs.php recoded;

    ///DB Settings
    $dbname = "buddyceo_ceo"; //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 = 'wpmu_'; //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 = 'budyceo_ceo';
    $dbpass = 'xxxxx';

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

    db-config.php below;

    <?php
    // Plugin Name: Multi-DB
    // Plugin URI: https://premium.wpmudev.org/project/Multiple-Databases
    // Author: Andrew Billits (Incsub)
    // Version: 2.7.0
    //------------------------------------------------------------------------//
    //---DB Scaling-----------------------------------------------------------//
    //------------------------------------------------------------------------//
    // 16,256,4096
    define ('DB_SCALING', '16');
    //------------------------------------------------------------------------//
    //---DC IPs---------------------------------------------------------------//
    //------------------------------------------------------------------------//
    // Usage: add_dc_ip(IP, DC)
    // EX: add_dc_ip('123.123.123.', 'dc1');
    add_dc_ip('118.129.170.', 'dc1');
    //------------------------------------------------------------------------//
    //---Global Tables--------------------------------------------------------//
    //------------------------------------------------------------------------//
    // Do not include default global tables
    // Leave off base prefix (eg: wp_)
    //
    // Usage: add_global_table(TABLE_NAME)
    // EX: add_global_table('something');
    add_global_table('wpmu_');
    //------------------------------------------------------------------------//
    //---DB Servers-----------------------------------------------------------//
    //------------------------------------------------------------------------//
    // Database servers grouped by dataset.
    // R can be 0 (no reads) or a positive integer indicating the order
    // in which to attempt communication (all locals, then all remotes)
    //
    // Usage: add_db_server(DS, DC, READ, WRITE, HOST, LAN_HOST, NAME, USER, PASS)
    // EX: add_db_server('global', 'dc1', 1, 1,'global.mysql.example.com:3509','global.mysql.example.lan:3509', 'global-db', 'globaluser', 'globalpassword');
    //
    // Note: you can also place this section in a file called db-list.php in wp-content
    // EX: add_db_server('global', 'dc1', 1, 1,'global.mysql.example.com:3509','global.mysql.example.lan:3509', 'global-db', 'globaluser', 'globalpassword');
    //------------------------------------------------------------------------//
    add_db_server('global', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', 'xxxxx');
    add_db_server('0', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo0', 'buddyceo_ceo', 'xxxxx');
    add_db_server('1', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo1', 'buddyceo_ceo', 'xxxxx');
    add_db_server('2', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo2', 'buddyceo_ceo', 'xxxxx');
    add_db_server('3', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo3', 'buddyceo_ceo', 'xxxxx');
    add_db_server('4', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo4', 'buddyceo_ceo', 'xxxxx');
    add_db_server('5', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo5', 'buddyceo_ceo', 'xxxxx');
    add_db_server('6', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo6', 'buddyceo_ceo', 'xxxxx');
    add_db_server('7', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo7', 'buddyceo_ceo', 'xxxxx');
    add_db_server('8', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo8', 'buddyceo_ceo', 'xxxxx');
    add_db_server('9', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo9', 'buddyceo_ceo', 'xxxxx');
    add_db_server('a', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceoa', 'buddyceo_ceo', 'xxxxx');
    add_db_server('b', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceob', 'buddyceo_ceo', 'xxxxx');
    add_db_server('c', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceoc', 'buddyceo_ceo', 'xxxxx');
    add_db_server('d', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceod', 'buddyceo_ceo', 'xxxxx');
    add_db_server('e', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceoe', 'buddyceo_ceo', 'xxxxx');
    add_db_server('f', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceof', 'buddyceo_ceo', 'xxxxx');
    //---VIP Blogs------------------------------------------------------------//
    //------------------------------------------------------------------------//
    // Usage: add_vip_blog(BLOG_ID, DS)
    // EX: add_vip_blog(1, 'vip1');

    ?>

    I have created manualy Database
    buddyceo_ceo 1.2M
    buddyceo_ceo0 8.2k
    buddyceo_ceo1 8.2k
    buddyceo_ceo2 8.2k
    buddyceo_ceo3 8.2k
    buddyceo_ceo4 8.2k
    buddyceo_ceo5 8.2k
    buddyceo_ceo6 8.2k
    buddyceo_ceo7 8.2k
    buddyceo_ceo8 8.2k
    buddyceo_ceo9 8.2k
    buddyceo_ceoa 8.2k
    buddyceo_ceob 8.2k
    buddyceo_ceoc 8.2k
    buddyceo_ceod 8.2k
    buddyceo_ceoe 8.2k
    buddyceo_ceof 8.2k

    It is result;

    [Fri May 01 15:35:31 2009] [error] [client 125.177.95.154] PHP Notice: Undefined index: table in /home/buddyceo/buddyceo.com/html/wp-content/scripts/move-blogs.php on line 61
    [Fri May 01 15:35:31 2009] [error] [client 125.177.95.154] PHP Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'budyceo_ceo'@'localhost' (using password: YES) in /home/buddyceo/buddyceo.com/html/wp-content/scripts/move-blogs.php on line 64

    Why not fine?

    Thanks,
    THISWELL