Problems accessing migrated site – Backup failure OR Search and Replace error

[Cheryl YanceyParticipant]

Hello,
I am trying to create a copy of a site onto a new URL. I created a backup of the site (which was sent to remote storage), then created a clean WP isntall on the new URL. Then I installed UpDraftPlus (Premium), set up the remote storage link, made sure it was logged in (with migrator add-on enabled) and clicked “restore” on the backup.

As the restore process transfered folders, I kept having to cancel and restart the restore process because it would get hung up… I let it go for an hour just to make sure it was hng up, not just processing.

When the restore completed, I was prompted to login. However, this login redirected me to the old URL. I tried manually typing “…./wp-admin” but it still redirected me. Also, I noticed that the main nav still points to the old site.

I’d like to try to use the search-and-replace feature built into UpDraftPlus, but I can’t reach the admin panel in order to do so.

I have turned off all plugins and reverted to a basic WP theme… to no avail.

Your help is greatly appreciated!!!

[Bryle CroduaModerator]

Hi,

Apologies for the delay.

To help us work out the cause of your problem, can you please send us a copy of the restoration log only?
You can find this log in the ‘wp-content/updraft’ directory of your site via FTP.
You can send the log file as an attachment or copy the contents into an online tool (such as https://pastebin.com/ )

Best Wishes,
Bryle

[Cheryl YanceyParticipant]

NEVERMIND – I was able to repair it.

If anyone else is having similar issues, here’s the solution.

I tried THREE fresh installs, and THREE freshly created backups and nothing seemed to work. I was certain I had checked the “search and replace” box during reload… I even took a screenshot just to be sure.

BUT for some reason the restoration didn’t search & replace the database. So… I had to use the following query via phpMyAdmin:

UPDATE wpns_options SET option_value = REPLACE(option_value, ‘https://oldsite.com’, ‘https://newsite.com’) WHERE option_value LIKE ‘https://oldsite.com%’;

This allowed me to get into the admin panel, which I was unable to do before.

Then I ran the UpDraftPlus Search and Replace feature in the “Advanced” tab.

Voila!!

[Author]

Posts