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.
1 Answer
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
Jul 24, 2013: Moving MySql from windows server to linux (StackOverflow)Apr 17, 2011: How can I optimize a mysqldump of a large database?
answered Jul 29, 2013 at 1:33
-
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 ?– biz14Commented Jul 29, 2013 at 12:41
SHOW GLOBAL VARIABLES LIKE 'basedir';return? Is there a file called 'my.cnf' in that directory?