MySQL/Dump

From Chorke Wiki
Jump to navigation Jump to search
#!/bin/bash
: '
 @author  Academia<[email protected]>
 @vendor  Chorke Academia, Inc.
 @web     chorke.org/academia
 @version 1.0.00.GA
 @since   1.0.00.GA
'

h='cdn.chorke.org';
s='chorke_cdnwiki';
u='chorke_cdnwiki';

d="$(date +'%Y%m%d%H%M'|tr '[:lower:]' '[:upper:]')";
printf '\nBacking up of \033[0;32m%s\033[0m:\n' "$u";
printf -v f './%s/wiki_%s_bkp.dump' "$s" "$d";
p="-h$h -u$u -p $s";
mysqldump $p > $f