New to the community? Start here

Multi-DB Install – the Underscore is needed in db server name??

I am using godaddy hosting, the db server name CAN NOT with a underscore.

Is the Underscore needed in db server name if I want to install Multi-DB??

codes in my db-config.php:

add_db_server('0', 'dc1', 1, 1,'wpmu0.db.6110044.hostedresource.com', 'wpmu0.db.6110044.hostedresource.com', 'wpmu0', 'wpmu0', 'wpmu');

add_db_server('1', 'dc1', 1, 1,'wpmu1.db.6110044.hostedresource.com', 'wpmu1.db.6110044.hostedresource.com', 'wpmu1', 'wpmu1', 'wpmu');

codes in my move-blogs.php:

$newdb_prefix = 'wpmu';

Regards,

Wed, 12 May 2010 7:24:38
  • hankjmatt
    • New Recruit

    That’s my db-config.php looks like:

    // Version: 2.9.2

    //

    //

    //---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('97.74.30.', '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('blogs');

    add_global_table('blog_versions');

    add_global_table('registration_log');

    add_global_table('signups');

    add_global_table('site');

    add_global_table('sitecategories');

    add_global_table('sitemeta');

    add_global_table('usermeta');

    add_global_table('users');

    //

    //

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

    add_db_server('global', 'dc1', 1, 1,'wpmuglobal.db.6110029.hostedresource.com', 'localhost', 'wpmuglobal', 'wpmuglobal', '***');

    add_db_server('0', 'dc1', 1, 1,'wpmu0.db.6110029.hostedresource.com', 'localhost', 'wpmu0', 'wpmu0', '***');

    add_db_server('1', 'dc1', 1, 1,'wpmu1.db.6110029.hostedresource.com', 'localhost', 'wpmu1', 'wpmu1', '***');

    add_db_server('2', 'dc1', 1, 1,'wpmu2.db.6110029.hostedresource.com', 'localhost', 'wpmu2', 'wpmu2', '***');

    add_db_server('3', 'dc1', 1, 1,'wpmu3.db.6110029.hostedresource.com', 'localhost', 'wpmu3', 'wpmu3', '***');

    add_db_server('4', 'dc1', 1, 1,'wpmu4.db.6110029.hostedresource.com', 'localhost', 'wpmu4', 'wpmu4', '***');

    add_db_server('5', 'dc1', 1, 1,'wpmu5.db.6110029.hostedresource.com', 'localhost', 'wpmu5', 'wpmu5', '***');

    add_db_server('6', 'dc1', 1, 1,'wpmu6.db.6110029.hostedresource.com', 'localhost', 'wpmu6', 'wpmu6', '***');

    add_db_server('7', 'dc1', 1, 1,'wpmu7.db.6110029.hostedresource.com', 'localhost', 'wpmu7', 'wpmu7', '***');

    add_db_server('8', 'dc1', 1, 1,'wpmu8.db.6110029.hostedresource.com', 'localhost', 'wpmu8', 'wpmu8', '***');

    add_db_server('9', 'dc1', 1, 1,'wpmu9.db.6110029.hostedresource.com', 'localhost', 'wpmu9', 'wpmu9', '***');

    add_db_server('a', 'dc1', 1, 1,'wpmua.db.6110029.hostedresource.com', 'localhost', 'wpmua', 'wpmua', '***');

    add_db_server('b', 'dc1', 1, 1,'wpmub.db.6110029.hostedresource.com', 'localhost', 'wpmub', 'wpmub', '***');

    add_db_server('c', 'dc1', 1, 1,'wpmuc.db.6110029.hostedresource.com', 'localhost', 'wpmuc', 'wpmuc', '***');

    add_db_server('d', 'dc1', 1, 1,'wpmud.db.6110029.hostedresource.com', 'localhost', 'wpmud', 'wpmud', '***');

    add_db_server('e', 'dc1', 1, 1,'wpmue.db.6110029.hostedresource.com', 'localhost', 'wpmue', 'wpmue', '***');

    add_db_server('f', 'dc1', 1, 1,'wpmuf.db.6110029.hostedresource.com', 'localhost', 'wpmuf', 'wpmuf', '***');

    add_db_server('vip', 'dc1', 1, 1,'wpmuvip.db.6110029.hostedresource.com', 'localhost', 'wpmuvip', 'wpmuvip', '***');

    //

    //

    //---VIP Blogs

    //

    //

    //

    // Usage: add_vip_blog(BLOG_ID, DS)

    // EX: add_vip_blog(1, 'vip1');

    add_vip_blog(1, 'vip');

    My move-blogs.php codes:

    ///DB Settings

    $dbname = "MyOldDataBase"; //This is my current database (built wpmu 2.9.2).

    $blog_table_prefix = 'wp_'; //Prefix of your wpmu blog tables, most likely this won't need to be changed

    $newdb_prefix = 'wpmu'; //There is no Underscore.

    //We need info to connect to the databases

    $dbhost = 'MyOldDataBaseHost';

    $dbuname = 'MyOldDataBase';

    $dbpass = '***';

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

    $db_scaling = '16';

    I get Error Infor:

    Houston, we have a problem!

    Looks like you need to create your new db's! If you're lucky, this link still works - click me

    Database Error: Access denied for user '****' to database '***'

  • Andrew
    • Champion of Loops

    Hiya.

    Is the Underscore needed in db server name if I want to install Multi-DB?

    You can call your databases whatever you want :slight_smile:

    To be honest it doesn’t sound like GoDaddy hosting is a great environment for Multi-DB. In order for the move-blogs.php script to work you’ll need to a single MySQL user with privileges for all databases.

    Thanks,

    Andrew

  • drmike
    • DEV MAN’s Mascot

    WPMu is not recommended for oversellers like Godaddy. You will get booted as soon as you get any decent load on your site.

    You should search these forums as well as the regular mu forums for stories on godaddy.

    And I’ve got to admit that the idea of using a host that sells itself with multiple pairs of breasts isn;t like a highpoint of the hosting industry.