This code backups up mysql databases and gzips them into the current working directory. If you want to backup the mysql table, remove it from the for loop.
#!/bin/bash
usage(){
echo "Usage $0 <mysql_user> <mysql_password>"
exit 1
}
if [[ "$2" != "" && "$2" == "" ]]
then
usage
fi
USER=$1
PASS=$2
if [ "$3" != "" ]
then
DB_HOST=$3
else
DB_HOST="localhost"
fi
for db in `mysql -u$USER -p$PASS -h$DB_HOST -e 'show databases' | cut -f2 | awk '{ print $1 }' | grep -v "Database\|mysql\|information_schema\|test"`;
do
echo "Working with $db"
mysqldump -u$USER -p$PASS -h$DB_HOST $db > $db.sql
gzip $db.sql
done;
echo "Finished";
This was verified by a series of two LEDs, one red and one green. The green one is damaged but the current still flows to allow the red LED to emit photons. Replacing the green LED with another red LED proves the damaged LED still allowed a current due to the replacement red LED emitting photons.