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

Question

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.

Answer 1

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.