table is corrupted after getting 1114 error : table is full 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.


Edit:-


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 :-
https://stackoverflow.com/questions/38245974/mysql-server-crashes-innodb-outside-the-tablespace-bounds
Import statement:-
`mysqlimport -i --fields-terminated-by="," --lines-terminated-by="\n" -uroot -psomething --local ccrawlg ccrawloct2016 --verbose
Show create table is below


CREATE TABLE ccrawloct2016

(
  '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 :-
https://drive.google.com/file/d/0BztaImknhgDFWUFsdEE2MXFxWDA/view?usp=sharing


I hope some expert out there could help me get out of this problem. I will provide more info needed.

Thanks in advance,
DROP the table.
Re-import, but make sure the table is MyISAM, not InnoDB.


Now you can at least see if the data is bad.  And you can experiment with INSERT INTO inno_table SELECT * FROM myisam_table.  There is a chance (slim chance) that CSV is the problem.  MyISAM is more compact on disk, so a larger file can be loaded before hitting 4GB (in the .MYD file).

Another thought...  Did you have indexes (other than the PRIMARY KEY)?  Try loading without the indexes in place.

Was the data in PK order?  That will make the loading faster and more efficient and take less space.  Can you sort the CSV before importing?

Generally, loading with the PK in place is best for InnoDB.  Please provide the CREATE TABLE so we know what you are working with.

Another thing to try:  Use the mysql commandline tool; within it, use the LOAD DATA command.  (I don't hold out much hope for this because I would assume that mysqlimport uses the same command.)

Yet another:

Break the source file into multiple pieces (each under, say, 1GB).  Import them into different tables.  Then use SQL statements to put them together.  And get rid of the intermediate tables.