As a result of the redo log BLOB
write limit introduced for MySQL 5.6, theinnodb_log_file_size
setting should be 10 times larger than the largest BLOB
data size found in the rows of your tables plus the length of other variable length fields (VARCHAR
,VARBINARY
, and TEXT
type fields). No action is required if your innodb_log_file_size
setting is already sufficiently large or your tables contain no BLOB
data.
SET innodb_strict_mode = 0 ;
CREATE TABLE `history_data` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`coffee` longtext,
.....
$ mysql -uroot -h HOSTNAME DATABASE < ~/path/to/create_script.sql