Shulou(Shulou.com)06/01 Report--

1. Write a timing script

1.1 linux system

Vi dbback.sh

#! / bin/sh

Home=/usr/local/mysql

Now=date +% Y%m%d

Cd $home/back

Echo "You are in backup dir:"% home%

# echo $home/back/$now

$home/bin/mysqldump-u {username}-p {passwd} dbname > $home/back/$now.sql

Echo "Your database backup successfully completed"

1.2 windows system

Create a new file dbback.bat

Set home=D:\ mysql

Set backDir=H:\ db\ zentao

Set now=%date:~0,4%%date:~5,2%%date:~8,2%

Cd backDir%

Echo "You are in backup dir:" $home

Echo% backDir%\% now%

% home%\ bin\ mysqldump.exe-uroot-pqwaszxer-h 10.110.1.251 zentao >% backDir%\% now%.sql

Echo "Your database backup successfully completed"

two。 Define scheduled tasks

2.1 linux system

Crontab-e

5 1 * / usr/local/mysql/dbback.sh

2.2 windows system

Open Control Panel-Administrative tools-Task Scheduler

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.