Simple Insert query Question

[mickscool]

Hi Friends,
I have a sql file with a very big insert query.When I try to enter this in mysql prompt it throws error.I dont want to divide it up and then enter,that might cause some human errors.Can somebody please tell me how to automate this.
Thanks

[longneck]

Post The Error!

[mickscool]

Hi,
It doesn't shows me any particular error...but it is so big(2000 records)...that it stops after reachin a certain limit.... I copy it and when i paste it in command prompt it stops midway like this:
This is the query:
INSERT INTO `table_name` VALUES ('xyz','',...........),('abc','',...........)........('zzz','',...........);

I run this at this prompt:
mysql>INSERT INTO `table_name` VALUES ('xyz','',...........),('abc','',...........)........(


and it stops..and i need to press ctrl+c to get out.If I break it into 20 smaller queries it works fine.
Please help friends.
thanks

[longneck]

that's too much for one insert query. you should either do one insert per query, or limit it to a smaller number like 10 or 20.

you MIGHT be able to insert that in one query if you up the max_packer_size server variable.