Changed hosts – can’t get sql to work

  • Canned_Heat

    (@canned_heat)


    20 years ago

    I changed hosting services. I searched these forums for help and followed the tamba2 tutorial, but it still wont work. Need help.

    Here’s what I’ve done:

    – the hosting change was seamless. the blog domain for the old wp install was blogdomain.com and on the new host it is blogdomain.com. So changes to the wp-config were not necessary.

    – the account name I created on the new host was exactly the same as on the old host. In other words, the account was “accountname” on both, so when I manally created the wrdp1 sql database on the new host, the full name was accountname_wrdp1, exactly the same as on the old host.

    – I went into phpmyadmin and chose the database then did the restore where you browse for the backup file. It appears to have restore ok because the data tables are as they were before.

    So why don’t it work? When I browse to the blogdomain, it brings up the screen the “error establishing a database connection” error screen.

    What am I missing?

    Thanks,
    CH

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

  • Change your password in config.php?

    Thread Starter Canned_Heat

    (@canned_heat)

    How do I change that? In wp-config.php the password appears to be encrypted.

    Moderator James Huff

    (@macmanx)

    It isn’t suppose to be. Type in your correct password.

    Thread Starter Canned_Heat

    (@canned_heat)

    Thanks! Didn’t work (totally), but put me on the right track.

    I would like to know what went wrong so I don’t do it again. Here’s what the problem was:

    After doing sql export on old host, here’s what the key fields in wp-config looked like:

    define(‘DB_NAME’, ‘accountname_wrdp1’);
    define(‘DB_USER’, ‘accountname_wrdp1’);
    define(‘DB_PASSWORD’, ‘W13dFgHM890Oo’);
    define(‘DB_HOST’, ‘localhost’);

    where:
    wrdp1 – sql database
    accountname = my main account name on old and new server

    It should have looked like this:

    define(‘DB_NAME’, ‘accountname_wrdp1’);
    define(‘DB_USER’, ‘accountname’);
    define(‘DB_PASSWORD’, ‘correctpassword’);
    define(‘DB_HOST’, ‘localhost’);

    What did I do wrong either exporting from the old server or importing to the new server that caused:

    – encrypting of the password
    – the username to be replaced with the full username/sql db name?

    It’s fixed now, and it’s a small point, but I would like to know what went wrong so that I can prevent this from happening in the future, and it can also be helpful to some other user searching these forums

    Thanks,
    CH

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Changed hosts – can’t get sql to work’ is closed to new replies.