0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

MySQLでインポート時に「1118 Row size too large (> 8126)」エラー

Posted at

エラーメッセージ

1118 Row size too large (> 8126). 
Changing some columns to TEXT or BLOB may help. In current row format, 
BLOB prefix of 0 bytes is stored inline.

my.ini が修正できる場合

以下のパラメタを追加する

innodb_strict_mode=0

RDS(AWS)などで、修正出来ない場合

インポートするダンプファイルのヘッダに以下を追加する

/*!50001 SET innodb_strict_mode      = 'off' */;
0
0
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
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?