Migrate Sites

  • Resolved VVTinho

    (@vvtinho)


    9 years, 10 months ago

    Hi!

    For me the main thing of using SharDB plugin is to separate the wordpress multisite to different databases for each site. I dont really shore that SharDB plugin can do that, but I hope so :).
    I have followed the installation guide, but I get this error when trying to Migrate Sites:
    Can’t select database

    We were able to connect to the database server (which means your username and password is okay) but not able to select the wp_home database.

    Are you sure it exists?
    Does the user root have permission to use the wp_home database?
    On some systems the name of your database is prefixed with your username, so it would be like username_wp_home. Could that be the problem?
    If you don’t know how to set up a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.

    Im google the error but I can nnot find any result on that question…
    Does somebody have a tip on how to solve the error problem, thanks…

    https://www.ads-software.com/plugins/shardb/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Ron Rennick

    (@wpmuguru)

    SharDB isn’t tailored for implementing a different DB for each site. However, if you don’t have a large number of sites, you can use the VIP DB configuration to use a separate DB for each site.

    Does the user root have permission to use the wp_home database?

    By virtue of being the super user, root typically has access to all databases. Unless it’s a local development install, using the root user in your wp-config.php should be avoided.

    On some systems the name of your database is prefixed with your username

    The main place I have seen that is cPanel implementations. If you used cPanel to create your databases then your

    – shardb_prefix would be something like account_dbname_
    – DBs would be named account_dbname_global, account_dbname_0, account_dbname_1, etc.

    You can edit your wp-config.php to see the user that WP is using for the databases. If your DBs follow the naming convention I’ve outlined then check that the user has access to those databases.

    Thread Starter VVTinho

    (@vvtinho)

    Hi!

    Ok, I understand, thanks…
    where can I find a installation guide for VIP DB configuration to use a separate DB for each site?
    Do I have to manually install the new VIP DB databases?

    Is not a local development im running, and I always get this error:
    Can’t select database

    We were able to connect to the database server (which means your username and password is okay) but not able to select the wp_global database.

    Are you sure it exists?
    Does the user root have permission to use the wp_global database?
    On some systems the name of your database is prefixed with your username, so it would be like username_wp_global. Could that be the problem?

    Thanks

    Thread Starter VVTinho

    (@vvtinho)

    Please, some help on getting the plugin to work, thanks…

    Plugin Author Ron Rennick

    (@wpmuguru)

    If WP cannot select the database but the database exists then the WP DB_USER does not have permissions to access the database.

    VIP databases:

    – you have to create these & migrate the sites tables to them before you can use them
    – they have to follow the naming convention of {$shardb_prefix}{NAME}
    – configure in db-settings (at the bottom) add_vip_blog( {blog_id}, {NAME} );

    Thread Starter VVTinho

    (@vvtinho)

    Hi!

    Ok, thanks, I solved the problem I had ??

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Migrate Sites’ is closed to new replies.