backup-database.sh

#!/bin/bash
host="$1"
user="$2"
database="$3"
output="$4"

if [ -z "$host" ] || [ -z "$user" ] || [ -z "$database" ] || [ -z "$output" ]; then
	echo "Usage: $0 <host> <user> <database> <outputfile>"
	exit
fi

mysqldump -h "$host" -u "$user" -p "$database" > "$output"

backup-tables.sh

#!/bin/bash
host="$1"
user="$2"
database="$3"
table="$4"
output="$5"

if [ -z "$host" ] || [ -z "$user" ] || [ -z "$database" ] || [ -z "$table" ] || [ -z "$output" ]; then
	echo "Usage: $0 <host> <user> <database> <table> <outputfile>"
	exit
fi

mysqldump -h "$host" -u "$user" -p "$database" "$table" > "$output"

generate-password.sh

#!/bin/bash
size="$1"

if [ -z "$size" ]; then
	size=32
fi

dd if=/dev/urandom bs="$size" count=1 | base64