Mysql Error 1273 when moving DB from dev to live server

by nizz0k   Last Updated December 19, 2016 08:04 AM

So, I recently updated to version 3.6.5. I initially tested the update on a test server before moving the update to my live server. The issue I'm running into is Mysql 1273 Error

CREATE TABLE `zyjgk_assets` (
`id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
`parent_id` int( 11 ) NOT NULL DEFAULT '0' COMMENT 'Nested set parent.',
`lft` int( 11 ) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.',
`rgt` int( 11 ) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.',
`level` int( 10 ) unsigned NOT NULL COMMENT 'The cached level in the nested tree.',
`name` varchar( 50 ) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The unique name for the asset.\n',
`title` varchar( 100 ) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The descriptive title for the asset.',
`rules` varchar( 5120 ) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON encoded access control.',
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `idx_asset_name` ( `name` ) ,
KEY `idx_lft_rgt` ( `lft` , `rgt` ) ,
KEY `idx_parent_id` ( `parent_id` )
) ENGINE = MYISAM AUTO_INCREMENT =362 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

Googling around suggests that there is some sort incompatibility between the Mysql versions on the test and live servers, so how do I proceed from here and fix this?



Related Questions


How to update the latest row in MySQL table

Updated April 30, 2015 21:04 PM

Fix database after failed update

Updated December 16, 2016 08:04 AM

Database errors after moving remote db to local host

Updated December 18, 2016 08:04 AM


Connection to database timingout

Updated June 18, 2015 23:04 PM