小施Blog

GRANT FILE ON *.* TO backup@''''192.168.0.161'''' IDENTIFIED BY ‘rsync.mysql’;

create database backup;

GRANT FILE ON *.* TO backup@''''192.168.0.41'''' IDENTIFIED BY ‘1234’;

create database backup;

server-id=1
log-bin
binlog-do-db=backup

#!/bin/bash

############### MySQL Backup & FTP ################
#Power By SBear 2004-01-20 2:10
#E-mail:sbear_ji@126.com
#http://www.1842.net
#http://www.CnLinux.net

#1. mkdir /home/backup
#2. chmod 700 MySQLbackup.sh
#3. vi /etc/crontab , 30 03 * * * root /home/backup/MySQLbackup.sh
#everyday 03:30 the MySQLbackup.sh will work

#System Setup
host=192.168.0.3  #ftp host
UserName=ftp      #ftp user name
Passwd=ftp        #fto user password

backup_path=/home/backup  #set saved backup path
file=mysql-$(date +%Y%m%d).tar.gz
backupCWD=/usr/local/mysql/var  #set backup file,the mysql database

#stop mysql database server
/usr/bin/killall mysqld
#/etc/rc.c/init.d/mysqld stop

sleep 5s  #stop 5 second

#file tar
tar -czf $backup_path/$file $backupCWD

sleep 10s

#start mysql database server
/usr/local/mysql/bin/mysqld_safe --user=mysql &  #set your mysqld path
#/etc/rc.d/init.d/mysqld start

cd $backup_path
sleep 1s
#file ftp
ftp -i -n <<!
open $host
user $UserName $Passwd
put  $file
bye
!

sleep 10s
rm -rf $backup_path/$file

<?php
/*/////////////////////////
#FileName: mysql_backup.php
#Author: Austin
#Website: http://shi.i0595.net
////////////////////////*/    
//保存目錄，路徑要用反斜槓。
$store_folder = 'd:dbbackup';

//用戶名和密碼
//該帳號須有操作[所有]的數據庫及FILE的權限
//否則有些數據庫不能備份
$db_username = "这里输入数据库帐号";
$db_password = "这里输入密码";

$time=time();

$nowdir = "$store_folder".date("Ymd",$time)."";
if(file_exists("$nowdir.rar")) die("File exists.rn");
@mkdir($nowdir);

mysql_connect("localhost","$db_username","$db_password");
$query=mysql_list_dbs();


$command = '';
while($result=mysql_fetch_array($query)){
$command .= 'D:Mysqlbinmysqldump --opt '."$result[Database] -u{$db_username} ".($db_password?"-p{$db_password}":"")." > $nowdir$result[Database].sql rn";
$command .= "echo 已經導出數據庫： `$result[Database]`... rn";
}
$command .= "echo 開始壓縮...rn";

$command .= dirname(__FILE__)."WinRARRAR.exe a -ep1 -r -o+ -m5 -df "$nowdir.rar" "$nowdir" rn";

$command .= "echo 搞定 ^_^rn";

$command .= "del mysqldumping_temp.batrn";

$fp = fopen('mysqldumping_temp.bat','w');
fwrite($fp,$command);
fclose($fp);


//刪除 7 天前的文件
@unlink("$store_folder".date("Ymd",$time-86400*7).".rar")
?>

@echo off
cls
title 備份腳本
color 0b
echo 自動備份腳本開始，請不要手動關閉本窗口。本窗口將在備份完成後自動關閉。
D:\Php\PHP.exe mysql_backup.php
if exist mysqldumping_temp.bat call mysqldumping_temp.bat