Error while importing .sql through command line [duplicate]

Question

Possible Duplicate:
MySQL Error 1153 - Got a packet bigger than ‘max_allowed_packet’ bytes

I have the .sql file which size is 26.3 MB and containing large data.

I am trying to import it via command line by using this command :

mysql -uroot -p dbname < /path/to/file.sql

But it's showing following error while importing

ERROR 1153 (08S01) at line 1: Got a packet bigger than 'max_allowed_packet' bytes

Is it the problem of size or if not then what is the problem?

Thanks

try editing the mysql config file (mysqld.ini i think) and raise the value of max_allowed_paket. The size of the .sql shouldn't be the problem because it's not all loaded at once, but the way it's created. — Matei Suica
– Matei Suica, Commented Oct 12, 2012 at 5:31
see MySQL Error 1153 - Got a packet bigger than 'max_allowed_packet' bytes — Quicksilver
– Quicksilver, Commented Oct 12, 2012 at 5:32

solaimuruganv · Accepted Answer · 2012-10-12 05:36:33Z

3

in mysql prompt, issue these commands:

        set global net_buffer_length=100000000; 
        set global max_allowed_packet=10000000000;

run your command mysql -uroot -p dbname < /path/to/file.sql

in another terminal

answered Oct 12, 2012 at 5:36

solaimuruganv

30.3k1 gold badge22 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Ok..I went through it but still it showing error

please see the duplicate question and make changes in the my.conf file

I made changes in my.cnf max_allowed_packet = 100M now still problem persist and now it also showing warning :

Warning: World-writable config file '/etc/mysql/my.cnf' is ignored  ERROR 1153 (08S01) at line 1: Got a packet bigger than 'max_allowed_packet' bytes

"is ignored" means you effectively have not changed any relevant settings - fix your permissions instead of introducing new problems

have u tried all the solution, specified in the link

|