Mysql Data Backup and remote storage

I sorted out the tuscany.org.cn server and found that the script I wrote three years ago was still running.

 

The script is as follows:

#===================================================== ==============================

#! /Bin/bash
Current_date = 'date + % Y-% m-% d: % H: % m: % s'

/Usr/local/MySQL/bin/mysqldump-prootpass dbname1>./db_dir/dbname1 _ "$ current_date" _ dump_file. SQL
/Usr/local/MySQL/bin/mysqldump-prootpass dbname2>./db_dir/dbname2 _ "$ current_date" _ dump_file. SQL

SCP/root/db_dir/dbname1 _ "$ current_date" _ dump_file. SQL sca@172.90.91.92:/root/dbbakdir

SCP/root/db_dir/dbname2 _ "$ current_date" _ dump_file. SQL sca@172.91.92.93:/root/dbbakdir

 

If [$? -Ne 0]
Then
Mail-s "Warning mesage from the automatic backup program of tuscany.org.cn" wanghongwei@myce.net.cn <mailcontext.txt
Fi

 

#===================================================== ==============================

 

 

Mailcontext.txt content

========================================

An error occurred while backing up Tuscany data. Please check the cause and solve it as soon as possible!