Title: Updraft Migrator error
Last modified: August 24, 2016

---

# Updraft Migrator error

 *  [Aabtexas](https://wordpress.org/support/users/aabtexas/)
 * (@aabtexas)
 * [11 years ago](https://wordpress.org/support/topic/updraft-migrator-error/)
 * I’m trying to migrate my site from a localhost to a live server.
    But when I 
   use miragtor and select restore, I get this error message.
 * Final checks
    Looking for db archive: file name: backup_2015-04-24-1251_All_American_Balloons_ae194ce4f13c-
   db.gz Archive is expected to be size: 482.9 Kb: OK Looking for plugins archive:
   file name: backup_2015-04-24-1251_All_American_Balloons_ae194ce4f13c-plugins.
   zip Archive is expected to be size: 33571.5 Kb: OK Looking for themes archive:
   file name: backup_2015-04-24-1251_All_American_Balloons_ae194ce4f13c-themes.zip
   Archive is expected to be size: 1088 Kb: OK Looking for uploads archive: file
   name: backup_2015-04-24-1251_All_American_Balloons_ae194ce4f13c-uploads.zip Archive
   is expected to be size: 25220.9 Kb: OK Looking for others archive: file name:
   backup_2015-04-24-1251_All_American_Balloons_ae194ce4f13c-others.zip Archive 
   is expected to be size: 2.6 Kb: OK Will not delete any archives after unpacking
   them, because there was no cloud storage for this backup
 * Database
    Unpacking backup… Restoring the database (on a large site this can 
   take a long time – if it times out (which can happen if your web hosting company
   has configured your hosting to limit resources) then you should use a different
   method, such as phpMyAdmin)… Enabling Maintenance mode… Backup created by: 1.9.64
   Backup of: [http://localhost/WP](http://localhost/WP) Content URL: [http://localhost/WP/wp-content](http://localhost/WP/wp-content)
   Old table prefix: wp_ Site information: multisite = 0 New table prefix: wp_ Restoring
   table (InnoDB): wp_options An error (1) occurred: – Unknown collation: ‘utf8mb4_unicode_ci’–
   the database query being run was: CREATE TABLE `wp_options` ( `option_id` bigint(
   20) unsigned NOT NULL AUTO_INCREMENT, `option_name` … Disabling Maintenance mode…
   Error message: An error occurred on the first CREATE TABLE command – aborting
   run
 * Restore failed…

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Garrett Hyder](https://wordpress.org/support/users/garrett-eclipse/)
 * (@garrett-eclipse)
 * [10 years, 10 months ago](https://wordpress.org/support/topic/updraft-migrator-error/#post-6096619)
 * I’m also getting this error, was there any resolution on this [@aabtexas](https://wordpress.org/support/users/aabtexas/)?
   Thanks
 *  [Garrett Hyder](https://wordpress.org/support/users/garrett-eclipse/)
 * (@garrett-eclipse)
 * [10 years, 10 months ago](https://wordpress.org/support/topic/updraft-migrator-error/#post-6096620)
 * Update – I resolved this by going through phpMyAdmin and exporting with these
   steps for supporting older MySQL version;
    [https://wordpress.org/support/topic/unknown-collation-utf8mb4_unicode_ci?replies=19#post-6884250](https://wordpress.org/support/topic/unknown-collation-utf8mb4_unicode_ci?replies=19#post-6884250)
 * Cheers

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Updraft Migrator error’ is closed to new replies.

## Tags

 * [moving](https://wordpress.org/support/topic-tag/moving/)

 * 2 replies
 * 2 participants
 * Last reply from: [Garrett Hyder](https://wordpress.org/support/users/garrett-eclipse/)
 * Last activity: [10 years, 10 months ago](https://wordpress.org/support/topic/updraft-migrator-error/#post-6096620)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics