veyper — 2012-12-25T11:58:32-05:00 — #1
Just started working through php and mysql novice to ninja 5. second chapter, MYSQL i have set up the servers on my computer and so on. go in to PHPmyadmin and try to drop "test" database. when i try i get this error any ideas?
SQL query: Edit
1010 - Error dropping database (can't rmdir '.\ est\', errno: 17)
cups — 2012-12-25T12:08:02-05:00 — #2
A search on this error number turned up this.
If your Mysql version number matches one of those reported, then one of the workarounds might work for you.
veyper — 2012-12-25T12:19:09-05:00 — #3
thanks for the link, had a look and tbh i havent got a clue what it is saying. if you know, could you explain in a way a person not knowing MYSQL too much could unnderstand?
Thanks again for the quick reply
veyper — 2012-12-25T12:22:48-05:00 — #4
heres the suggested fix (taken from cups link) incase anyone else knows?
Remove .empty in mysql_rm_db (sql/sql_db.cc)
Use db.opt as DUMMY_FILE instead of .empty
AND remove .empty on upgrade.
veyper — 2012-12-25T12:39:40-05:00 — #5
managed it, went into directy and deleted .empty file tried to drop it again with phpmyadmin and worked. works a treat.
incase anyone has this problem in future.
/xampp/mysql/data/test and delete .empty
cups — 2012-12-25T16:18:26-05:00 — #6
Good on you for posting the fix and confirming that it works!