2019-06-28 13:27:25 +00:00
|
|
|
#!/bin/bash
|
2022-03-28 18:06:44 +00:00
|
|
|
|
2019-12-06 15:32:09 +00:00
|
|
|
CONFIG=./setenv
|
|
|
|
|
. $CONFIG
|
2022-03-29 17:18:57 +00:00
|
|
|
. include/functions
|
2019-06-28 13:27:25 +00:00
|
|
|
|
2022-03-28 18:06:44 +00:00
|
|
|
USER=$1
|
2019-06-28 13:27:25 +00:00
|
|
|
|
2022-03-28 21:26:01 +00:00
|
|
|
if [ -z "$1" ]
|
|
|
|
|
then
|
|
|
|
|
echo -e "delete database/s for given username."
|
|
|
|
|
echo -e "usage: $(basename $0) <username>"
|
|
|
|
|
else
|
2022-03-30 17:06:45 +00:00
|
|
|
for DATABASE in $(mysql -u root -sN -e "SELECT Db FROM mysql.db WHERE User='$USER';")
|
|
|
|
|
do
|
|
|
|
|
database_backup
|
|
|
|
|
database_remove
|
|
|
|
|
done
|
|
|
|
|
|
2022-03-28 21:26:01 +00:00
|
|
|
echo "The databases for $USER has been archived, and removed." | sudo mail -s "Database for $USER has been removed" $ADMIN_EMAIL
|
|
|
|
|
fi
|
