Error while importing .sql through command line

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, Oct 12 '12 at 05:31
see [MySQL Error 1153 - Got a packet bigger than 'max_allowed_packet' bytes](http://stackoverflow.com/questions/93128/mysql-error-1153-got-a-packet-bigger-than-max-allowed-packet-bytes) — Quicksilver, Oct 12 '12 at 05:32

score 3 · Accepted Answer · answered Oct 12 '12 at 05:36

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 '12 at 05:36

solaimuruganv

Ok..I went through it but still it showing error – J.K.A. Oct 12 '12 at 05:38
please see the duplicate question and make changes in the `my.conf` file – Quicksilver Oct 12 '12 at 05:39
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` – J.K.A. Oct 12 '12 at 05:55
1

"is ignored" means you effectively have not changed any relevant settings - fix your permissions instead of introducing new problems – AD7six Oct 12 '12 at 06:04
have u tried all the solution, specified in the link – solaimuruganv Oct 12 '12 at 06:08
use the following command to change file’s permissions " chmod 644 /etc/mysql/my.cnf " – solaimuruganv Oct 12 '12 at 06:15
don't forget restart mysql service after making the changes in conf – Quicksilver Oct 12 '12 at 06:21
@KhaleelAKarim : Thanks Its working now – J.K.A. Oct 12 '12 at 06:26

1 Answers1