diff options
author | Jonas Smedegaard <dr@jones.dk> | 2003-11-20 15:15:39 +0000 |
---|---|---|
committer | Jonas Smedegaard <dr@jones.dk> | 2003-11-20 15:15:39 +0000 |
commit | 116a76a3823956842896c85ed170c4eefea92022 (patch) | |
tree | 0d6e5b92137a52a2d5dc2c4cde78a581a2aa2111 /localdumpsql | |
parent | 4f3170eac9bcff92b81f02dd2695da9e80989f63 (diff) |
Avoid --extended-insert (to ease human readability).
Diffstat (limited to 'localdumpsql')
-rwxr-xr-x | localdumpsql | 5 |
1 files changed, 3 insertions, 2 deletions
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 <dr@jones.dk> # -# $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 |