Linux server instance MYSQL daily backup script

I used to talk a lot about various methods for regular backup of mysql databases. Today I will introduce a super simple instance script for mysql backing up databases every day in linux.

So far, none of MYSQL is always normal.

Backup is king.

The script is as follows:

The Code is as follows:	Copy code
#! /Bin/sh # File:/home/mysql/backup. sh # Database info DB_NAME = "myad" DB_USER = "ad123" DB_PASS = "ad ^ % # dd" # Others vars BIN_DIR = "/opt/lampp/bin" BCK_DIR = "/backup/www/sqlback" DATE = 'date + % F' # TODO $ BIN_DIR/mysqldump -- opt-u $ DB_USER-p $ DB_PASS $ DB_NAME | gzip> $ BCK_DIR/adm _ $ D ATE.gz

O & M servers require multiple backups. Otherwise, you do not know how to solve the problem.