Re-Linking 5.4 WP to existing SQL base

  • So, I committed the sin of clicking on the “Update to 5.4” button without doing a proper backup of my site first. When the update was done, I got a “cannot be found” error on my main page.
    Luckily, my hosting server had been doing daily backups on my WP directory. So I have that on my local drive.
    I did a fresh install of 5.3 through Softaculous. That got me to a WP Dashboard with just one “Hello World” post. I was then able to update to 5.4.
    I tried to re-import my databse’s SQL file through PHPMyADmin, but it errored out, saying the tables already existed (I had thought they might be overwritten). I looked a little more closely at the table in my markmcde_wp### base, and I saw my data, posts, and WooCommerce tables were still present.

    I’ve been looking for an administrative tool that would re-link my WP install to my existing database. No luck so far. Clearly there are some steps I am missing, so any help out here would be appreciated.

    Mark

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)

  • To connect your WordPress install to a database, you need to edit the wp-config.php file. It tells WordPress what to connect to and that’s where your database configuration details are.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    It seems like you’d just need to edit the “table prefix” define in wp-config.php to point to the right set of tables. I think it should be markmcde_wp_ based on your message.

    Thread Starter markmcdermott

    (@markmcdermott)

    I’ll check each option. Thanks.

    Thread Starter markmcdermott

    (@markmcdermott)

    Well, that gave me the “error establishing a database connection” message.

    I had set these lines:
    define( ‘DB_NAME’, ‘markmcde_wp875’ );
    define( ‘DB_USER’, ‘markmcde_wp875’ );

    To the other database number.
    I also set
    $table_prefix = ‘wpy7_’;
    To the other database table prefix. When I first got the error, I changed it back, just to see what happened.

    Now there is also a line for:
    define( ‘DB_PASSWORD’, ‘xxxxxxxxx’ );
    That looks like it was set randomly. I know I didn’t pick that password. Should I change it, or somehow find the password for the new db?

    Mark

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Find the password for the db. It should be doable in your hosting control panel someplace.

    What is the database name as you see it in phpmyadmin? that’s what you should use for “DB_NAME”. As to DB_USER, that depends on how you (or your host) set up the database. It might be a good idea to call your host about this.

    Thread Starter markmcdermott

    (@markmcdermott)

    Well, I’m getting close. My Shop comes up, at https://markmcdermott.com/wp/shop/, with no merch, because I didn’t put WooCommerce in the install.
    But the main blog, just https://markmcdermott.com/wp/, is erroring out.
    I think my issue now is getting agreement on the NameServers: GoDaddy wants to use their, x10hosting has their own. I had my domain set up to direct “markmcdermott.com” to the WP directory. Now it seems I need to go straight to markmcde.x10host.com/wp/. But this is a different issue.

    Added: Checking over the issue of DNS servers, I see the recommendation is that I should keep the hosting server’s DNS and add them to the domain server. Also, that changed in DNS can take up to 24 hours to “propagate” through the net. So maybe I’ll put this away for now.

    Thanks loads for your suggestions!

    • This reply was modified 4 years, 8 months ago by markmcdermott.
Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Re-Linking 5.4 WP to existing SQL base’ is closed to new replies.