Error by Restoring data with mysql command line !

i hava a reseller account and can access mysql with ssh/shell.

When i try to dump it into my database by SSH

mysql -u myname -p mydatabase < mydump.sql

my file mydump.sql is ~ 12 MB.

i getting an error massege :
"ERROR 1153 at line 1941: Got a packet bigger than 'max_allowed_packet'"

so i checked the status and i showed max_allowed_packet = 1 M !!!

how can i restore my database on command line (SSH) with sql file bigger than 1 MB (without changes in my.cnf !) ???

i have tried:
mysql --max_allowed_packet=16000000 -u myname -p mydatabase < mydump.sql

but it didnt work.

do anyone have a hint for me ?

thnx.

 

 

 

 

Top