We have windows xp machine with older version of mysql. So when we need to import huge data we just set the max_allowed_packet=1500M in the C:\Program Files\MySQL\MySQL Server 5.1 . Now we loaded the latest mysql 5.6.12. We are trying to import the same date and we find there are few my.cnf file on is in the program file and another in programme data both change yet we cant import the same data. Where else to change even after the change we started the service by going into the admistrative tool.

  • What does SHOW GLOBAL VARIABLES LIKE 'basedir'; return? Is there a file called 'my.cnf' in that directory? – Michael - sqlbot Jul 28 '13 at 17:36
  • @It says this C:\Program Files\MySQL\MySQL Server 5.6\ and here is a filed named as my-default and in it also I have put infact max_allowed_packet=2000M but yet it does not work. – biz14 Jul 28 '13 at 17:57

The maximum size for a MySQL Packet is 1G according to the MySQL Documentation. See my post Changed max_allowed_packet and still receiving 'Packet Too Large' error in case you are dealing with big BLOBs.

If you are importing a large database from Windows. see my past posts

  • what surprise me it works well on windows xp but on not on windows 7 another thing the file in this location C:\Program Files\MySQL\MySQL Server 5.6\ is my-default do you think I should change it to my.cnf? My file is pure text data no blob and is very basic data just with few hundred thousand rows. Is it because I am using sqlyog to import in the data ? – biz14 Jul 29 '13 at 12:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.