How to implement daily automatic mysql database backup in linux _ MySQL-mysql tutorial

How to implement daily automatic backup of bitsCN.com for mysql databases in linux

How to implement daily automatic mysql database backup in linux

Create a backup folder:

Mkdir mysql_data_bak

Create a script file:

Touch autobackupmysql. sh

Open a file

Vi autobackupmysql. sh

Add the following content to the script:

Filename = 'date + % Y % m % d'

/Usr/bin/mysqldump-uroot-proot boss>/home/mysql_data_bak/$ filename. SQL

Check whether crond is installed. If no, install crond first.

Yum-y install vixie-cron

Yum-y install crontabs

Start service: service crond start

Add boot Auto Start to CentOS: chkconfig -- level 345 crond on

Crontab-e

Added: 00 03 *** source/root/autobackupmysql. sh

Run this file at every morning to back up the database.

Service crond restart

Complete

BitsCN.com