Changing host database doesn’t work

  • Resolved goodwyne

    (@goodwyne)


    17 years, 6 months ago

    I am at my wits end. I’m attempting to move a WordPress blog from AN Hosting to GoDaddy. I’ve followed the directions at codex.www.ads-software.com/Moving_WordPress and it isn’t working. GoDaddy says I have my db_name, db_user and db_host wrong. I can see the host being wrong but I know the db name, user and password are correct! I chose those when I created the database. GoDaddy support says all that information is in the phpMyAdmin console but I’m darned if I can find it and GoDaddy won’t provide any help. The blog is https://www.israelblog.net. Any help would be greatly appreciated. I’ve been at this all day and I’ve hit a wall and can’t figure out how to proceed.

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

  • Well the DB_HOST is not ‘localhost’ if you are hosted on GoDaddy.

    1. Login to your account at https://www.godaddy.com
    2. Hover over Hosting & Servers, click on My Hosting Account
    3. Click on the Open link to the right of your domain name .
    4.In your Hosting Control Panel, the under Databases tab, click on MySQL under the Databases displayed on the left column menu.
    5.Then under the Database Name click on your database name, and you will see the Host Name–that is what you need to put in wp-config.php for DB_HOST instead of local host.

    Thread Starter goodwyne

    (@goodwyne)

    Thanks, I thought I’d never find the host name. Now that I have it, I still have the same error. I’ve updated wp-config.php with the information. I know the user name, database name and password are correct. I’m still stuck.

    Moderator Samuel Wood (Otto)

    (@otto42)

    www.ads-software.com Admin

    Now that I have it, I still have the same error.

    And what error would that be?

    We moved from one hosting company to another at the beginning of March. I first backed up a database with phpAdmin. But I couldn’t import the database. Well, I could, but I think I had a major error in WP, I think. So I instead used WordPress Database Backup plugin by Mr. Merrill. And we could import the whole data.

    Tom Bluewater
    [sig moderated]

    Thread Starter goodwyne

    (@goodwyne)

    Thanks macsoft3 but that didn’t work. The error I’m getting in phpMyAdmin is “PMA Database … not OK” Every time I import my database I end up with that error message and my blog doesn’t work. I’ve Googled that error message but I don’t understand what I’m finding. It seems I need a superuser but I’m not sure how to go about that and GoDaddy isn’t willing to help me.

    The error I get when attempting to open the blog in a browser is that either the db_name, db_user, db_password or db_host is incorrect or the database server isn’t running. I know beyond doubt that all those things are correct in the wp_config.php file. I’ve double checked and double checked again.

    Right now I’ve pointed the domain back to the old blog so it is at least usable again. Starting to pull my hair out. I’m three days into this and I don’t appear to be making any progress.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Changing host database doesn’t work’ is closed to new replies.