• Hello, I am trying this plugin to split up my database to accommodate a large number of sites. I have configured everything according to the documentation but it seems something is missing. When i try to run the SharDBMigration from settings i get the below error.

    Error: You must configure your database settings by adding require(‘./db-settings.php’); to your /var/www/blogs.myblogs.com/wp-config.php for the migration process to work

    I have added the below lines to the wp-config.php file but its almost as it it doesn’t see the file.

    define(‘DB_COLLATE’, ”);
    require(‘db-settings.php’);
    define(‘VHOST’, ‘no’);
    $base = ‘/’;
    define(‘DOMAIN_CURRENT_SITE’, ‘blogs.myblog.com’ );
    define(‘PATH_CURRENT_SITE’, ‘/’ );
    define(‘BLOGID_CURRENT_SITE’, ‘1’ );

    My db-settings.php file changes are below

    // 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 = ‘myblogs_blogs’;
    // set a string to be used as an internal identifier for the dataset
    $shardb_dataset = ‘123’;
    // 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);

    Any help would be appreciated.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter baldman

    (@baldman)

    I was able to resolve this error. This was on my part. What i am seeing now if the multi site authentication process is failing. It appears that not all tables were copied over to the new multi database setup.

    I have the same problem what can be the error?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Migration error’ is closed to new replies.