Hello James, If this is production be very cautious about touching the base.
This will do the trick: USE cloud; DELETE FROM host WHERE id=12; Best regards, Jordan -----Original Message----- From: James Steele <jsteele.em...@gmail.com> Sent: 03 септември 2021 г. 17:28 To: users@cloudstack.apache.org Subject: Remove host from MySQL? [X] This message came from outside your organization Hi all, We have a host that was removed from the webUI, but it somehow still exists in the cloudstack MySQL database. I wanted to remove the host, reinstall the OS and then re-add back to CS - keeping the same name & IP. What is the MySQL command to remove the existing host entry? Would be something like: use cloud; select * from host; update host set removed=now() where id=12; FYI: this is the same Host 12 mentioned here: https://urldefense.com/v3/__https://github.com/apache/cloudstack/issues/5300__;!!A6UyJA!xxSOzkY4Lt4gw1sCqCER6DHC-Cvdc4dEl_df2vKC_ldCsQl1Mu0jn5iHGzR4VsCR7b_nNb6verIS$ Thanks, Jim