第25行的错误1030(HY000):来自存储引擎的错误168 [英] ERROR 1030 (HY000) at line 25: Got error 168 from storage engine

问题描述

我正在尝试将sql导入我的数据库.

I'm trying to import sql to my database.

我正在使用Ubuntu OS.

I'm using Ubuntu OS.

这是一个错误:

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.

谢谢您的回答.

推荐答案

我也遇到了此错误，结果发现服务器上的硬盘驱动器已满.

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

我试图截断一个表.我无法通过Web脚本或MySQL Workbench做到这一点.

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.

这篇关于第25行的错误1030(HY000):来自存储引擎的错误168的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！