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,

  • hankjmatt

    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 '***'

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.