From 116a76a3823956842896c85ed170c4eefea92022 Mon Sep 17 00:00:00 2001 From: Jonas Smedegaard Date: Thu, 20 Nov 2003 15:15:39 +0000 Subject: Avoid --extended-insert (to ease human readability). --- localdumpsql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'localdumpsql') diff --git a/localdumpsql b/localdumpsql index a38a7a9..bb364fe 100755 --- a/localdumpsql +++ b/localdumpsql @@ -3,7 +3,7 @@ # /usr/local/sbin/localdumpsql # Copyright 2001-2003 Jonas Smedegaard # -# $Id: localdumpsql,v 1.13 2003-06-01 16:38:20 jonas Exp $ +# $Id: localdumpsql,v 1.14 2003-11-20 15:15:39 jonas Exp $ # # MySQL/PostgreSQL maintenance script # @@ -62,7 +62,8 @@ function mysql_users() { if [ -n "$1" ]; then echo "$1"; else mysql -uroot mysq 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"; } #function mysqldump_user_db() { $mysql_bin --opt --user="root" --password="`mysqlpasswd_user root`" "$2"; } -function mysqldump_user_db() { $mysql_bin --opt --user="root" "$2"; } +#function mysqldump_user_db() { $mysql_bin --opt --user="root" "$2"; } +function mysqldump_user_db() { $mysql_bin --add-drop-table --add-locks --all --quick --lock-tables --disable-keys --user="root" "$2"; } # Avoid --extended-insert function postgresvalid() { [ -x $postgres_bin -a -x /usr/lib/postgresql/bin/pg_ctl ]; } function postgres_users() { echo "root"; } #FIXME -- cgit v1.2.3