#!/bin/bash

#!/bin/bash
# sonia 16-nov-05
# backup each mysql db into a different file, rather than one big file
# as with --all-databases - will make restores easier

USER="boticaco_wiki"
PASSWORD="wellkn"
HOST="localhost"

BKDIR="./ISODOC1350"

OPTS="--opt --quote-names "
# get a list of databases
#databases=`mysql --user=$USER --password=$PASSWORD --host=$HOST -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`
databases="boticaco_wikiisov2"
today="`date '+%Y-%m-%d'`"
thisyear="`date '+%Y'`"
thismonth="`date '+%m'`"
thisday="`date '+%d'`"

OUTPUTDIR="$BKDIR"
mkdir -p "$OUTPUTDIR"

echo "Output dir $OUTPUTDIR"

# dump each database in turn
for db in $databases; do
	folder="$OUTPUTDIR/$today_$db"
  [ -d "$folder" ] || mkdir -p "$folder"
  	tables=`mysql --user=$USER --password=$PASSWORD --host=$HOST -NBre "SHOW TABLES;" $db`
  	for table in $tables
  	do
		echo "Tabla: $table" >> "$logfile"
    	# Dump each table into a diferent file
    	mysqldump --user=$USER --password=$PASSWORD --host=$HOST $OPTS $db $table > "$folder/$table.sql"
  	done
done