diff options
author | Jonas Smedegaard <dr@jones.dk> | 2006-07-16 12:33:59 +0000 |
---|---|---|
committer | Jonas Smedegaard <dr@jones.dk> | 2006-07-16 12:33:59 +0000 |
commit | 78d646b8b6ad3ff09d3ef6539b4533a8e84c0fcc (patch) | |
tree | c67beb1ee70f8fb91ac26fd64def08e0b6595130 /localdumpsql | |
parent | 4dce2f2db4252fb55dce4b1e2dd99eb89294f91a (diff) |
Change head -1 -> head -n 1
Diffstat (limited to 'localdumpsql')
-rwxr-xr-x | localdumpsql | 6 |
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"; } |