summaryrefslogtreecommitdiff
path: root/mysql/dump-all-to-homes.sh
diff options
context:
space:
mode:
authorJonas Smedegaard <dr@jones.dk>2017-01-26 14:30:08 +0100
committerJonas Smedegaard <dr@jones.dk>2017-01-26 14:30:08 +0100
commite042b7bced715a9d0d6c660df453b1b68f263316 (patch)
tree13f1bcd2f7cccf87718d92b5fc9a112d4c3ea455 /mysql/dump-all-to-homes.sh
parentc778483fbd7829e2d41157ae6be2d7f1eef709f5 (diff)
Drop ancient unused files.
Diffstat (limited to 'mysql/dump-all-to-homes.sh')
-rwxr-xr-xmysql/dump-all-to-homes.sh45
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