New to the community? Start here

How to install Multi-DB?

<?php

// Plugin Name: Multi-DB

// Plugin URI: https://wpmudev.com/project/Multiple-Databases

// Author: Andrew Billits (Incsub)

// Version: 2.7.0

//

//

//—DB Scaling

//

//

//

// 16,256,4096

define (‘DB_SCALING’, ’16’:wink:;

//

//

//—DC IPs

//

//

//

// Usage: add_dc_ip(IP, DC)

// EX: add_dc_ip(‘123.123.123.’, ‘dc1’:wink:;

add_dc_ip(‘118.129.170.47’, ‘dc1’:wink:;

//

//

//—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’:wink:;

add_global_table(‘buddyceo_ceo’:wink:;

//

//

//—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’:wink:;

//

// 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’:wink:;

add_db_server(‘buddyceo’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘*****’:wink:;

add_db_server(‘0’, ‘dc1′, 1, 1,’localhost’,’localhost’, ‘buddyceo_ceo0’, ‘buddyceo_ceo’, ‘*****’:wink:;

add_db_server(‘1’, ‘dc1′, 1, 1,’localhost’,’localhost’, ‘buddyceo_ceo1’, ‘buddyceo_ceo’, ‘*****’:wink:;

.

.

.

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

Sun, 26 Apr 2009 17:28:10
  • drmike
    • DEV MAN’s Mascot

    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’:wink:;

    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.

  • Andrew
    • Champion of Loops

    Hiya,

    This:

    add_db_server(‘buddyceo’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘*****’:wink:;

    Should be:

    add_db_server(‘global’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘*****’:wink:;

    Thanks,

    Andrew

  • thiswell
    • WPMU DEV Initiate

    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://wpmudev.com/project/Multiple-Databases

    // Author: Andrew Billits (Incsub)

    // Version: 2.7.0

    //

    //

    //—DB Scaling

    //

    //

    //

    // 16,256,4096

    define (‘DB_SCALING’, ’16’:wink:;

    add_dc_ip(‘118.129.170.’, ‘dc1’:wink:;

    add_global_table(‘ceo’:wink:;

    add_db_server(‘global’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘0’, ‘dc1′, 1, 1,’localhost’,’localhost’, ‘buddyceo_ceo0’, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘1’, ‘dc1′, 1, 1,’localhost’,’localhost’, ‘buddyceo_ceo1’, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    .

    .

    add_db_server(‘1’, ‘dcf’, 1, 1,’localhost’,’localhost’, ‘buddyceo_ceo1’, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

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

    How to create Multi-DB?

  • Andrew
    • Champion of Loops

    Hiya,

    Why does this say “dcf”?:

    add_db_server(‘1’, ‘dcf’, 1, 1,’localhost’,’localhost’, ‘buddyceo_ceo1’, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    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
    • WPMU DEV Initiate

    Hi!

    My db-config.php is below;

    // Plugin Name: Multi-DB

    // Plugin URI: https://wpmudev.com/project/Multiple-Databases

    // Author: Andrew Billits (Incsub)

    // Version: 2.7.0

    define (‘DB_SCALING’, ’16’:wink:;

    add_dc_ip(‘118.129.170.’, ‘dc1’:wink:;

    add_global_table(‘ceo’:wink:;

    add_db_server(‘global’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘0’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘1’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘2’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘3’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘4’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘5’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘6’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘7’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘8’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘9’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘a’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘b’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘c’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘d’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘e’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘vip1’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_vip_blog(1, ‘vip1’:wink:;

    ?>

    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
    • Champion of Loops

    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’:wink:;

    add_vip_blog(1, ‘vip1’:wink:;

    Thanks,

    Andrew

  • thiswell
    • WPMU DEV Initiate

    Recoding below;

    add_db_server(‘global’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘0’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo0′, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘1’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo1′, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘2’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo2′, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘3’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo3′, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘4’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo4′, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘5’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo5′, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘6’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo6′, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘7’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo7′, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘8’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo8′, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘9’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo9′, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘a’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceoa’, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘b’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceob’, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘c’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceoc’, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘d’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceod’, ‘buddyceo_ceo’, ‘00000’:wink:;

    add_db_server(‘e’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceoe’, ‘buddyceo_ceo’, ‘00000’:wink:;

    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
    • WPMU DEV Initiate

    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’:wink:;

    add_dc_ip(‘118.129.170.’, ‘dc1’:wink:;

    add_global_table(‘ceo’:wink:;

    add_db_server(‘global’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘0’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo0′, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘1’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo1′, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘2’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo2′, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘3’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo3′, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘4’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo4′, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘5’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo5′, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘6’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo6′, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘7’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo7′, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘8’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo8′, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘9’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo9′, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘a’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceoa’, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘b’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceob’, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘c’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceoc’, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘d’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceod’, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘e’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceoe’, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘f’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceof’, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    ?>

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

    <?php

    /*

    Plugin Name: Multi-DB (Conversion Tool)

    Plugin URI: https://wpmudev.com/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
    • Champion of Loops

    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’:wink:;

    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
    • WPMU DEV Initiate

    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
    • Champion of Loops

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

    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’:wink:;

    etc.

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

    Thanks,

    Andrew

  • Andrew
    • Champion of Loops

    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
    • WPMU DEV Initiate

    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://wpmudev.com/project/Multiple-Databases

    // Author: Andrew Billits (Incsub)

    // Version: 2.7.0

    //

    //

    //—DB Scaling

    //

    //

    //

    // 16,256,4096

    define (‘DB_SCALING’, ’16’:wink:;

    //

    //

    //—DC IPs

    //

    //

    //

    // Usage: add_dc_ip(IP, DC)

    // EX: add_dc_ip(‘123.123.123.’, ‘dc1’:wink:;

    add_dc_ip(‘118.129.170.’, ‘dc1’:wink:;

    //

    //

    //—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’:wink:;

    add_global_table(‘wpmu_’:wink:;

    //

    //

    //—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’:wink:;

    //

    // 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’:wink:;

    //

    //

    add_db_server(‘global’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo’, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘0’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo0′, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘1’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo1′, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘2’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo2′, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘3’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo3′, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘4’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo4′, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘5’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo5′, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘6’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo6′, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘7’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo7′, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘8’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo8′, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘9’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceo9′, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘a’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceoa’, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘b’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceob’, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘c’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceoc’, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘d’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceod’, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘e’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceoe’, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    add_db_server(‘f’, ‘dc1′, 1, 1,’localhost’,’localhost’,’buddyceo_ceof’, ‘buddyceo_ceo’, ‘xxxxx’:wink:;

    //—VIP Blogs

    //

    //

    //

    // Usage: add_vip_blog(BLOG_ID, DS)

    // EX: add_vip_blog(1, ‘vip1’:wink:;

    ?>

    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

  • Andrew
    • Champion of Loops

    This will be the third time I’ve pointed this out…

    You need to set this:

    $newdb_prefix = ‘wpmu_’;

    To this:

    $newdb_prefix = ‘buddyceo_ceo’;

    Make that change and run the move-blogs.php script again. Also make sure that your user actually has permissions for all of the databases.

    Thanks,

    Andrew