vetechno - This must be resolved manually (e.g. by moving the schema directory to another location). in Ubuntu 20.04 LTS

vetechno - This must be resolved manually (e.g. by moving the schema directory to another location). in Ubuntu 

Hello friends, in this tutorial post we will fix an issue which is related to schema directory in MySQL in ubuntu that come's when we are doing something like dropping or creating database and suddenly your database connection goes lost or down due to any reason. And when you check the same database, it does not exist then you think that it is dropped. But at the same time when you create or delete the same database name you will find the below error message. 

Read Also:- How to install and setup Nord VPN on Ubuntu 20.04 LTS

Read Also:- How to Install uTorrent on Ubuntu 18.04 and Ubuntu 20.04 LTS

Read Also:- How to Hide Apache, Nginx, or PHP version on Ubuntu

mysql> drop database  zabbix;
ERROR 3681 (HY000): Schema 'zabbix' does not exist, but schema directory './zabbix/' was found. This must be resolved manually (e.g. by moving the schema directory to another location).

How to Fix - This must be resolved manually (e.g. by moving the schema directory to another location)

First of all exit from your MySQL database. Then go to MySQL directory e.g. /var/lib/mysql/

Step1. In the /var/lib/mysql directory or folder all database related files and folder are created. Now search your database folder name, if it exist then please delete it.

For example:- In this example I'm deleting my zabbix directory.

 This must be resolved manually (e.g. by moving the schema directory to another location).

Step2. Remove the directory

[root@localhost mysql]# rm -rf  zabbix

Step3. Now login to your MySQL Database and create new database with same name. 

Conclusion:

If this post really help you then please leave a comment and let me know if you are facing any issue. Happy troubleshooting !!!!