Migrated to new host, database error

[HannahParticipant]

I successfully migrated a client’s site to a new host, but it had a database error because it was trying to connect to the db at the old host. I changed wp-config to reflect the new db name, user and password, and now WordPress is asking to be installed again! What do I do now?

[udadminKeymaster]

Please can you post a link to the restoration log? You can find this in wp-content/updraft on the destination site.

From the description, it sounds like you ticked the option to replace wp-config.php? (The tick-box with the warning next to it, linking to an article which explains that you almost certainly don’t want to tick it…). But, if you can link the restoration log, I can see what did happen, rather than speculate!

David

[HannahParticipant]

This reply has been marked as private.

[udadminKeymaster]

Hi,

Thanks. You say:

I got a database error saying it couldn’t connect to the database at evemargowithrow.ipower.com, which was the old host.

Please can you link a screenshot of that error? The normal WordPress error for wrong database details doesn’t mention the host of the MySQL server, so, this error appears to be something other than that. If you can link a screenshot, then that’ll help me know what it is.

By the way – the above log is of a restore of the database only – not of plugins/uploads/themes/others. Is there another log for that?

David

[HannahParticipant]

This reply has been marked as private.

[udadminKeymaster]

Hi Nancy,

I’m wondering – how did you install WordPress on the new hosting? Did you copy wp-config.php from the original site, so that it was always pointing at the original hosting? In that case, the database ‘restore’ would have just replaced the database at the original MySQL server with a copy of itself – i.e. done nothing. And as such, you don’t yet have any database set up at the new hosting – which is why the ‘install’ screen shows. Installing sets up a basic, empty set of tables that make up a WordPress database – and then you’d need to do the database restore again (but not the other parts) to populate it with your site data; after which (if I’ve understood rightly) you’d then be all done.

David

[HannahParticipant]

It was definitely the security plugin! I deleted it and one of its other files via ftp this morning, got into the site, reinstalled and configured BPS Pro, and it’s all good now! This was the first time I had migrated a site that had BPS Pro active, so I did learn a valuable lesson for future migrations: disable or delete BPS Pro first, then add it back in after the migration is complete. Thanks for helping me get through this, Updraft.

[Author]

Posts