diff options
author | Jonas Smedegaard <dr@jones.dk> | 2017-01-26 14:30:08 +0100 |
---|---|---|
committer | Jonas Smedegaard <dr@jones.dk> | 2017-01-26 14:30:08 +0100 |
commit | e042b7bced715a9d0d6c660df453b1b68f263316 (patch) | |
tree | 13f1bcd2f7cccf87718d92b5fc9a112d4c3ea455 /mysql | |
parent | c778483fbd7829e2d41157ae6be2d7f1eef709f5 (diff) |
Drop ancient unused files.
Diffstat (limited to 'mysql')
-rwxr-xr-x | mysql/dump-all-to-homes.sh | 45 |
1 files changed, 0 insertions, 45 deletions
diff --git a/mysql/dump-all-to-homes.sh b/mysql/dump-all-to-homes.sh deleted file mode 100755 index 3021293..0000000 --- a/mysql/dump-all-to-homes.sh +++ /dev/null @@ -1,45 +0,0 @@ -#!/bin/sh -# -# /etc/postgresql/dump-all-to-homes.sh -# Copyright 2003 Jonas Smedegaard <dr@jones.dk> -# -# $Id: dump-all-to-homes.sh,v 1.1 2003-03-05 05:57:01 jonas Exp $ -# -# Dump contents of all local Postgres databases to the homes of those -# with access to them. -# -# TODO: Rewrite to run as each normal user - -if [ -f /root/.my.cnf ]; then - rootpass=$(grep password /root/.my.cnf | awk -F= '{print $2}' | head -1 | sed 's/^ //g') -fi - -users=$(echo "select user from user where host = 'localhost';" | mysql --user=root -p$rootpass mysql | grep -vi '^user$' | sort -u) - -for user in $users; do - getent passwd $user | awk -F: '{print $6}' | grep -q "^/home/$user$" || continue - if [ -d /home/$user ]; then - if [ -d "/home/$user/mysql_dump" ]; then - if [ ! -O "/home/$user/mysql_dump" ]; then - echo "ERROR: Wrong permissions for /home/$user/mysql_dump" - exit 1 - fi - chgrp "$user" "/home/$user/mysql_dump" - else - install -d -o root -g "$user" -m 0750 "/home/$user/mysql_dump" - fi - else - echo "ERROR: Directory /home/$user doesn't exist" - exit 1 - fi - databases=$(echo "select db from db where host = 'localhost' and user = '$user' and select_priv = 'Y';" | mysql --user=root -p$rootpass mysql | grep -vi '^db$' | sed 's/%$//g' | sort -u) - for database in $databases; do - #TODO: Check againt `echo "show databases" | mysql -uroot -p$rootpass | grep -vi '^Database$';` - if [ -f /home/$user/mysql_dump/$database ]; then - mv /home/$user/mysql_dump/$database /home/$user/mysql_dump/$database.bak - fi - mysqldump -c --add-drop-table -uroot -p$rootpass "$database" > "/home/$user/mysql_dump/$database" - chmod 0640 "/home/$user/mysql_dump/$database" - chgrp $user "/home/$user/mysql_dump/$database" - done -done |