宝塔用户_fymgif 发表于 2024-8-12 11:43:16

【待反馈】mysql降级

为了能快速了解并处理您的问题，请提供以下基础信息：面板、插件版本：
系统版本：
问题描述：
mysql5.7.44备份文件导入mysql5.6.50版本数据库显示导入失败！
相关截图（日志、错误）：ERROR 1146 (42S02) at line 924: Table ＇yile123471.style＇ doesn＇t existERROR 1064 (42000) at line 934: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ＇json DEFAULT NULL COMMENT ＇配置＇,int(10) unsigned NOT NULL CO＇ at line 15ERROR 1146 (42S02) at line 960: Table ＇yile123471.substation＇ doesn＇t existERROR 1146 (42S02) at line 961: Table ＇yile123471.substation＇ doesn＇t existERROR 1146 (42S02) at line 962: Table ＇yile123471.substation＇ doesn＇t existERROR 1146 (42S02) at line 963: Table ＇yile123471.substation＇ doesn＇t existERROR 1071 (42000) at line 998: Specified key was too long; max key length is 767 bytesERROR 1146 (42S02) at line 1014: Table ＇yile123471.substation_domain＇ doesn＇t existERROR 1146 (42S02) at line 1015: Table ＇yile123471.substation_domain＇ doesn＇t existERROR 1146 (42S02) at line 1016: Table ＇yile123471.substation_domain＇ doesn＇t existERROR 1146 (42S02) at line 1017: Table ＇yile123471.substation_domain＇ doesn＇t existERROR 1064 (42000) at line 1027: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ＇json DEFAULT NULL,int(10) unsigned DEFAULT NULL,PRIMARY KEY ＇ at line 13ERROR 1146 (42S02) at line 1051: Table ＇yile123471.supplier_account＇ doesn＇t existERROR 1146 (42S02) at line 1052: Table ＇yile123471.supplier_account＇ doesn＇t existERROR 1146 (42S02) at line 1053: Table ＇yile123471.supplier_account＇ doesn＇t existERROR 1064 (42000) at line 1063: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ＇json NOT NULL COMMENT ＇任务配置＇,int(11) NOT NULL COMMENT ＇＇ at line 4ERROR 1146 (42S02) at line 1077: Table ＇yile123471.task＇ doesn＇t existERROR 1146 (42S02) at line 1078: Table ＇yile123471.task＇ doesn＇t existERROR 1146 (42S02) at line 1079: Table ＇yile123471.task＇ doesn＇t exist|-导入状态：失败 请根据上述错误信息进行排错|-导入结束时间：2024-08-12 11:39:58|-导入总耗时：0秒=====================================================Database recovery error!

运维技术阿闯 发表于 2024-8-13 10:51:40

您好，这个无法解决，可能版本不用，需要的东西就不同的，降级导入是失败的

宝塔用户_fymgif 发表于 2024-8-23 11:21:47

备份的是MysQL5.7    需要导入My5.6 怎么设置

运维技术阿闯 发表于 2024-8-23 14:19:46

宝塔用户_fymgif 发表于 2024-8-23 11:21
备份的是MysQL5.7    需要导入My5.6 怎么设置

您好，可能是版本之间的不同，应该是无法支持这种操作的
页: [1]
查看完整版本: 【待反馈】mysql降级