From 5d9c0b5cdda67ac1672b2e0dd83af7fb67a14a34 Mon Sep 17 00:00:00 2001 From: Enrico Tassi Date: Thu, 16 Jun 2005 09:25:50 +0000 Subject: [PATCH] added utility to dump some tables of the db on mowgli (useful to export metadata to laptops) --- helm/ocaml/metadata/dump_db/dump.sh | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100755 helm/ocaml/metadata/dump_db/dump.sh diff --git a/helm/ocaml/metadata/dump_db/dump.sh b/helm/ocaml/metadata/dump_db/dump.sh new file mode 100755 index 000000000..e7b43666e --- /dev/null +++ b/helm/ocaml/metadata/dump_db/dump.sh @@ -0,0 +1,20 @@ +ALL_TABLES=`../table_creator/table_creator list all` + +if [ -z "$1" ]; then + echo "Dumps to stdout some tables of a given db on mowgli." + echo "If no tables are given the dump will contain:" + echo " $ALL_TABLES" + echo "" + echo "usage: dump.sh dbname [tables...]" + echo "" + exit 1 +fi +DB=$1 +shift +if [ -z "$1" ]; then + TABLES=$ALL_TABLES +else + TABLES=$@ +fi + +mysqldump -e --add-drop-table -u helm -h mowgli.cs.unibo.it $DB $TABLES -- 2.39.2