The solution to the failure of deleting Database in Navicat for MySQL

What if I failed to delete the database in Navicat for MySQL? In fact, it is not difficult to solve this problem, so the editor summarizes this article. Let's take a look at the method of deleting the database in Navicat for MySQL.

problem

Navicat failed to delete this database when it was deleted. The system indicates that an error has occurred. The error code is:

1010-error deleting database (cannot rmdir/testdb, error number: 39)

Solution process

1) find the storage location of the database

Mysql > show variables like'% datadir%'

2) enter the storage location and find

There are still some files under the testdb database that cannot be deleted.

ACT_EVT_LOG.frm ACT_HI_COMMENT.frm ACT_HI_VARINST.frm ACT_PROCDEF_INFO.frm ACT_RU_EXECUTION.frm

Question: there are no uppercase letters in the creation script, but lowercase is specified. We don't know where the problem is and how these tables are generated.

3) Delete all files under the testdb folder to solve the problem

Cd testdb

Rm-rf *

Be careful

For the uppercase letters in 2, you need to pay attention to the configuration items in the my.cnf configuration file

Lower_case_table_names is an attribute parameter description of a case-sensitive setting for mysql:

Lower_case_table_names: this parameter cannot be modified dynamically, and the database must be restarted.

Lower_case_table_names = 1 table names are stored in lowercase on disk, but are case-insensitive when compared

Lower_case_table_names=0 table names are stored as given sizes and comparisons are case-sensitive

Lower_case_table_names=2, the table name is stored in the given case but compared in lowercase

After reading this article, can you solve the problem of database deletion failure in Navicat for MySQL independently? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel. Thank you for reading.