导入表出现这个错误mysql> source e:\11.sql;
ERROR:
Unknown command '\1'.
ERROR 1050 (42S01): Table 'dede_addonarticle' already exists
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 220
Current database: sq_hongqi1-408ERROR 1153 (08S01): Got a packet bigger than 'max_allowed_packet' bytes
mysql> source e:\11.sql;
ERROR:
Unknown command '\1'.
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 231
Current database: sq_hongqi1-408Query OK, 0 rows affected (0.44 sec)ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 232
Current database: sq_hongqi1-408ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 233
Current database: sq_hongqi1-408ERROR 2006 (HY000): MySQL server has gone away
ERROR:
Unknown command '\1'.
ERROR 1050 (42S01): Table 'dede_addonarticle' already exists
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 220
Current database: sq_hongqi1-408ERROR 1153 (08S01): Got a packet bigger than 'max_allowed_packet' bytes
mysql> source e:\11.sql;
ERROR:
Unknown command '\1'.
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 231
Current database: sq_hongqi1-408Query OK, 0 rows affected (0.44 sec)ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 232
Current database: sq_hongqi1-408ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 233
Current database: sq_hongqi1-408ERROR 2006 (HY000): MySQL server has gone away
解决方案 »
- 求差集语句
- 项目中用到很多sql语句,怎么存储比较好?
- 关于使用外键关联表的删除,更新问题
- 可以用powerdesigner开发mysql数据库吗,谢谢!
- 高分求MYSQL查询语句一条
- mysql的procedure里面,查询语句放在V_SQL变量里面 怎么去执行它,看它返回多少行?
- 求助关于MYSQL导出多个库问题。
- postgresql中有沒有語句修改表字段的數據類型?
- mysql默认字符集设置错了,已经创建的库 怎么修改为自己想要的字符集?
- 关于Mysql中left join优化的问题,求指点
- csv 数据导入到mysql 什么工具简单好用,就是比较傻瓜的工具啦
- grant命令不能使用变量怎么办?
在MY。INI(CNF)中将max_allowed_packet设置大一点
[mysqld]
max_allowed_packet = 100M
11.sql内容 是一个表'dede_addonarticle'的数据
mysql> source e:/11.sql;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 240
Current database: sq_hongqi1-408ERROR 1050 (42S01): Table 'dede_addonarticle' already exists
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 241
Current database: sq_hongqi1-408ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 242
Current database: sq_hongqi1-408ERROR 2006 (HY000): MySQL server has gone away
-- phpMyAdmin SQL Dump
-- version 2.6.4-pl4
-- http://www.phpmyadmin.net
--
-- 主机: 210.209.123.181
-- 生成日期: 2013 年 05 月 14 日 14:24
-- 服务器版本: 5.0.95
-- PHP 版本: 5.2.6
--
-- 数据库: `sq_hongqi1`
-- -- ----------------------------------------------------------
-- 表的结构 `dede_addonarticle`
-- CREATE TABLE `dede_addonarticle` (
`aid` mediumint(8) unsigned NOT NULL default '0',
`typeid` smallint(5) unsigned NOT NULL default '0',
`body` mediumtext,
`redirecturl` varchar(255) NOT NULL default '',
`templet` varchar(30) NOT NULL default '',
`userip` char(15) NOT NULL default '',
PRIMARY KEY (`aid`),
KEY `typeid` (`typeid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;--
-- 导出表中的数据 `dede_addonarticle`
--
下面就是一堆insert,不过都是乱码
INSERT INTO `dede_addonarticle` (`aid`, `typeid`, `body`, `redirecturl`, `templet`, `userip`) VALUES (1, 1, '<div>\r\n <img alt="" src="/uploads/allimg/130228/18-13022Q32441F6.jpg" style="width: 660px; height: 395px" /></div>\r\n<div>\r\n <br />\r\n ???????????????2011?8?1?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????“?????????????”?????????????????????????????????????????<br />\r\n ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????<br />\r\n </div>\r\n', '', '', '116.231.3.224'),
(2, 1, '<div class="about_title_3">\r\n <p style="margin-left: 24.1pt; line-height: 30px">\r\n <font class="about_title_4"><strong><span style="font-size: 14px">????——???????????</span></strong></font></p>\r\n <p style="margin-left: 24.1pt; line-height: 30px">\r\n <font class="about_title_4"><span style="font-size: 14px">????????????????????????????????????
http://zhidao.baidu.com/question/490522210.html
mysql> DROP TABLE `dede_addonarticle`;
Query OK, 0 rows affected (0.00 sec)mysql> source e:/11.sql;
Query OK, 0 rows affected (0.06 sec)ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 2
Current database: sq_hongqi1-408ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 3
Current database: sq_hongqi1-408ERROR 2006 (HY000): MySQL server has gone away第一句 创建表是成功的,下面就开始出错了,估计还是insert 乱码问题
那么source之前 先执行下set names gbk;
应该是其中有一个大量数据 insert into ...的语句,执行时间超时。
CSDN附件审核太慢http://163.fm/Iiy9pQ0
提取码:f9dUOqQl