mysql-backup-jhcisdb.sh & import.bat ( Restore )

# !/bin/sh
if [ ! -d /home/jhcis/Dropbox/backupjhcis ] ; then
sudo mkdir /home/jhcis/Dropbox/backupjhcis
sudo chmod 777 -fR /home/jhcis/Dropbox/backupjhcis
fi

sudo mysqldump   --default-character-set=utf8  -u  root  -p123456  jhcisdb --routines --compatible=no_key_options > /home/jhcis/Dropbox/backupjhcis/jhcisbackup.03301-$(date -d "+0 day" "+%Y-%m-%d").sql
sudo rm -f /home/jhcis/Dropbox/backupjhcis/jhcisbackup.03301-$(date -d "-7 day" "+%Y-%m-%d").sql
 
exit 0

ของหนองหัวช้างครับ

# !/bin/sh
if [ ! -d /home/jhcis/Dropbox/backupjhcis ] ; then
sudo mkdir /home/jhcis/Dropbox/backupjhcis
sudo chmod 777 -fR /home/jhcis/Dropbox/backupjhcis
fi

if [ ! -d /home/jhcis/backupjhcis ] ; then
sudo mkdir /home/jhcis/backupjhcis
sudo chmod 777 -fR /home/jhcis/backupjhcis
fi

sudo /opt/lampp/bin/mysqldump  --default-character-set=utf8  -u  root  -p123456  jhcisdb --routines --compatible=no_key_options > /home/jhcis/Dropbox/backupjhcis/jhcisbackup.03301-$(date -d "+0 day" "+%Y-%m-%d").sql
sudo rm -f /home/jhcis/Dropbox/backupjhcis/jhcisbackup.03301-$(date -d "-7 day" "+%Y-%m-%d").sql

sudo /opt/lampp/bin/mysqldump  --default-character-set=utf8  -u  root  -p123456  jhcisdb --routines --compatible=no_key_options > /home/jhcis/backupjhcis/jhcisbackup.03301-$(date -d "+0 day" "+%Y-%m-%d").sql
sudo rm -f /home/jhcis/backupjhcis/jhcisbackup.03301-$(date -d "-732 day" "+%Y-%m-%d").sql

sudo /opt/lampp/bin/mysqldump  --default-character-set=utf8  -u  root  -p123456  jepidem --routines --compatible=no_key_options > /home/jhcis/Dropbox/backupjhcis/jepidembackup.03301-$(date -d "+0 day" "+%Y-%m-%d").sql
sudo rm -f /home/jhcis/Dropbox/backupjhcis/jepidembackup.03301-$(date -d "-7 day" "+%Y-%m-%d").sql

sudo /opt/lampp/bin/mysqldump  --default-character-set=utf8  -u  root  -p123456  jepidem --routines --compatible=no_key_options > /home/jhcis/backupjhcis/jepidembackup.03301-$(date -d "+0 day" "+%Y-%m-%d").sql
sudo rm -f /home/jhcis/backupjhcis/jepidembackup.03301-$(date -d "-2222 day" "+%Y-%m-%d").sql

exit 0

Restore
cd\
cd C:\Program Files\JHCIS\MySQL\bin
mysql --default-character-set=utf8 -uroot -p123456 -P3333 -f jhcisdb < "C:\\sqlBackupFileName.sql"
pause