restoring site on local drive that uses multi-DB

I am working with a developer who wants to replicate our a few our our sites on their local drive. We currently have the Multi-DB plugin (256 databases) active. The developer is having issues getting this set up on a local drive. Here is the problem:

– Where & what files in SourceCode need to be configured to map the local database, which are restored

– The developer has completed downloading WordPress SourceCode and Database backup, also changed a few configuration settings to map the WordPress backup site and local database.-

– Developer is not downloading all sites to local drive, rather 2 out of the 900+ sites within MS

– After configuration made in local environment, we are still getting “Error while Connecting to database”

Can you provide me with any tips on how to replicate the site in a local environment? Why are we getting an error message?

Thanks for your help.

  • Barry
    • DEV MAN’s Mascot

    Does he need to set up the multi-db system? It’s quite simple for him to role back to a single database if he would rather work with that.

    After configuration made in local environment, we are still getting “Error while Connecting to database”

    You need to set up the databases, and then edit the db-config.php to point it at the local install with the correct username and password that has been added to the database and assigned full rights to all databases. It’s basically as if you were setting it up from scratch, but with content in the databases instead.

  • bdonaghy
    • Site Builder, Child of Zeus

    Unfortunately, your response did not help in resolving the issues… please see our comments below –

    · We are trying to setup multi-db system – basically trying to setup the complete site (including all sub-sites) in their local environment

    · The complete databases that were downloaded has been restored. The database configurations (un/pwd) has been updated in the files /wp-content/scripts/move-blogs.php and /wp-config.php. The “move-blogs.php “ configuration setting has made based on the documentation provided in multi-db plug-in site.

    Additional questions we have –

    1. What database is configured to / using by powermediallc.org site? Would this be the global database???

    Thanks for any help you can provide

  • Barry
    • DEV MAN’s Mascot

    The complete databases that were downloaded has been restored. The database configurations (un/pwd) has been updated in the files /wp-content/scripts/move-blogs.php and /wp-config.php. The “move-blogs.php “ configuration setting has made based on the documentation provided in multi-db plug-in site.

    Why are you touching move-blogs.php? You already have the tables in the relevant databases.

  • Barry
    • DEV MAN’s Mascot

    The complete databases that were downloaded has been restored. The database configurations (un/pwd) has been updated in the files /wp-content/scripts/move-blogs.php and /wp-config.php. The “move-blogs.php “ configuration setting has made based on the documentation provided in multi-db plug-in site.

    Also, the database settings in wp-config.php are ignored with multi-db you need to update db-config.php like I wrote above.

  • Barry
    • DEV MAN’s Mascot

    1. What database is configured to / using by powermediallc.org site? Would this be the global database???

    Do you main what database the main site would be in? It depends on how your system was originally set up and the names of your main sites tables. If they are, for example, wp_posts then they would be in the global database. If they are wp_1_posts then they would be in the relevant database for that prefix.

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.