Remove Databases (MySQL/PostgreSQL/Redis/Memcached)

By brianjorden // 7 years ago

Clone

We are hosting our database server separately from the box that serves up the PHP side of things. The latest version of MySQL pulls a huge amount of RAM and did some other likely overkill cleanup at the same time. Maybe it is just me, but I like dedicated VMs for single purpose so you can drop/recreate/resize them without thinking about anything besides the single purpose of what it is doing. Please ping me @brian_jorden on twitter if you see any issues with this as this site doesn't seem to notify me about comments.

service mysql stop
service mysqld stop
service postgresql stop
service redis-server stop
service memcached stop

killall -9 mysql
killall -9 mysqld
killall -9 postgresql
killall -9 redis-server
killall -9 memcached

apt-get -y purge mysql*
apt-get -y purge postgresql*
apt-get -y purge redis*
apt-get -y purge memcached*

apt-get -y autoremove
apt-get -y autoclean

rm -rf /var/lib/mysql
rm -rf /var/lib/postgresql
rm -rf /var/lib/redis
rm -rf /var/lib/memcached

rm -rf /var/log/mysql
rm -rf /var/log/postgresql
rm -rf /var/log/redis
rm -rf /var/log/memcached

rm -rf /etc/mysql
rm -rf /etc/postgresql
rm -rf /etc/redis
rm -rf /etc/memcached

deluser mysql
deluser mysqld
deluser postgresql
deluser postgres
deluser postgre
deluser redis
deluser redis-server
deluser memcached
deluser memcache

groupdel mysql
groupdel mysqld
groupdel postgresql
groupdel postgres
groupdel postgre
groupdel redis
groupdel redis-server
groupdel memcached
groupdel memcache

apt-get -y update
apt-get -y upgrade

reboot

Site maintained by Vince Mitchell.

Inspired by original by David Hemphill, Tanner Hearne, & Matt Stauffer.