How to install Multi-DB?

Posted on 26th April 2009 (2 years ago) #

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.

Erstwhile founder

Posted on 26th April 2009 (2 years ago) #

Hiya,

This:

add_db_server('buddyceo', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', '*****');

Should be:

add_db_server('global', 'dc1', 1, 1,'localhost','localhost','buddyceo_ceo', 'buddyceo_ceo', '*****');

Thanks,
Andrew

Inactive

thiswell

Posted on 26th April 2009 (2 years ago) #

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: http://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?

Inactive

thiswell

Posted on 27th April 2009 (2 years ago) #

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?

Erstwhile founder

Posted on 27th April 2009 (2 years ago) #

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

Inactive

thiswell

Posted on 27th April 2009 (2 years ago) #

It says I can choose between Sub-domains (like blog1.example.com) and Sub-directories (like example.com/blog1), but it does not allow me to choose and install one of them.

Erstwhile founder

Posted on 27th April 2009 (2 years ago) #

When installing WPMU you have the option of subdomains for blogs or subdirectories. It's not an option after WPMU is installed. Accounts setup via WP.MU are subdomain installs.

Thanks,
Andrew

Inactive

thiswell

Posted on 28th April 2009 (2 years ago) #

Hi!
My db-config.php is below;

// Plugin Name: Multi-DB
// Plugin URI: http://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

Erstwhile founder

Posted on 28th April 2009 (2 years ago) #

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

Inactive

thiswell

Posted on 28th April 2009 (2 years ago) #

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/

Keeper of the Dark Chocolate

Posted on 28th April 2009 (2 years ago) #

What database is wp_blogs in?

Erstwhile founder

Posted on 28th April 2009 (2 years ago) #

Have you moved your tables to the new databases?

Thanks,
Andrew

Keeper of the Dark Chocolate

Posted on 28th April 2009 (2 years ago) #

Just so you know, wp_blogs should be in the global database. In this case, buddyceo_ceo.

Inactive

noiseswap

Reputation:13

Posted on 28th April 2009 (2 years ago) #

In the Muilt-DB page

It says there is a script of cPanel?

"and if you are using cPanel, even incorporates a script that will do that for you"

Where is this located?

Keeper of the Dark Chocolate

Posted on 28th April 2009 (2 years ago) #

That's the move-blogs.php script included with the download.

Inactive

thiswell

Posted on 29th April 2009 (2 years ago) #

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

Erstwhile founder

Posted on 29th April 2009 (2 years ago) #

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

Inactive

thiswell

Posted on 30th April 2009 (2 years ago) #

I have a table called 'wp', ex:buddyceo_ceo.wp_1_term_relationships.

Erstwhile founder

Posted on 30th April 2009 (2 years ago) #

Can you please list the tables in buddyceo_ceo? There shouldn't be that many.

Thanks,
Andrew

Inactive

thiswell

Posted on 30th April 2009 (2 years ago) #

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 -

Erstwhile founder

Posted on 30th April 2009 (2 years ago) #

Hi,

Are you running BuddyPress?

Thanks,
Andrew

Inactive

thiswell

Posted on 30th April 2009 (2 years ago) #

Yes, I am running BuddyPress.

Erstwhile founder

Posted on 30th April 2009 (2 years ago) #

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

Inactive

thiswell

Posted on 30th April 2009 (2 years ago) #

I have deleted BuddyPress file and related database table.
But, do not new database.

Thanks.
THISWELL

Erstwhile founder

Posted on 30th April 2009 (2 years ago) #

But, do not new database.

I'm afraid I don't understand.

Thanks,
Andrew

Inactive

thiswell

Posted on 30th April 2009 (2 years ago) #

Please, Check your e-mail.

Thanks.
THISWELL

Erstwhile founder

Posted on 30th April 2009 (2 years ago) #

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

Inactive

thiswell

Posted on 1st May 2009 (2 years ago) #

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

Erstwhile founder