SQL Backup with email alert

在左邊Toolbox -> Maintenance Plan Tasks尋找Back Up Database Task, 然後Drop it到右邊窗格

Double Click Back Up Database Task, 以下備份設定, 請根據需要修改和設定

Toolbox -> Maintenance Plan Tasks -> Shrink Database Task

Toolbox -> Maintenance Plan Tasks -> Rebuild Index Task

Toolbox -> Maintenance Plan Tasks -> Maintenance Cleanup Task

Toolbox -> Maintenance Plan Tasks -> Notify Operator Task

Toolbox -> Maintenance Plan Tasks -> Notify Operator Task

最後設定Schedule

記得要Save

MySQL configure and command

[mysqld]
max_connections=2000
max_connect_errors=65535
connect_timeout=20
skip-name-resolve

SHOW VARIABLES LIKE ‘%max%’
mysqladmin flush-hosts

Repair Tables
mysqlcheck –all-databases
mysqlcheck –repair –all-databases
mysql> REPAIR TABLE table1;