Re: Too large data problem - error 1153

[Javier Treviño]

Hi Báthory,
Thanks for writing in our forums.

You can google the error the MySQL Server is throwing just so you understand the root cause of it. The packet size rules the size of the data being transferred to the Server. You can try to increase this value if you have access to the Server's configuration, there is also information about how to do that in the official MySQL Server documentation.

However the fact that you are receiving this error is strange. MySQL for Excel measures the data being transferred and checks if it would exceed the max allowed packet value, if it does it splits the SQL query in sub-queries that don't exceed that value. This has been tested, but maybe you have discovered a bug under a specific scenario.

Can you consistently reproduce this? If so, I would advise you to raise a bug report at https:\\bugs.mysql.com with specific steps to duplicate the issue and if possible an zipped .xls file containing the data you are trying to export so we can reproduce the problem easily.

Best regards.

====================================
Javier Treviño
MySQL on Windows Team