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