When I try to upload a file to a table from my mysql database the system returns the error Table is Full. However, I have other tables that are larger and heavier than this table that do not have this error. The error table has approximately 300MB. I already set the variable innodb_file_per_table = 1
But I was not able to set innodb_data_file_path
in my.cnf
because every time I hit the variable mysql service did not start, although I only add the lines:
[mysqld]
innodb_data_file_path = 'ibdata1:10G:autoextend'
I've tried this other method presented here with ALTER TABLE but it did not work either. I checked the disk space with the df -h
command, and all partitions have plenty of free space. I do not know what it could be anymore.
Adding the code mentioned in Raylan's comment resulted in a mysql startup error, so I fixed my my.cnf
to:
[innodb]
innodb_data_file_path = ibdata1:10G:autoextend:max:10G
And yet the Table is full error persists.
Typing the code mysql
on the server appears unknown variable 'innodb_data_file_path=ibdata1:10G:autoextend:max:10G'
In another attempt I made a DROP TABLE and even now with the empty table the error continues. I do not know where else to go.
The command to create the table was:
CREATE TABLE auxiliar_MA.HT_MA4_SBX_SEG
(
TS_SAMPLETM DATETIME
, VL_M4000109 DOUBLE
, VL_M4000110 DOUBLE
, VL_M4000111 DOUBLE
...
, VL_M4000669 DOUBLE
, VL_M4000674 DOUBLE
, VL_M4000675 DOUBLE
, VL_M4000676 DOUBLE
)
;
Thank you in advance.