Got a packet bigger than ‘max_allowed_packet

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

Medcl