mysql drop database which exists with same name

Question

I have got a weird state in my mysql/ mariadb server.

When I execute show databases; it gets following result:

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| MYDATABASENAME         |
| mydatabasename         |

And when I execute drop database MYDATABASENAME; then the database mydatabasename lowercase one gets dropped and not the uppercase one. If I then execute the drop database MYDATABASENAME; again it says

ERROR 1008 (HY000): Can't drop database 'mydatabasename'; database doesn't exist

UPDATE

In my.cnf I had set lower_case_table_names=1 which caused the mysql server to handle all tables/ databases in lower case format. See my answer below.

My question is now, how can I drop the uppercase database "MYDATABASENAME"?

Try a case sensitive collaction in your drop command

juergen d
– juergen d

2018-02-22 09:49:18 +00:00
Commented Feb 22, 2018 at 9:49 — juergen d
– juergen d, Commented Feb 22, 2018 at 9:49

mrkernelpanic · Accepted Answer · 2018-02-22 09:59:32Z

2

If you have set lower_case_table_names=1 in your my.cnf then mysql handles/ stores all tables and databases in lower case format. So disabling the property, then executing the drop command again fixed the problem.

answered Feb 22, 2018 at 9:59

mrkernelpanic

4,4916 gold badges30 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rick James · Accepted Answer · 2018-03-04 20:41:17Z

0

It is best not to try to override the OS-based default value for lower_case_table_names.

MySQL/MariaDB depend on file and directory names based on table and database names. But Windows ignores case; *nix does not.

answered Mar 4, 2018 at 20:41

Rick James

144k15 gold badges144 silver badges255 bronze badges

Collectives™ on Stack Overflow

mysql drop database which exists with same name

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related