MySQL Error :1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists
Posted on :
Mon, 12th Oct 15 01:41 pm (Updated on :
Mon, 12th Oct 15 01:41 pm) GMTAuthor : Code2care
- Error No. : #1008
- Error Type : Server Error
- Error Code : SSQLSTATE: HY000 (ER_DB_DROP_EXISTS)
- Error Message : Can't drop database '%s'; database doesn't exist Server Error
This is again a very Trivial MySQL error. The Server returns error code 1008 i.e. ER_DB_DROP_EXISTS when you try to execute a DROP Command to delete a database that does not exists.
drop database mydb
MySQL said: Documentation
#1008 - Can't drop database 'mydb'; database doesn't exist
MySQL Error : #1008
If you have a script that contains DROP command check if its getting executed twice or the database really exists.
We are operating with limited resources due to COVID-19 - Stay Safe!
We stands in support of racial equality!
Follow us : Facebook