Duplicate from mysql Server 5.6.35 to 5.5.57 on Ubuntu VPS

Hello to all.
So, i had this error in the past but now my problem is a little different.
Here is my 1st problem that was solved by @corylamleorg
https://www.ads-software.com/support/topic/duplicate-from-ubuntu-to-xxserver/#post-8247633

Now my 2nd problem.
I want to duplicate from Ubuntu 16.04 to Ubuntu 14.04
I have olso change sql_mode=NO_ENGINE_SUBSTITUTION
The duplicate process was with version Developer 1.2.0, and the new version of Duplicator 1.2.15. I think we cannot downgrade? Sad…please update the plugin!

Here is my errors:

File timestamp is ‘Current’ mode: 2017-07-26 12:51:09
<<< EXTRACTION COMPLETE: true

WEB SERVER CONFIGURATION FILE RESET:
– Backup of .htaccess/web.config made to *.170726125109.orig
– Reset of .htaccess/web.config files

STEP-1 COMPLETE @ 12:51:09 – RUNTIME: 0.9459 sec.

********************************************************************************
* DUPLICATOR-LITE: INSTALL-LOG
* STEP-2 START @ 12:51:31
* NOTICE: Do NOT post to public sites or forums
********************************************************************************
————————————–
DATABASE ENVIRONMENT
————————————–
MYSQL VERSION: This Server: 5.5.57 — Build Server: 5.6.35
FILE SIZE: database.sql (2.62MB) – installer-data.sql (2.62MB)
TIMEOUT: 5000
MAXPACK: 16777216
SQLMODE: NO_ENGINE_SUBSTITUTION
NEW SQL FILE: [/var/www/html/www.mydomain.com/installer-data.sql]
DATABASE RESULTS
————————————–
**ERROR** database error write ‘Unknown collation: ‘utf8mb4_unicode_520_ci” – [sql=
CREATE TABLE wp_commentmeta (
meta_id bigint(20) unsigned NOT NULL A…]
**ERROR** database error write ‘Unknown collation: ‘utf8mb4_unicode_520_ci” – [sql=
CREATE TABLE wp_comments (
comment_ID bigint(20) unsigned NOT NULL A…]
**ERROR** database error write ‘Unknown collation: ‘utf8mb4_unicode_520_ci” – [sql=
CREATE TABLE wp_links (
link_id bigint(20) unsigned NOT NULL AUTO_IN…]
**ERROR** database error write ‘Unknown collation: ‘utf8mb4_unicode_520_ci” – [sql=
CREATE TABLE wp_options (
option_id bigint(20) unsigned NOT NULL AUT…]
**ERROR** database error write ‘Unknown collation: ‘utf8mb4_unicode_520_ci” – [sql=
CREATE TABLE wp_postmeta (
meta_id bigint(20) unsigned NOT NULL AUTO…]
**ERROR** database error write ‘Unknown collation: ‘utf8mb4_unicode_520_ci” – [sql=
CREATE TABLE wp_posts (
ID bigint(20) unsigned NOT NULL AUTO_INCREME…]
**ERROR** database error write ‘Unknown collation: ‘utf8mb4_unicode_520_ci” – [sql=
CREATE TABLE wp_term_relationships (
object_id bigint(20) unsigned N…]
**ERROR** database error write ‘Unknown collation: ‘utf8mb4_unicode_520_ci” – [sql=
CREATE TABLE wp_term_taxonomy (
term_taxonomy_id bigint(20) unsigned…]
**ERROR** database error write ‘Unknown collation: ‘utf8mb4_unicode_520_ci” – [sql=
CREATE TABLE wp_termmeta (
meta_id bigint(20) unsigned NOT NULL AUTO…]
**ERROR** database error write ‘Unknown collation: ‘utf8mb4_unicode_520_ci” – [sql=
CREATE TABLE wp_terms (
term_id bigint(20) unsigned NOT NULL AUTO_IN…]
**ERROR** database error write ‘Unknown collation: ‘utf8mb4_unicode_520_ci” – [sql=
CREATE TABLE wp_usermeta (
umeta_id bigint(20) unsigned NOT NULL AUT…]
**ERROR** database error write ‘Unknown collation: ‘utf8mb4_unicode_520_ci” – [sql=
CREATE TABLE wp_users (
ID bigint(20) unsigned NOT NULL AUTO_INCREME…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=
/* INSERT TABLE DATA: wp_options */
INSERT INTO wp_options VALUES(“1”, “…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“7”, “start_of_week”, “1”, “yes”)…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“8”, “use_balanceTags”, “0”, “yes”)…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“9”, “use_smilies”, “1”, “yes”)…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“10”, “require_name_email”, “1”, “yes”)…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“11”, “comments_notify”, “1”, “yes”)…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“12”, “posts_per_rss”, “10”, “yes”)…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“13”, “rss_use_excerpt”, “0”, “yes”)…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“14”, “mailserver_url”, “mail.example.com”,…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“15”, “mailserver_login”, “[email protected]…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“16”, “mailserver_pass”, “password”, “yes”)…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“17”, “mailserver_port”, “110”, “yes”)…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“18”, “default_category”, “1”, “yes”)…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“19”, “default_comment_status”, “open”, “ye…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“20”, “default_ping_status”, “open”, “yes”)…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“21”, “default_pingback_flag”, “1”, “yes”)…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“22”, “posts_per_page”, “10”, “yes”)…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“23”, “date_format”, “j F Y”, “yes”)…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“24”, “time_format”, “G:i”, “yes”)…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“25”, “links_updated_date_format”, “j F Y G…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“26”, “comment_moderation”, “0”, “yes”)…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“27”, “moderation_notify”, “1”, “yes”)…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“28”, “permalink_structure”, “/%postname%/”…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“29”, “rewrite_rules”, “a:109:{s:34:\”sitem…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“30”, “hack_file”, “0”, “yes”)…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“31”, “blog_charset”, “UTF-8”, “yes”)…]
**ERROR** database error write ‘Table ‘cartoonline.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“32”, “moderation_keys”, “”, “no”)…]
/* INSERT TABLE DATA: wp_posts */
INSERT INTO wp_posts VALUES(“5”, “1”, …]
**ERROR** database error write ‘Table ‘cartoonline.wp_posts’ doesn’t exist’ – [sql=INSERT INTO wp_posts VALUES(“6”, “1”, “2017-01-04 16:29:39”, “2017-01-04 …]
**ERROR** database error write ‘Table ‘cartoonline.wp_posts’ doesn’t exist’ – [sql=INSERT INTO wp_posts VALUES(“7”, “1”, “2017-01-04 16:30:00”, “2017-01-04 …]
**ERROR** database error write ‘Table ‘cartoonline.wp_posts’ doesn’t exist’ – [sql=INSERT INTO wp_posts VALUES(“9”, “1”, “2017-01-05 10:27:05”, “2017-01-05 …]
**ERROR** database error write ‘Table ‘cartoonline.wp_posts’ doesn’t exist’ – [sql=INSERT INTO wp_posts VALUES(“10”, “1”, “2017-01-05 10:27:10”, “2017-01-05…]
**ERROR** database error write ‘Table ‘cartoonline.wp_posts’ doesn’t exist’ – [sql=INSERT INTO wp_posts VALUES(“11”, “1”, “2017-03-20 10:34:25”, “0000-00-00…]
**ERROR** database error write ‘Table ‘cartoonline.wp_posts’ doesn’t exist’ – [sql=INSERT INTO wp_posts VALUES(“12”, “1”, “2017-01-05 10:28:32”, “2017-01-05…]
**ERROR** database error write ‘Table ‘cartoonline.wp_posts’ doesn’t exist’ – [sql=INSERT INTO wp_posts VALUES(“13”, “1”, “2017-01-05 11:27:27”, “2017-01-05…]
**ERROR** database error write ‘Table ‘cartoonline.wp_posts’ doesn’t exist’ – [sql=INSERT INTO wp_posts VALUES(“14”, “1”, “2017-01-05 11:27:59”, “2017-01-05…]
**ERROR** database error write ‘Table ‘cartoonline.wp_posts’ doesn’t exist’ – [sql=INSERT INTO wp_posts VALUES(“15”, “1”, “2017-01-05 11:28:53”, “2017-01-05…]
**ERROR** database error write ‘Table ‘cartoonline.wp_posts’ doesn’t exist’ – [sql=INSERT INTO wp_posts VALUES(“16”, “1”, “2017-03-20 10:49:37”, “2017-03-20…]
**ERROR** database error write ‘Table ‘cartoonline.wp_posts’ doesn’t exist’ – [sql=INSERT INTO wp_posts VALUES(“17”, “1”, “2017-01-05 11:30:15”, “2017-01-05…]
/* INSERT TABLE DATA: wp_users */
INSERT INTO wp_users VALUES(“1”, “cart…]
ERRORS FOUND: 721
TABLES DROPPED: 0
QUERIES RAN: 2207

wp_duplicator_packages: (1)
wp_wfBadLeechers: (0)
wp_wfBlockedIPLog: (34)
wp_wfBlocks: (34)
wp_wfBlocksAdv: (0)
wp_wfConfig: (173)
wp_wfCrawlers: (5)
wp_wfFileMods: (0)
wp_wfHits: (1632)
wp_wfHoover: (0)
wp_wfIssues: (1)
wp_wfKnownFileList: (0)
wp_wfLeechers: (5)
wp_wfLockedOut: (0)
wp_wfLocs: (2)
wp_wfLogins: (274)
wp_wfNet404s: (0)
wp_wfNotifications: (3)
wp_wfPendingIssues: (0)
wp_wfReverseCache: (5)
wp_wfSNIPCache: (1)
wp_wfScanners: (2)
wp_wfStatus: (8)
wp_wfThrottleLog: (0)
wp_wfVulnScanners: (0)

Removed ‘2’ cache/transient rows

CREATE/INSTALL RUNTIME: 0.3139 sec.
STEP-2 COMPLETE @ 12:51:31 – RUNTIME: 0.3262 sec.

********************************************************************************
* DUPLICATOR-LITE: INSTALL-LOG
* STEP-3 START @ 12:51:34
* NOTICE: Do NOT post to public sites or forums
********************************************************************************
CHARSET SERVER: latin1
CHARSET CLIENT: utf8
————————————–
SERIALIZER ENGINE
[*] scan every column
[~] scan only text columns
[^] no searchable columns
————————————–
wp_duplicator_packages^ (0)
wp_wfBadLeechers^ (0)
wp_wfBlockedIPLog~ (34)
wp_wfBlocks~ (34)
wp_wfBlocksAdv^ (0)
wp_wfConfig~ (173)
wp_wfCrawlers~ (5)
wp_wfFileMods^ (0)
wp_wfHits~ (1632)
wp_wfHoover^ (0)
wp_wfIssues~ (1)
wp_wfKnownFileList^ (0)
wp_wfLeechers~ (5)
wp_wfLockedOut^ (0)
wp_wfLocs~ (2)
wp_wfLogins~ (274)
wp_wfNet404s^ (0)
wp_wfNotifications~ (3)
wp_wfPendingIssues^ (0)
wp_wfReverseCache~ (5)
wp_wfSNIPCache~ (1)
wp_wfScanners~ (2)
wp_wfStatus~ (8)
wp_wfThrottleLog^ (0)
wp_wfVulnScanners^ (0)
SCANNED: Tables:25 | Rows:2179 | Cells:28029
UPDATED: Tables:0 | Rows:0 | Cells:0
ERRORS: 0
RUNTIME: 0.157700 sec

====================================
CONFIGURATION FILE UPDATES:
====================================

UPDATED WP-CONFIG: /wp-config.php’ (if present)

WEB SERVER CONFIGURATION FILE BASIC SETUP:
– Preparing .htaccess file with basic setup.
Basic .htaccess file edit complete. If using IIS web.config this process will need to be done manually.

====================================
GENERAL UPDATES & CLEANUP:
====================================

– Created directory wp-snapshots
– Created file wp-snapshots/index.php

====================================
NOTICES
====================================

No Notices Found

STEP 3 COMPLETE @ 12:51:34 – RUNTIME: 0.1616 sec.