1
1

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 5 years have passed since last update.

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

Posted at

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を再起動すれば完了となります。

1
1
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
1
1

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?