Delete unavailable database host

Community Support Database
1

Hello!

I had a remote mysql database host with a few databases. The server in question is no longer available and I would like to remove the databases and the host itself from my hestiacp instance.

From my understanding and attempts, v-delete-database-host does not let me delete the host because it is “in use”, but also v-delete-database USER DATABASE does not let me delete any of the databases because the connection to the remote host fails (as it is no longer available).

How can I achieve this?

Thanks for all your work and continued support.

2

Delete /usr/local/hestia/conf/mysql.xxx.conf

And manually delete the databases in the db.conf of the user that use them

2 Likes
3

Thank you, this worked wonders.

1 Like
4

Just to add to this, I had to also edit: /usr/local/hestia/conf/mysql.conf.

I realize I could have probably just deleted the entry for the specific host there, but I changed the U_DB_BASES='5' to '0' and then ran v-delete-database-host TYPE HOST and it was finally gone.

5

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.