Error establishing a database connection

Hi,

Thank you for reaching out.

It seems like the issue is related to the database connection details in the wp-config.php file. Since you’re restoring the site on a local environment, here’s what you can check:

1. Verify Database Credentials: Double-check the database name, username (which seems to be root), and password (which you mentioned is blank) in the wp-config.php file of your restored site. Ensure these details match the local database you created.
2. Check Database Host: For local setups, the database host should typically be set to localhost in the wp-config.php file. Ensure this is correctly set.
3. Database Import: Ensure the database from the live site was properly imported into your local database. Check if all tables are present in your local database.
4. Local Server Compatibility: Ensure your local environment (PHP, MySQL/MariaDB versions) is compatible with your WordPress installation.

Let me know if that helps!

Best Regards,

You wrote “Check if all tables are present in your local database.” That is a huge ask! It is not a Word document, something under MySQL. That’s the only task your plugin should be doing.

Verify Database Credentials: Ideally, these instructions should be published along with “Help”. Usually, these details are encrypted. In all the localhost installations, the wp-config never divulged these details (as often I forgot my login, and this file was of no use).

Database Import: How does one ensure that it was properly imported. My site had over 185 tables, how do I know which table has what?

Other plugins do give errors, but NONE asked me for these observations. This shows, perhaps, your plugin is half-baked.

My local server had almost exactly the similar configuration.

Other plugins asked for “Host login details” while logging into the transferred site, as the plugin noted down the same. It is surprising, I could not even use it as it threw an error.

Hi,

I wanted to let you know that restoring your website on a local workstation is possible, but it requires some manual adjustments, such as changing the domain references from “x.y.z.com” to “localhost.” This can be done using tools like WP-CLI or plugins like “Better Search Replace” to update the database after the restore.

If you’re looking for a more automated solution, the pro version of BackWPUp includes a migration feature that allows you to move your site to a different domain or localhost more seamlessly.

Let me know if you need further assistance!

Best regards,