MariaDB – Troubleshooting Issues with Dropping an Empty Database

mariadb

As the title says, I cannot drop an empty database. In PHPMyAdmin, the request says that it times out and from running it in bash it just goes on until I cancel it with mysqladmin -u root -p kill <pid>. Running use panel; then show tables; just displays Empty set (0.001 sec) What can I do to fix this? Thank you in advance.

Best Answer

If I can remember correctly, I fixed it by setting the innodb_force_recovorey level or I just purged the mariadb package and restored from .sql files

Update

They're saying they've fixed it in VirtualBox 6.0.6!

Innodb – How to drop a corrupted INNODB database in MariaDB

This may not work for everyone, but it did work for us on several occasions:

Stop the database (service mysql stop)
edit mysql.cnf so that under [mysqld] section it has the:
```
[mysqld] 
innodb_force_recovery = 1 
```
Start the database (service mysql start) and in the logfile you will see it force loading the bad database/table
log into the database server as root: mysql -u root
run the command "show databases[ENTER]" to get a list of database
run he command "drop [dbname][ENTER]" where [thedb] is the database you need to drop. It will drop it but will complain that it cannot delete the directory ./[thedb].
Open a separate shell and go into /var/lib/mysql/[thedb]/ and remove the file(s) there.
Stop the database (service mysql stop)
Turn off the REPAIR mode by commenting out the line in mysql.cnf
```
[mysqld]
#innodb_force_recovery = 1 
```
restart the database with the command:
```
service mysql start[ENTER]
```

Voila.

Now recreate the database and restore from your backup.

Thanks, David

Best Answer

Related Solutions

MariaDB – Can’t Init TC Log on CentOS

Update

Innodb – How to drop a corrupted INNODB database in MariaDB

Related Question