#! /Bin/bash
# Backup ad dbserver svr122.16to svr12234
# Sip = 192.168.4.154
CD/usr/local/yicha/tools/cnshop/backup /;
Synchronize shell scripts. Original Author mr. Jin
========================================================== ========================================================== ===
Tables_list = 'table. list'
Tb_list = 'cat $ tables_list | grep-V "#"'
Echo 'date + % F' % t' dB cntrade backup start ........................ .............. '> cnshop_sys.log;
For tb_name in $ tb_list
Do
/Usr/local/MySQL/bin/mysqldump-H 192.168.0.2-uroot-proot -- Opt -- compress cnshop $ tb_name |/usr/local/MySQL/bin/MySQL-uroot-proot cnshop;
Echo 'date + % F' % t' "DB cntrade $ tb_name backup OK."> cnshop_sys.log;
Done
Echo 'date + % F' % t' dB cntrade backup finished !....................... ........... '> Cnshop_sys.log;
MySQL backup script ============================================ ====================================
#/Bin/sh
Lastday = 'date -- date = "1 day ago" + % Y-% m-% d'; # One day ago
If test $1
Then
Lastday = $1;
FI;
Username = "root ";
Password = "root ";
Table = "cnshop ";
Position = "/usr/local/yicha/backup/DB /";
Filename = $ table "." $ lastday ". SQL ";
/Usr/local/MySQL/bin/mysqldump-U $ username-p $ password -- skip-opt-r $ table> $ position $ filename;
# Here -- skip-OPT is used to remove the optimized locking capability.-R is used to include the stored procedure.
CD $ position;
Tar czvf $ FILENAME ". tgz" $