Sanity Check for Restoring WordPress Database from MySQL Workbench Import

[ad_1]

I am teaching myself to manually restore a WordPress Database using MySQL Workstation. This Database is coming from a Production instance in AWS EC2 (Amazon Linux with Maria DB) to a localhost (which is already up and running).

I can successfully export that database and run it locally, but when I run it in a browser I get “Error Establishing Database Connection”.

Using the wp-config.php file, I changed the entries DB\_NAME, DB\_USER and DB\_PASSWORD

*What am I missing for a manual restore?*

Ultimately I’d like to find a system that is both a backup & allows me to run local instances as a sort of “source control”.

Thanks in advance for the sanity check!

[ad_2]
1 Comment
  1. That error means you have incorrect db connection values.

    What is your local set up? Is your DB_HOST value correct?

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer