# 備份test庫為新的test_tmp庫，與test同級目錄

mysqlhotcopy --user=root --password=root test test_tmp

# 備份test庫 到 /tmp/ 目錄下

mysqlhotcopy --user=root --password=root test /tmp/

# --checkpoint dbinfo.checkpoint 這個是指定存放操作記錄的數據庫/表# --addtodest 增量備份，新的備份自動覆蓋掉原來的

mysqlhotcopy --user=root --password=root --checkpoint=dbinfo.checkpoint --addtodest test /tmp/

mysqlhotcopy的安裝方法如下：

yum -y install perl perl-DBI

wget http://down1.chinaunix.net/distfiles/DBD-mysql-3.0002.tar.gz

tar zxvf DBD-mysql-3.0002.tar.gz

cd DBD-mysql-3.0002

perl Makefile.PL –mysql_config=/usr/local/mysql/bin/mysql_config

make

make test

make install

記錄到到數據庫的方法：

1、在數據庫段分配一個專門用于備份的用戶

mysql> grant select,reload,lock tables on *.* to 'hotcopyer'@'localhost' identified by '123456';

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

2、在/etc/my.cnf或者登陸用戶的個人主文件.my.cnf里面添加

[mysqlhotcopy]

interactive-timeout

user=hotcopyer

password=123456

port=3306

重新加載mysql

3、可以把記錄寫到專門的表中。具體察看幫助。

mysql> create database hotcopy;

Query OK, 1 row affected (0.03 sec)

mysql> use hotcopy

Database changed

mysql> create table checkpoint(time_stamp timestamp not null,src varchar(32),dest varchar(60), msg varchar(255));

Query OK, 0 rows affected (0.01 sec)

同時記得給hotcopyer用戶權限。

mysql> grant insert on hotcopy.checkpoint to hotcopyer@'localhost';

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> quit;

4、備份數據(寫入數據庫{備份的結果}，增量備份)

/usr/local/mysql/bin/mysqlhotcopy --user=root --password=mysql --checkpoint=hotcopy.checkpoint --addtodest radius /bak

5、查看 mysql> show databases; +--------------------+ | Database?????????? | +--------------------+ | information_schema | | 1234la???????????? | | conntrack????????? | | hotcopy??????????? | | mysql????????????? | | pinphp???????????? | | radius???????????? | | test?????????????? | | vod??????????????? | | web??????????????? | +--------------------+ 10 rows in set (0.00 sec) mysql> show tables; +-------------------+ | Tables_in_hotcopy | +-------------------+ | checkpoint??????? | +-------------------+ 1 row in set (0.00 sec) mysql> select * from checkpoint; +---------------------+--------+---------------+-----------+ | time_stamp????????? | src??? | dest????????? | msg?????? | +---------------------+--------+---------------+-----------+ | 2012-08-25 21:50:26 | radius | /bak/radius?? | Succeeded | +---------------------+--------+---------------+-----------+ 1 row in set (0.00 sec) mysql>

總結

以上是生活随笔為你收集整理的mysql有热备吗_mysql备份方法（热备）的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。