Using Local to Stage site; database issues

  • sewgoth

    (@sewgoth)


    2 months, 4 weeks ago

    Hello, there!

    I want to redesign and optimize my website (currently only a blog). I will be using Local since I cannot use the staging feature of Siteground due to the size of my website (15GB).

    I downloaded the backup, set up a test website in Local, and replaced the wp-content folder, wp-config.php, and the sql file with the ones from my backup.

    When I opened the Local site, I get a message to enter my database into.

    “Welcome to WordPress. Before getting started, you will need to know the following items.

    1. Database name
    2. Database username
    3. Database password
    4. Database host
    5. Table prefix (if you want to run more than one WordPress in a single database)”

    I used the info from my sql file, but I got the following message:

    “Error establishing a database connection

    This either means that the username and password information in your wp-config. php file is incorrect or that contact with the database server at localhost could not be established. This could mean your host’s database server is down.

    • Are you sure you have the correct username and password?
    • Are you sure you have typed the correct hostname?
    • Are you sure the database server is running?”

    How can I solve this issue? Any help would be much appreciated.

    Paula

    • This topic was modified 2 months, 4 weeks ago by James Huff. Reason: moved to Localhost Installs since this is a localhost install
Viewing 1 replies (of 1 total)
  • Moderator bcworkz

    (@bcworkz)

    2 months, 4 weeks ago

    Your Local DB requires credentials that are not the same as from the SQL file of your backup. Consult Local documentation or its dedicated support channel for what the correct credentials should be. Edit your Local wp-config.php file so that the correct DB credentials are used.

    If you import your current site’s SQL data into your Local DB, you’ll need to modify some elements in the DB. Review the Migrating WP page for further guidance.

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.