WordPress.org

Ready to get started?Download WordPress

Forums

SharDB
Database tables unavailable (3 posts)

  1. filesofnerds
    Member
    Posted 3 years ago #

    Getting the error:

    One or more database tables are unavailable. The database may need to be repaired.

    Of course, this is all very general. So, some files.

    1. db.php is as-as in wp-content/
    2. shardb-admin.php is as-is in wp-content/plugins/shardb/
    3. db-settings changes:

    // how many characters of hexidecimal hash
    $shardb_hash_length = 1;
    // what is the prefix of your blog database shards (everything before the hexidecimal hash)
    $shardb_prefix = 'shar_xxx_';
    // set a string to be used as an internal identifier for the dataset
    $shardb_dataset = 'sh';
    // do you want to put your primary blog (blog_id 1) in its own 'home' database?
    $enable_home_db = true;
    // how many, if any, VIP databases do you have?
    $num_vipdbs = 0;
    // add this to set the write master read priority (default 1)
    $shardb_master_read = 99;
    // add this if all of your databases are on a local server
    $shardb_local_db = true;
    // use this function to add a read slave host
    add_slave($read_priority, $hostname, $local_hostname, $user, $password);
    // VIP DB's
    //if ( $enable_home_db === true )
    	//add_vip_blog( 1, 'home' );    // home blog

    I have 0-9, a-f, global and home databases, which map to "shar_xxx_"; for instance: shar_xxx_0, shar_xxx_1, shar_xxx_2, ..., shar_xxx_a, shar_xxx_b, etc.

  2. filesofnerds
    Member
    Posted 3 years ago #

    This may be connected with the fact that all first blog tables do not get copied. Taxonomy, Terms, etc do not get copied.

  3. Ron Rennick
    MultiSite Guru
    Plugin Author

    Posted 3 years ago #

    This may be connected with the fact that all first blog tables do not get copied. Taxonomy, Terms, etc do not get copied.

    If you have a WP 3.0/3.1 network (not an upgraded MU install), the main site's table are expected to be in the global database. The main site's tables are copied with the global tables.

    Do you have version 2.7.5?

    Did you follow the installation instructions http://wordpress.org/extend/plugins/shardb/installation/?

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags