PC is Intel Core 2 Duo with 4G of RAM. Windows 7 32bit innodb_buffer_pool_size=1G with innodb_buffer_pool_instances=2
I was loading data from CSVs into mysql table using mysql import command. Mysql gave me Table Full Error: 1114 at when my table size was exactly 4G. (Size of .idb file in the ProgramData directory.)
After that error, I am not able to query the able using SELECT command or not even able to use mysqldump on it. When I do so, Mysql57 service stops and I have to restart it. So inshort, I am not able to query my table.
I checked my error log and I got this error message every time, I query the table.
2016-12-23T23:08:40.158223Z 3 [ERROR] InnoDB: Trying to access page number 3 in space 86, space name ccrawlg/ccrawloct16, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. 2016-12-23T23:08:40.161223Z 3 [ERROR] InnoDB: Server exits.
After searching the web, I seemed to me that my database is corrupted and then I tried inndo_force_recovery=1to6 in my my.ini file but unable to do mysqldump and take a backup.
All the above steps happened twice with me as I retried loading all my csvs after first failure.
When I retried, I noticed that the size of idb file was exactly the same as the previous idb file in kbs when i said - Table is full.
My disk doesn't lack in space, there is sufficient space on the disk. It's just that mysqlimport gave table full error at idb size of 4Gs.
My problem is exactly same as this post here :-
`mysqlimport -i --fields-terminated-by="," --lines-terminated-by="\n" -uroot -psomething --local ccrawlg ccrawloct2016 --verbose
Show create table is below
( 'email' varchar(50) NOT NULL, 'source' longtext, `date` varchar(20) DEFAULT NULL, `domain` mediumtext, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
- Link to my.ini file :-
I hope some expert out there could help me get out of this problem. I will provide more info needed.
Thanks in advance,