Migrate WordPress Website and Database to new host (same domain)

  • I am encountering an issue when trying to migrate a WordPress website to a new host. My current website is hosted with Laughing Squid. This host is a VERY bare-bones hosting provider, with no cPanel. I have migrated many many WordPress websites before, but never encountered this.

    My clients existing WordPress SQL database name as well as the database username has a prefix of “459774”:

    Database name is “459774_databaseName”
    Database username is “459774_databaseUserName”

    My steps taken so far are as follows:

    * In the GoDaddy domain settings: Remove the Laughing Squid DNS nameservers and set the default GoDaddy nameservers. Another thing to note, my client has always used GoDaddy for the domain, and used the Laughing Squid Hosting up until last week.

    1. Backup (export) existing WordPress database from Laughing Squid host through phpMyAdmin.

    2. On New Host (GoDaddy), create a new database with the same name as the Laughing Squid host “459774_databaseName”.

    3. This is where I’m somewhat confused. I cannot create the same username that Laughing Squid uses ( “459774_databaseUserName” ) because GoDaddy does not allow a SQL database username to begin with numeric values, however Laughing Squid seems to REQUIRE the database username to start with the “459774_” prefix.

    4. Restore (import) the backed up database file from Laughing Squid host from within phpMyAdmin on new host (GoDaddy).

    5. Edit (update) the wp-config.php with the new (GoDaddy) host (“localhost”). DatabaseName, databaseUserName and databaseUserName password.

    6. When launching the website, i am getting “Error establishing a database connection”.

    So at this point i am thinking im forgetting to do something very simple, or maybe its something a little more advanced. If someone could please lend a hand I would be so forever grateful! Thank you in advance for your help. I really need to get this site migrated asap so i can start this redesign.

    Thanks for your help!

    Adam
    Rochester, NY

Viewing 1 replies (of 1 total)

  • If I recall correctly (I used to run my blog on GoDaddy too), DB_HOST on GoDaddy should actually be a host name and not localhost. Try finding your database host name and putting that into the DB_HOST variable of wp-config. You should be able to find it where you setup the database on your Godaddy Cpanel.

Viewing 1 replies (of 1 total)
  • The topic ‘Migrate WordPress Website and Database to new host (same domain)’ is closed to new replies.