查看备份数据库文件大小约11GB
[root@msr11 ~]# ll
total 10857420
-rw——-. 1 root root 1048 Jun 12 07:29 anaconda-ks.cfg
-rw-r–r– 1 root root 11049373430 Jun 16 09:47 linuxcache.140616.sql
-rw-r–r–. 1 root root 8526 Jun 12 07:29 install.log
-rw-r–r–. 1 root root 3384 Jun 12 07:28 install.log.syslog
-r–r–r– 1 root root 68592501 Jun 12 08:10 VMwareTools-8.6.11-1310128.tar.gz
drwxr-xr-x 7 201 201 4096 Sep 5 2013 vmware-tools-distrib
[root@msr11 ~]#
执行导入数据库操作是中断并出现错误提示
[root@msr11 ~]# time mysql -u root -pmysqlpass linuxcache <linuxcache.140616.sql
ERROR 1153 (08S01) at line 1557: Got a packet bigger than ‘max_allowed_packet’ bytes
real 0m18.396s
user 0m2.516s
sys 0m0.176s
[root@msr11 ~]#
编辑my.cnf修改设置为大于当前数据库文件大小并重启数据库服务
[root@msr11 mysql]# vi /etc/my.cnf
max_allowed_packet=12G
[root@msr11 ~]# service mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
[root@msr11 ~]#
重新导入数据库文件
[root@msr11 ~]# time mysql -u root -pmysqlpass linuxcache <linuxcache.140616.sql
real 38m7.555s
user 3m33.893s
sys 0m13.377s
[root@msr11 ~]#
处于同步状态的MySQL Slave服务区所产生的错误信息
mysql> show slave status\G;
Slave_IO_Running: No
Slave_SQL_Running: Yes
Last_IO_Error: Got a packet bigger than ‘slave_max_allowed_packet’ bytes
修改配置后数据复制任务不再报错
[root@msr12 mysql]# service mysqld stop
Stopping mysqld: [ OK ]
[root@msr12 mysql]# vi /etc/my.cnf
max_allowed_packet=12G