Cannot Restore Site Database (UTF8)

[jcsammy68Participant]

Hi UpdraftPlus Support,

I am trying to migrate a site from one server to the other. I thought your UpdraftPlus migration tool would help me, but I can’t seem to get it to work for me. I used your tool to create the backup files (Database, Plugin, Themes, Others, Uploads). I was able to restore all backup files except for the Database.

I did notice a warning prior to the restore: “The database server that this WordPress site is running on doesn’t support the character set (UTF8) which you are trying to import. You can choose another suitable character set instead and continue with the restoration at your own risk.”

I was given the option to select UTF8mb3 which I did. However, the site failed to load. I also tried UTF8mb4 but the site also failed.

Any help you can provide will be appreciated.

[jcsammy68Participant]

This reply has been marked as moderator-only.

[Paul BevanKeymaster]

Hello,

Would it be possible for you to share the restoration log file associated with the failed database restore via pastebin.com please? You can find this in the wp-content / updraft folder. The restoration log (as opposed to a backup log) will have the word “restore” in it and have a date modified value which corresponds with the restoration.

Best,

Paul

[jcsammy68Participant]

Found two log files but they do not have the word “restore” in their file names. see below:

log.f3f917702379-browser.txt
log.f3f917702379.txt

Will attempt the database restore again. Hopefully the filename will be there after the restore.

• This reply was modified 12 months ago by jcsammy68.

[jcsammy68Participant]

After I tried to restore the database again, the only files that show up are named like “log.??????-browser.txt” and “log-??????.txt”.

I also tried to restore database tables in groups.
“wp-options” is only table I tried to restore separately, and it is the only table that caused the site to fail.

• This reply was modified 12 months ago by jcsammy68.
• This reply was modified 12 months ago by jcsammy68.

[jcsammy68Participant]

I noticed an error while UpdraftPlus was restoring the “wp_options” table:

An error (1) occurred: – Variable ‘sql_mode’ can’t be set to the value of ‘NULL’ – the database query being run was: I cannot paste teh SQL statement here because your site will block me.
Disabling Maintenance mode…
Atomic restore: dropping original table (wp_options)
Atomic restore: renaming new table (tv_options) to final table name (wp_options)
Search and replacing table: wp_options: rows: 464
Finished: lines processed: 510 in 1.21 seconds
Cleaning up rubbish…
This option was not selected.

[Paul BevanKeymaster]

Hello,

Apologies I should have been clearer, I was referring to the word “restore” in the actual files themselves rather than the filename. Please could you share them via pastebin.com?

Best,

Paul

[jcsammy68Participant]

I am having issues with pastebin.com — I cannot activate my account because I did not receive the activation email nor will Pastebin.com resend it.
Do you have another way to get the file to you?

[jcsammy68Participant]

I paste the file as a guest. https://pastebin.com/0zxGX20j

[VanessaModerator]

This says the restore was successful but you only restored your user and user meta tables.
Can you do another backup of your DB from the source site and post the log?

[jcsammy68Participant]

Backup and restore to a new server instance was successful. Steps taken:

1. Changed the custom WordPress login slug back to “wp-admin”
2. Backup everything
3. Restore the database first ***Use the UpdraftPlus recommended UTF8MB3 to replace UTF8***
4. Restore the other backups: plugins, themes, other, uploads
5. Activated the plugins ***Apparently the restore did not activate the plugins***
6. Do not activate plugins that are not tested with the latest WordPress version
7. Activate the theme
8. Configure security
9. Change WordPress login slug to a ***custom slug***
10. Configure GeoBlock

That’s it!

Thank you for your help!

[VanessaModerator]

I am glad to hear that you managed to restore.
If the DB is restored separately to the DB, they will be automatically deactivated to prevent errors.

[Author]

Posts