原文:http://www.madden2009.cn/?p=520
MYSQLHOTCOPY用法详解
1)、mysqlhotcopy 原数据库名，新数据库名
[root@localhost ~]# mysqlhotcopy t_girl t_girl_new
Locked 4 tables in 0 seconds.
Flushed tables (`t_girl`.`category`, `t_girl`.`category_part`, `t_girl`.`id`, `t_girl`.`parent`) in 0 seconds.
Copying 22 files...
Copying indices for 0 files...
Unlocked tables.
mysqlhotcopy copied 4 tables (22 files) in 5 seconds (5 seconds overall).
2)、mysqlhotcopy 原数据库名，备份的目录
[root@localhost ~]# mysqlhotcopy t_girl /tmp/
Locked 4 tables in 0 seconds.
Flushed tables (`t_girl`.`category`, `t_girl`.`category_part`, `t_girl`.`id`, `t_girl`.`parent`) in 0 seconds.
Copying 22 files...
Copying indices for 0 files...
Unlocked tables.
mysqlhotcopy copied 4 tables (22 files) in 6 seconds (6 seconds overall).
3)、对单个表支持正则表达式
(除了id 表外)
[root@localhost data]# mysqlhotcopy t_girl./~id/
Using copy suffix ‘_copy’
Locked 3 tables in 0 seconds.
Flushed tables (`t_girl`.`category`, `t_girl`.`category_part`, `t_girl`.`parent`) in 0 seconds.
Copying 19 files...
Copying indices for 0 files...
Unlocked tables.
mysqlhotcopy copied 3 tables (19 files) in 6 seconds (6 seconds overall).
[root@localhost data]#
4)、可以把记录写到专门的表中。具体察看帮助。
perldoc mysqlhostcopy
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> \q
Bye
重复第三步的操作
[root@localhost ~]# mysqlhotcopy t_girl./~id/ –allowold –checkpoint hotcopy.checkpoint
Using copy suffix ‘_copy’
Existing hotcopy directory renamed to ‘/usr/local/mysql/data/t_girl_copy_old’
Locked 3 tables in 0 seconds.
Flushed tables (`t_girl`.`category`, `t_girl`.`category_part`, `t_girl`.`parent`) in 0 seconds.
Copying 19 files...
Copying indices for 0 files...
Unlocked tables.
mysqlhotcopy copied 3 tables (19 files) in 12 seconds (13 seconds overall).
默认保存在数据目录下/t_girl_copy/
看看记录表。
mysql> use hotcopy;
Database changed
mysql> select * from checkpoint;
--------------------- -------- ----------------------------------- -----------
| time_stamp | src | dest | msg |
--------------------- -------- ----------------------------------- -----------
| 2008-03-11 14:44:58 | t_girl | /usr/local/mysql/data/t_girl_copy | Succeeded |
--------------------- -------- ----------------------------------- -----------
1 row in set (0.00 sec)
5)、支持增量备份。
[root@localhost ~]# mysqlhotcopy t_girl./~id/ –allowold –checkpoint hotcopy.checkpoint –addtodest t_girl_new
Locked 3 tables in 0 seconds.
Flushed tables (`t_girl`.`category`, `t_girl`.`category_part`, `t_girl`.`parent`) in 0 seconds.
Copying 19 files...
Copying indices for 0 files...
Unlocked tables.
mysqlhotcopy copied 3 tables (19 files) in 7 seconds (7 seconds overall). |