MySQL "ERROR 1010(HY000):Error dropping database(can
*** 當database '名字'XX 目錄下存在非資料庫檔案時,使用drop database XX時會報ERROR 1010錯誤,解決方案 刪除非資料庫檔案即可再正常drop database XX;
環境如下
①、建立lottery database及lottery下的表
mysql> create database lottery;
Query OK, 1 row affected (0.00 sec)
mysql> use lottery;
Database changed
mysql> create table t_1 (name varchar(10));
Query OK, 0 rows affected (0.00 sec)
mysql> use lottery;
Database changed
mysql> create table t_1 (name varchar(10));
Query OK, 0 rows affected (0.00 sec)
②、檢視lottery database 目錄下檔案
[root@Wonhigh-Test2 lottery]# ll
-rw-rw----. 1 mysql mysql 54 5月 21 11:25 db.opt
-rw-rw----. 1 mysql mysql 8560 5月 21 11:25 t_1.frm
-rw-rw----. 1 mysql mysql 98304 5月 21 11:25 t_1.ibd
-rw-rw----. 1 mysql mysql 54 5月 21 11:25 db.opt
-rw-rw----. 1 mysql mysql 8560 5月 21 11:25 t_1.frm
-rw-rw----. 1 mysql mysql 98304 5月 21 11:25 t_1.ibd
③、建立一個非資料庫檔案的
[root@Wonhigh-Test2 lottery]# touch aa
④、執行drop database
mysql> drop database lottery;
ERROR 1010 (HY000): Error dropping database (can't rmdir './lottery/', errno: 17)
mysql>
⑤、檢視lottery database 下的內容情況... 發現正常的表 已被刪除,非資料庫檔案aa 還在保留
[root@Wonhigh-Test2 lottery]# ll
-rw-r--r--. 1 root root 0 5月 21 11:27 aa
-rw-r--r--. 1 root root 0 5月 21 11:27 aa
⑥、刪除非資料庫檔案aa
[root@Wonhigh-Test2 lottery]# rm -rf aa
⑦、再次執行drop database --OK
mysql> drop database lottery;
Query OK, 0 rows affected (0.00 sec)
mysql>
Query OK, 0 rows affected (0.00 sec)
mysql>
【源於本人筆記】 若有書寫錯誤,表達錯誤,請指正...
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28602568/viewspace-1665786/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ERROR 1010 (HY000): Error dropping databaseErrorDatabase
- ERROR 1010 (HY000) mysql 5.5.19ErrorMySql
- MYSQL ERROR 2003 (HY000) CanMySqlError
- 【MySQL】ERROR 1005 (HY000): Can't create table' (errno: 150)MySqlError
- MySQL報錯'ERROR 2002 (HY000): Can't connect to local MySQL server through'MySqlErrorServer
- ERROR 2002(HY000):Can't connect to local MySQL socket '/tmp/mysql.sock'ErrorMySql
- 【MySQL】ERROR 1093 You canMySqlError
- ERROR 1135 (HY000): Can't create a new threadErrorthread
- ERROR 2002 (HY000): Can't connect server socket /tmp/mysql.sockErrorServerMySql
- [ERROR] Can't open the mysql.plugin tableErrorMySqlPlugin
- MySQL 5.7向表匯入資料包錯"ERROR 13 (HY000): Can't get stat of"MySqlError
- ERROR 2003 (HY000)Can't connect to MySQL server on '192.168.8.247' (113)ErrorMySqlServer
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)ErrorMySqlServerlocalhost
- GTID複製報錯處理:Last_Error: Error 'Can't drop database 'test';ASTErrorDatabase
- ERROR 1135 (HY000): Can't create a new thread (errno 11)Errorthread
- mysql [ERROR] Can't create IP socket: Permission deniedMySqlError
- ERROR 1290 (HY000): The MySQL server is running withErrorMySqlServer
- ERROR 2026 (HY000): SSL connection error: unknown error numberError
- error:'Can'tconnecttolocalMySQLserverthroughsocket'/var/lib/mysql/mysql.sock'(2)'ErrorMySqlServer
- 【MySQL】ERROR 1878 (HY000): Temporary file write failure.MySqlErrorAI
- ERROR 1005 (HY000): Can't create table 'starive.SC' (errno: 150)"Error
- Mysql報錯Fatal error:Can't open and lock privilege tablesMySqlError
- mysql can't connect error about privilege----not root userMySqlError
- Mysql連線錯誤ERROR 2003 (HY000)MySqlError
- 【Mysql】ERROR 1872 (HY000): Slave failed to initialize relay log infoMySqlErrorAI
- ERROR 1005 (HY000): Can't create table'matrix.system_log' (errno: 150)Error
- ERROR in Entry module not found Error Can't resolve 'babel' in ' UseErrorBabel
- ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAError
- MySQL ERROR 1031 (HY000) at line 33: Table storage engine forMySqlError
- Error: The action can not be performed because ...could not be locked?ErrorORM
- ERROR 1524 (HY000): Plugin is not loadedErrorPlugin
- ERROR 2002 (HY000): Can't connect server socket /var/run/mysqld/mysqld.sockErrorServerMySql
- MySQL 5.5 原始碼安裝報錯"[ERROR] Can't start server"MySql原始碼ErrorServer
- MySQL 使用 show tables 時出現 ERROR 1449 (HY000) 問題MySqlError
- mysql執行sql指令碼報錯ERROR 1366 (HY000) 解決MySql指令碼Error
- [筆記].痛哉!!!Error: Can't access JTAG chain, Error: Operation failed筆記ErrorAI
- linux下連線mysql報錯ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysqLinuxMySqlErrorServer
- wireshark error: There are no interfaces on which a capture can be done.ErrorAPT