Got a packet bigger than ‘max_allowed_packet

Got a packet bigger than ‘max_allowed_packet

<Date: 2013-07-17> <Author: medcl> <Category: mysql> 查看评论

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> set global  max_allowed_packet=500M
    -> 
    -> ;
ERROR 1232 (42000): Incorrect argument type to variable 'max_allowed_packet'
mysql> set global  max_allowed_packet=500000000
    -> ;
Query OK, 0 rows affected (0.00 sec)
[root@data1 sql-tmp]# mysql -u root -p xx<xx.sql 
Enter password: 
[root@data1 sql-tmp]# 
mysql> quit

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> set global max_allowed_packet=500M

-> ;

ERROR 1232 (42000): Incorrect argument type to variable 'max_allowed_packet'

mysql> set global max_allowed_packet=500000000

-> ;

Query OK, 0 rows affected (0.00 sec)

[root@data1 sql-tmp]# mysql -u root -p xx<xx.sql

Enter password:

[root@data1 sql-tmp]#

mysql> quit

本文来自: Got a packet bigger than ‘max_allowed_packet

mysql

本页面链接地址（或者引用地址 Trackback）

Got a packet bigger than ‘max_allowed_packet

最新文章

广而告之

标签