mysql hy000 1030,第25行的错误1030（HY000）：来自存储引擎的错误168

I'm trying to import sql to my database.

I'm using Ubuntu OS.

Here is an error:

david@david-VirtualBox:~$ mysql -u root -p test_project < db.sql

Enter password:

ERROR 1030 (HY000) at line 25: Got error 168 from storage engine`

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sys |

| testBase |

| test_project |

+--------------------+

6 rows in set (0,05 sec)

mysql> use test_project;

Database changed

mysql> show tables;

Empty set (0,00 sec)

Any ideas how to fix it? I've tried to google this problem, but couldn't find anything useful.

Thank you for your answers.

解决方案

I ran into this error as well and it turned out that the hard disk drive on the server was full.

I was trying to truncate a table. I couldn't do it through the web script or through MySQL Workbench.

After shaking my fist at the server admin I deleted some temporary files, as I had to wait for his availability, and I was then able to perform my truncate.