MySQL Forums
Forum List  »  MySQL for Excel

Re: Too large data problem - error 1153
Posted by: Javier Treviño
Date: March 08, 2016 05:10PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Too large data problem - error 1153
1175
March 08, 2016 05:10PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.