Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- export TERM=xterm;
- clear;
- echo " ";
- echo "---------------------------------------------";
- echo " START | "$(date +%m.%d.%Y-%H.%M.%S);
- echo "---------------------------------------------";
- #create db dump for all databases
- export PATH=/Applications/MAMP/Library/bin/:$PATH;
- mysqluser=<YOUR MYSQL USER>;
- mysqlpass=<YOUR MYSQL PASSWORD>;
- basepath=<WHERE TO STORE DUMPS>;
- latest=$basepath"_latest/";
- date=$basepath"h_"$(date +%Y%m%d_%H%M)"/";
- mv $latest $date;
- mkdir $latest;
- for I in $(mysql -e 'show databases' -s --skip-column-names -p$mysqlpass -u$mysqluser);
- do
- if [[ "$I" == *"_schema" ]]; then
- echo "--skipping $I";
- else
- echo "dumping $I...";
- mysqldump -p$mysqlpass -u$mysqluser $I | gzip > "$latest$I.sql.gz";
- fi
- done
- echo "---------------------------------------------";
- echo " COMPLETE | "$(date +%m.%d.%Y-%H.%M.%S);
- echo "---------------------------------------------";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement