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,
What is "Maximal length of created query" on phpmyadmin?
Moderator: General Moderators
Re: What is "Maximal length of created query" on phpmyadmin?
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?
This is very helpful to me. Thank you for your response my friend!