ERROR 1010 (HY000): Error dropping database
2015.07.23<br />
<br />
今天想測試把庫中的myism儲存引擎改為InnoDB引擎,庫中的表都是從低版本5.1匯入到現在的高版本5.6。所以想測試一下,把原來所有以myism為引擎的錶轉換過來。<br />
但是在刪除資料庫的時候出現報錯:<br />
<strong></strong><strong>ERROR 1010 (HY000): Error dropping database (can't rmdir './zhanglin</strong><strong>/', errno: 17)</strong><strong></strong><br />
<br />
這個錯誤是,MySQL在刪除資料庫物理檔案的時候,zhanglin庫下面存在MySQL自己不能刪除的檔案<br />
<br />
<div>
<div class="codeheads">
<p>
點選(<span style="cursor:pointer;color:red;" onclick="code_hide('code97')">此處</span>)摺疊或開啟
</p>
</div>
<div id="code97" class="codeText">
<ol style="margin:0 1px 0 0px;padding-left:40px;" start="1" class="dp-css">
<li>
<span style="color:#000000;"><span style="color:#0000CC;">[</span>root<span style="color:#0000FF;">@</span><span style="color:#008080;">master</span> mysql<span style="color:#0000CC;">]</span><span style="color:#0000CC;">#</span> cd zhanglin<span style="color:#0000CC;">/</span><br />
</span>
</li>
<li>
<span style="color:#0000CC;">[</span>root<span style="color:#0000FF;">@</span><span style="color:#008080;">master</span> zhanglin<span style="color:#0000CC;">]</span><span style="color:#0000CC;">#</span> ll<br />
</li>
<li>
total 4<br />
</li>
<li>
-rw-rw----<span style="color:#0000CC;">.</span> 1 mysql mysql 4096 Jul 17 07:41 lxj_r_view_borrow_info<span style="color:#0000CC;">.</span>frm<span style="color:#0000CC;">~</span><br />
</li>
<li>
<span style="color:#0000CC;">[</span>root<span style="color:#0000FF;">@</span><span style="color:#008080;">master</span> zhanglin<span style="color:#0000CC;">]</span><span style="color:#0000CC;">#</span> <span style="color:#E53333;"><strong>rm -rf</strong></span> lxj_r_view_borrow_info<span style="color:#0000CC;">.</span>frm<span style="color:#0000CC;">~</span> <br />
</li>
<li>
<span style="color:#0000CC;">[</span>root<span style="color:#0000FF;">@</span><span style="color:#008080;">master</span> zhanglin<span style="color:#0000CC;">]</span>
</li>
</ol>
</div>
</div>
手動的刪除這個物理檔案之後就可以在MySQL中刪除zhanglin 這個庫<br />
<br />
<div id="codeText" class="codeText">
<ol style="margin:0 1px 0 0;padding:5px 0pt;" start="1" class="dp-css none_number">
<li>
<span style="color:#000000;">mysql> drop database zhanglin;<br />
ERROR 1010 (HY000): Error dropping database (can't rmdir './zhanglin/', errno: 17)<br />
mysql> drop database zhanglin;<br />
Query OK, 0 rows affected (0.00 sec)<br />
<br />
mysql> <br />
</span>
</li>
<li>
<span style="color:#0000CC;"></span><span style="color:#0000CC;"></span><span style="color:#0000CC;"></span><span style="color:#0000FF;"></span><span style="color:#0000CC;"></span><span style="color:#FF00FF;"></span><span style="color:#0000CC;"></span><span style="color:#0000CC;"></span><span style="color:#0000CC;"></span>
</li>
</ol>
</div>
<br />
<br />
<br />
<br />
<br />
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/30936525/viewspace-2016540/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MySQL "ERROR 1010(HY000):Error dropping database(canMySqlErrorDatabase
- ERROR 1010 (HY000) mysql 5.5.19ErrorMySql
- ERROR 2026 (HY000): SSL connection error: unknown error numberError
- ERROR 1524 (HY000): Plugin is not loadedErrorPlugin
- ERROR 1114 (HY000) The table '' is fullError
- MYSQL ERROR 2003 (HY000) CanMySqlError
- 解決ERROR 1030 (HY000): Got error 168 from storage engine apparmorErrorGoAPP
- Dropping a Database (122)Database
- ERROR 1290 (HY000): The MySQL server is running withErrorMySqlServer
- ERROR 1290 (HY000) 解決辦法Error
- database error 12154 at CONDatabaseError
- 網站報錯:“Database Server Error”網站DatabaseServerError
- 【MySQL】ERROR 1878 (HY000): Temporary file write failure.MySqlErrorAI
- Error!: SQLSTATE[HY000] [2002] Connection refusedErrorSQL
- Mysql連線錯誤ERROR 2003 (HY000)MySqlError
- ERROR 1135 (HY000): Can't create a new threadErrorthread
- 【Mysql】ERROR 1872 (HY000): Slave failed to initialize relay log infoMySqlErrorAI
- ERROR 1168 (HY000): Unable to open underlying table which isError
- ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL,ErrorFunctionNoneSQL
- GTID複製報錯處理:Last_Error: Error 'Can't drop database 'test';ASTErrorDatabase
- MySQL ERROR 1031 (HY000) at line 33: Table storage engine forMySqlError
- 35.8.ERROR1819(HY000):YourpassworddoesnotsatisfythecurrentpolicyrequirementsErrorUIREM
- ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default valueError
- ERROR 1661 (HY000): Cannot execute statement: impossible to write to binaryError
- Connect oracle database error in sqlplus: ORA-12560: TNS: protocol adapter errorOracleDatabaseErrorSQLProtocolAPT
- ERROR: failed to establish dependency between database db_name and diskgroupErrorAIDatabase
- Oracle Database on NFS : unable to lock file - already in use" ErrorOracleDatabaseNFSError
- ERROR 1786 (HY000): Statement violates GTID consistency: CREATE TABLE ... SELECTError
- MySQL 使用 show tables 時出現 ERROR 1449 (HY000) 問題MySqlError
- mysql執行sql指令碼報錯ERROR 1366 (HY000) 解決MySql指令碼Error
- super許可權報錯:ERROR1221(HY000):IncorrectusageofDBGRANTandGLOBALPRIVILEGESError
- ERROR2002(HY000):CantconnecttolocalMySQLserverthroughsocket的解決方法ErrorMySqlServer
- ERROR 1031 (HY000): 表引擎沒有這個選項Error
- ERROR 23 (HY000) at line 29963: Out of resources when opening fileError996
- ERROR 1135 (HY000): Can't create a new thread (errno 11)Errorthread
- ERROR 1577 (HY000): Cannot proceed because system tables used by Event ScheduleError
- ERROR 1206 (HY000): The total number of locks exceeds the lock table sizeError
- 【MySQL】ERROR 1005 (HY000): Can't create table' (errno: 150)MySqlError