Manual DB restore failing – Migrator is the only way?

Hi there,

In your instructions I saw that there was meant to be the option to do a manual restore of the DB – meaning that I should be able to grab the sql file from the .gz backup and simply use your host’s usual DB interface (like PHPmyAdmin) to do restores of the DB.

What I have run into while attempting to verify that Updraft does work for my particular sites is that I cannot actually use that file unless I use it with Migrator / the WordPress Admin interface – which works just fine.

So for example:
– I can dump the DB manually and restore it to a new DB manually just fine.
– when I take the backup of the db made by updraft and attempt to restore it to a new DB it fails out (with a variety of errors depending on which site’s DB I’m attempting to restore, I should add).

In running it for an example error right now I get failure logs that start with:

[Err] 1366 – Incorrect string value: ‘\xF0\x9F\x98\x9B” …’ for column ‘option_value’ at row 212
[Err] # Data contents of table wp_options
INSERT INTO wp_options VALUES (1, ‘siteurl’, ……….

Basically it can never get beyond the wp_options table.

Any thoughts? It’s probably something very simple that I’m failing to do to prep your product’s DB dump for manual re-import.

Thanks!