Thread: Query too long

I splitted the SQL statement and then got "max execution time exceeded" error. So I then splitted in into multiple SQL files. And I also had to use TypePad in order to be able to handle editing the large text file. But it finally worked. Thanks.

when you have a long series of values... Code: INSERT INTO sometable (column, column, column, ... ) VALUES ( value, value, value, ... ) , ( value, value, value, ... ) , ( value, value, value, ... ) , ( value, value, value, ... ) , ( value, value, value, ... ) , ( value, value, value, ... ) , ( value, value, value, ... ) , ( value, value, value, ... ) , ... you can easily break it up just by adding a new INSERT line as often as you wish -- say,...

It's more effective to use mysql command line for import which can handle GB of data with ease. In case of phpMyAdmin you should increase the max post upload size & maximum execution time for handling large data.