MySQL Forums
Forum List  »  MySQL for Excel

Too large data problem - error 1153
Posted by: Báthory István
Date: March 06, 2016 09:56AM


I would like to export around 12.000 rows data into my local MySql server. However shortly I got a message namely:
"Error while inserting rows...MySQL Error 1153: Packets larger than max_allowed_packet are not allowed."

What should I do ?

I've tried to do what were written in the net connect with this issue, about mysql.ini and/or cnf, but I couldn't find any solution so far.

Please help me, because later I have to use much bigger excel table in my job.

Thanks in advance.

Options: ReplyQuote

Written By
Too large data problem - error 1153
March 06, 2016 09:56AM

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.