Page 1 of 1

What is "Maximal length of created query" on phpmyadmin?

Posted: Tue Jun 15, 2010 2:18 am
by pjcvijay
Hi All,
When I export my database using phpmyadmin, it shows "Maximal length of created query" option. What does it mean?
Any idea my dear friends?

Thanks in advance,

Re: What is "Maximal length of created query" on phpmyadmin?

Posted: Tue Jun 15, 2010 2:42 am
by Eran
When exporting data in phpMyAdmin, it prepares single insert operations with multiple values. Depending on the number of records in a table, this query could be very long. If the physical size of the query exceeds the max_allowed_packet parameter in MySQL, the query would break. For this purpose, phpMyAdmin gives you the option to limit the size of individual queries, splitting long insert queries into several smaller ones.

Re: What is "Maximal length of created query" on phpmyadmin?

Posted: Tue Jun 15, 2010 3:59 am
by pjcvijay
This is very helpful to me. Thank you for your response my friend!