MYSQL_USER="da_admin" MYSQL_PASS="password" BACKUP_DIR=/home/sqlbackup/$(date +%Y-%m-%d_%H-%M-%S); test -d "$BACKUP_DIR" || mkdir -p "$BACKUP_DIR" # Get the database list, exclude information_schema for db in $(mysql -B -s -u $MYSQL_USER --password=$MYSQL_PASS -e 'show databases' | grep -v information_schema | grep -v mysql |grep -v da_roundcube ) do # dump each database in a separate file mysqldump -u $MYSQL_USER --password=$MYSQL_PASS "$db" > "$BACKUP_DIR/$db.sql" done