Can't export database to live server

Support
1

Hello,

I need to export my local database on “Local by Flywheel” to my server. I click on “Export” on "Adminer which generates a zip file.

However, when I try to import it to my database on the live server , I get the following error message

Requête SQL :
CREATE TABLE wp_commentmeta (
_ meta_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,_
_ comment_id bigint(20) unsigned NOT NULL DEFAULT ‘0’,_
_ meta_key varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,_
_ meta_value longtext COLLATE utf8mb4_unicode_520_ci,_
_ PRIMARY KEY (meta_id),_
_ KEY comment_id (comment_id),_
_ KEY meta_key (meta_key(191))_
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
MySQL a répondu : Documentation
#1273 - Unknown collation: ‘utf8mb4_unicode_520_ci’

I am stuck and don’t know how to solve this issue.
Is it because my server has an SQL version 5.5 and Flywheel has a SQL version 5.6.37?

Thanks in advance for your help,
Manal

2

Hi @manalik,

Yup, you’re exactly right regarding the MySQL version discrepancy.

Depending on your host, you may be able to write them a quick support request asking that they upgrade your site to MySQL 5.6+.

Another thing you can try is exporting using the WP Migrate DB plugin. WP Migrate DB can create an SQL export file that’s compatible with MySQL 5.5.