As users come to depend on MySQL, they find that they have to deal with issues of reliability, scalability, and performance--issues that are not well documented but are critical to a smoothly functioning site. This book is an insider's guide to thes
What this book covers Chapter 1, Replication: In this chapter, you will see how to set up MySQL replication, useful for load balancing, online backups, and fail-over scenarios. Advanced replication scenarios using the blackhole engine and streaming
mysql backup Release 1.2.1.2 自動備份 免安裝 MySQL 資料庫的工具 - MySQL MySQL Backup Tool
備份 MySQL 資料庫是資料庫管理的基本任務,雖然可以直接通過 mysqldump 進行備份,但是,要實現自動備份還是需要做許多工作。MySQL Backup Tool 為我們提供了自動化備份 MySQL 資料庫的支援。附有說明教學文件
特性:
mySQL 備份(自動, 手動和定時)
結構 /架構和儲存過程 / 函式
壓縮為 zip 檔案
#!/bin/bash
#this is a scr ipt of mysql backup
if [ ! -d /mydata/data1/backup ] ;then
mkdir /mydata/data1/backup
fi
cd /mydata/data1/backup
file=$(find . -type f -mtime -7 | grep .*all.sql) #查找7天内是否有备份的文件
echo $file
if [ -z $file ] ;then
echo "bac
