Skip to content

Instantly share code, notes, and snippets.

@ChatchaiJ

ChatchaiJ/drop-unuse-mysql-database.sh

Created December 8, 2015 06:58
Show Gist options
  • Save ChatchaiJ/657064534cc089b0aa82 to your computer and use it in GitHub Desktop.
Save ChatchaiJ/657064534cc089b0aa82 to your computer and use it in GitHub Desktop.
Download ZIP
Drop unused students' database
Raw
drop-unuse-mysql-database.sh
#!/bin/bash
MYSQLDIR="/var/lib/mysql"
cd $MYSQLDIR
LIST=$( find . -maxdepth 1 -type d -mtime +365 -print |\
sed -e 's/^\.\///' |\
grep ^s4 )
for d in $LIST; do
echo "drop database $d;"
done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment