Home > database >  Help Mysql problems arising from the low to high versions migration.
Help Mysql problems arising from the low to high versions migration.

Time:11-22

The original data in 7.5.33, now want to upgrade the database, using Navicat various dump, all kinds of synchronization, and all kinds of failure, and have two days, and don't stay up to help,,
Bosses to help see, the code is as follows:


The CREATE TABLE ` yljk_ecms_infotmp_article ` (
` id ` bigint (20) UNSIGNED NOT NULL AUTO_INCREMENT,
` every ` int (10) UNSIGNED NOT NULL DEFAULT 0,
` oldurl ` varchar (200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ',
` checked ` tinyint (1) NOT NULL DEFAULT 0,
` tmptime ` datetime NOT NULL DEFAULT '0000-00-00 00:00:00,
UNSIGNED ` userid ` mediumint (8) the NOT NULL DEFAULT 0,
` username ` varchar (20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ',
` truetime ` int (10) UNSIGNED NOT NULL DEFAULT 0,
` the rid_device_info_keyboard ` varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ',
` title ` varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ',
` newstime ` datetime NOT NULL DEFAULT '0000-00-00 00:00:00,
` titlepic ` varchar (120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ',
` ftitle ` varchar (120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ',
` smalltext ` varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ',
` writer ` varchar (30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ',
` befrom ` varchar (60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ',
` newstext ` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
` diggtop ` int (11), NOT NULL DEFAULT 0,
PRIMARY KEY (` id `) USING BTREE,
The INDEX ` checked ` (` checked `) USING BTREE,
The INDEX ` every ` (` every `) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=1 CHARACTER SET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=Dynamic;

CodePudding user response:

First, there is no such thing as this version 7.5.33,
Second, there's nothing wrong, you'd post ah,
  • Related