1 Answer
- Newest
- Most votes
- Most comments
0
This error code means mainly the directory is not empty. If you just want to drop the database no matter what you can follow the below steps.
- find the datadir with the command SHOW VARIABLES WHERE Variable_name LIKE '%datadir%';
- stop the MySQL server (e.g. service mysql stop or rcmysqld stop or similar on Linux, NET STOP <name of MYSQL service, often MYSQL57 or similar> or
through SERVICES.MSC on Windows) - go to the datadir (this is where you should investigate; see below)
- remove the directory with the same name as the database
- start MySQL server again and connect to it
- execute a DROP DATABASE
Errno 39 This code means "directory not empty". The directory contains some hidden files MySQL knows nothing about. For non-hidden files, see Errno 17.
Errno 17 This code means "file exists". The directory contains some MySQL file that MySQL doesn't feel about deleting. Such files could have been created by a SELECT ... INTO OUTFILE "filename"; command where filename had no path. In this case, the MySQL process creates them in its current working directory,
answered 21 days ago
Relevant content
- AWS OFFICIALUpdated 5 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
In rds we don't have access to the file system