6593 pointsCommunity rank #9Supreme DeityMember of the MonthLifetime member
Keeper of the Dark Chocolate
(joined July 2007)
Likes (0)
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.
17 pointsCommunity rank #3423SophomoreJust Getting Started
Member
(joined February 2009)
Likes (0)
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
17 pointsCommunity rank #3423SophomoreJust Getting Started
Member
(joined February 2009)
Likes (0)
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.
7430 pointsCommunity rank #7Supreme DeityMember of the MonthLifetime member
Erstwhile founder
(joined May 2007)
Likes (0)
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.
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
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/
17 pointsCommunity rank #3423SophomoreJust Getting Started
Member
(joined February 2009)
Likes (0)
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
<?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
7430 pointsCommunity rank #7Supreme DeityMember of the MonthLifetime member
Erstwhile founder
(joined May 2007)
Likes (0)
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:
7430 pointsCommunity rank #7Supreme DeityMember of the MonthLifetime member
Erstwhile founder
(joined May 2007)
Likes (0)
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.
17 pointsCommunity rank #3423SophomoreJust Getting Started
Member
(joined February 2009)
Likes (0)
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');
[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
Responses (29)
Keeper of the Dark Chocolate (joined July 2007) Likes (0)
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:
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');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 (joined May 2007) Likes (0)
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
Member (joined February 2009) Likes (0)
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?
Member (joined February 2009) Likes (0)
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 (joined May 2007) Likes (0)
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.
I'm afraid I don't understand what you're asking.
Thanks,
Andrew
Member (joined February 2009) Likes (0)
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 (joined May 2007) Likes (0)
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
Member (joined February 2009) Likes (0)
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 (joined May 2007) Likes (0)
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
Member (joined February 2009) Likes (0)
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 (joined July 2007) Likes (0)
What database is wp_blogs in?
Erstwhile founder (joined May 2007) Likes (0)
Have you moved your tables to the new databases?
Thanks,
Andrew
Keeper of the Dark Chocolate (joined July 2007) Likes (0)
Just so you know, wp_blogs should be in the global database. In this case, buddyceo_ceo.
Member (joined April 2009) Likes (0)
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 (joined July 2007) Likes (0)
That's the move-blogs.php script included with the download.
Member (joined February 2009) Likes (0)
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 (joined May 2007) Likes (0)
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.
Do you have a table called 'ceo'?
This needs to be set to 'buddyceo_ceo';
That error doesn't seem to be Multi-DB related.
Thanks,
Andrew
Member (joined February 2009) Likes (0)
I have a table called 'wp', ex:buddyceo_ceo.wp_1_term_relationships.
Erstwhile founder (joined May 2007) Likes (0)
Can you please list the tables in buddyceo_ceo? There shouldn't be that many.
Thanks,
Andrew
Member (joined February 2009) Likes (0)
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 (joined May 2007) Likes (0)
Hi,
Are you running BuddyPress?
Thanks,
Andrew
Member (joined February 2009) Likes (0)
Yes, I am running BuddyPress.
Erstwhile founder (joined May 2007) Likes (0)
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
Member (joined February 2009) Likes (0)
I have deleted BuddyPress file and related database table.
But, do not new database.
Thanks.
THISWELL
Erstwhile founder (joined May 2007) Likes (0)
I'm afraid I don't understand.
Thanks,
Andrew
Member (joined February 2009) Likes (0)
Please, Check your e-mail.
Thanks.
THISWELL
Erstwhile founder (joined May 2007) Likes (0)
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?:
I explained what that variable needs to be set to a few posts up.
Thanks,
Andrew
Member (joined February 2009) Likes (0)
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 (joined May 2007) Likes (0)
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
Become a member