WordPress.org

Support

Support » Plugins and Hacks » SharDB » [Plugin: SharDB] Database tables unavailable

[Plugin: SharDB] Database tables unavailable

  • 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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • This may be connected with the fact that all first blog tables do not get copied. Taxonomy, Terms, etc do not get copied.

    Plugin Author Ron Rennick

    @wpmuguru

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[Plugin: SharDB] Database tables unavailable’ is closed to new replies.
Skip to toolbar