summaryrefslogtreecommitdiff
path: root/localdumpsql
diff options
context:
space:
mode:
authorJonas Smedegaard <dr@jones.dk>2006-07-16 12:33:59 +0000
committerJonas Smedegaard <dr@jones.dk>2006-07-16 12:33:59 +0000
commit78d646b8b6ad3ff09d3ef6539b4533a8e84c0fcc (patch)
treec67beb1ee70f8fb91ac26fd64def08e0b6595130 /localdumpsql
parent4dce2f2db4252fb55dce4b1e2dd99eb89294f91a (diff)
Change head -1 -> head -n 1
Diffstat (limited to 'localdumpsql')
-rwxr-xr-xlocaldumpsql6
1 files changed, 3 insertions, 3 deletions
diff --git a/localdumpsql b/localdumpsql
index a6dabe4..45182af 100755
--- a/localdumpsql
+++ b/localdumpsql
@@ -1,9 +1,9 @@
#!/bin/bash
#
# /usr/local/sbin/localdumpsql
-# Copyright 2001-2003 Jonas Smedegaard <dr@jones.dk>
+# Copyright 2001-2006 Jonas Smedegaard <dr@jones.dk>
#
-# $Id: localdumpsql,v 1.15 2005-12-11 21:05:09 jonas Exp $
+# $Id: localdumpsql,v 1.16 2006-07-16 12:34:00 jonas Exp $
#
# MySQL/PostgreSQL maintenance script
#
@@ -57,7 +57,7 @@ function gethome_user() { getent passwd "$1" | awk -F: '{print $6}' | head -n 1
function getbackupdir_user() { echo "`gethome_user \"$1\"`/backup"; }
function mysqlvalid() { [ -x $mysql_bin ]; }
-#function mysqlpasswd_user() { grep password "`gethome_user $1`"/.my.cnf | awk -F= '{print $2}' | awk '{print $1}' | head -1; }
+#function mysqlpasswd_user() { grep password "`gethome_user $1`"/.my.cnf | awk -F= '{print $2}' | awk '{print $1}' | head -n 1; }
function mysql_users() { if [ -n "$1" ]; then echo "$1"; else mysql -uroot mysql -e "select User from user;" | grep -Ev '^(User|debian-sys-maint|root|.+-admin)$' | sort -u; fi; }
function mysql_db_user() { if [ -n "$1" ]; then echo "$1"; else mysql -u root mysql -re "select Db from db where User='$2';" | grep -v '^Db$' | sort -u; fi; }
#function mysqldump_user_db() { $mysql_bin --opt --user="$1" --password="`mysqlpasswd_user $1`" "$2"; }