Getting this error while restoring mysql dump.
ERROR 1114 (HY000) at line 1054: The table 'actual problem' is full
Asked
Active
Viewed 66 times
0
Viral Patel
- 32,418
- 18
- 82
- 110
Sanjeev
- 21
- 1
- 7
-
1read this: http://stackoverflow.com/questions/730579/error-1114-hy000-the-table-is-full – Bernd Buffen Jan 11 '16 at 12:21
-
Please provide more details on what you tried and where you are stuck trying to fix this. – Viral Patel Jan 11 '16 at 12:46
1 Answers
-1
server memory can be full so the DB can not write the temp data. To solve it you just have to make some place on your drive. Try this as well: edit config of db:
nano /etc/my.cnf
tmp_table_size=256M max_heap_table_size=256M
restart db
Charanjeet Singh
- 145
- 5