error while executing sql file (ERROR 1114 mysql table is full)

Question

I'm use MySQL innoDB

I have larg SQL file and and I need to execute this file on my database but when I run the file using this command

mysql -hlocalhost -root -proot mydb< mysql.sql

I got this error

ERROR 1114 mysql table is full

it execute some tables and insert the records to it but when reach to table named feed it insert 2000000 record and return that error

what I can do to solve this error , are there any way to execute this file

`mysql -h localhost -u root -pYour_PASSWORD mydb < mysql.sql` ? Just to be sure you use the right syntax. — kmas, Oct 28 '13 at 15:57
Mr Kmas, yes it execute some tables and insert the records to it but when reach to table name feed it insert 2000000 record and return this error — Osama Jetawe, Oct 28 '13 at 16:00
You have a lot of possibities in the question that you have duplicated. ;) Read it, I think your problem has its solution there. — kmas, Oct 28 '13 at 16:02

score 1 · Answer 1 · edited May 23 '17 at 12:30

If a table-full error occurs, it may be that the disk is full or that the table has reached its maximum size.

There is a set of recommendation how to solve it:

Also, the STATUS will tell us if that copy probably ran out of disk space. For check it, run:

SHOW TABLE STATUS LIKE 'tbl';
SHOW VARIABLES LIKE 'innodb%';

Note that the 32GB you see as free was after the system threw away the failed copy.

Also, similar questions:

1 Answers1