Qiita Teams that are logged in
You are not logged in to any team
Log in to Qiita Team
Community
OrganizationAdvent CalendarQiitadon (β)
Service
Qiita JobsQiita ZineQiita Blog
SignupLogin
法人向けインターネット接続サービス『NUROアクセス』の導入メリット詳しくはこちら
Hiromitsu_Iwata@Hiromitsu_Iwata
Improve article
Send edit request
Improve article
RevisionsEdit RequestsShow all likersShow article in Markdown
Report article
Help us understand the problem. What is going on with this article?

MySQLのバルクインサートを実行したときのエラー対処法

MySQLSQL
More than 5 years have passed since last update.

MySQLでバルクインサートを実行したときのエラー対処法

こんなエラーが出てしまった・・・

Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet' bytes

SQL文のデータ？がmax_allowed_packetの値を超えてしまった場合に出るエラーのようです。
/etc/my.cnfのmax_allowed_packetのサイズを増やしましょう。

/etc/my.cnf
max_allowed_packet=8M

編集したら、MySQLを再起動すれば完了となります。

Edit request
1
Hiromitsu_Iwata
@Hiromitsu_Iwata
Why not register and get more from Qiita?
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away