Error 1114 (HY000) in MySQL: The table is full

Question

Error 1114 (HY000) in MySQL: The table is full

Navigation

#1 by (1 votes)

2

I've exported a MySQL-sized 14GB database from a Windows OS computer and want to import it into MySQL from a computer running Ubuntu 14.04 OS

I used the following command to export the "data" database:

mysqldump -u root -p dados > teste.sql

After exporting I tried to import the same one into MySQL from the Ubuntu 14.04 OS using:

mysql -u root -p dados < teste.sql.

After a few minutes of execution the following error appears:

ERROR 1114 (HY000): The table "XXXXXXX" is full

How do you overcome this error?

mysql

asked by anonymous 24.09.2015 / 02:18

1 answer

PivotTable How to implement the jQuery Filer Plugin?

score 1 · Accepted Answer

I imagine you are using InnoDB so check out the available disk space for / usr which is the partition where the base of mysql is usually. If the space is not sufficient to import, the location where it saves these tables might be best (ibdata1, ibdata2)

Search for: innodb_data_file_path