[root@tong2 DBD-mysql-4.029]# echo $?

0

[root@tong2 DBD-mysql-4.029]# cd

[root@tong2 ~]#

[mysqlhotcopy]

interactive-timeout

host=localhost

user=root

password=system

port=3306

[root@tong2 ~]# /etc/init.d/mysql restart      --重启服务

Shutting down MySQL.. SUCCESS!

Starting MySQL. SUCCESS!

-?, --help          display this help-screen and exit

-u, --user=#        user for database login if not current user

-p, --password=#    password to use when connecting to server (if not set

in my.cnf, which is recommended)

-h, --host=#        hostname for local server when connecting over TCP/IP

-P, --port=#        port to use when connecting to local server with TCP/IP

-S, --socket=#      socket to use when connecting to local server

--old_server    connect to old MySQL-server (before v5.5) which

doesn't have FLUSH TABLES WITH READ LOCK fully implemented.

--allowold          don't abort if target dir already exists (rename it _old)    --不覆盖以前备份的文件

--addtodest          don't rename target dir if it exists, just add files to it      --属于增量备份

--keepold            don't delete previous (now renamed) target when done

--noindices          don't include full index files in copy          --不备份索引文件

--method=#          method for copy (only "cp" currently supported)

-q, --quiet          be silent except for errors

--debug              enable debug                                          --启用调试输出

-n, --dryrun        report actions without doing them

--regexp=#          copy all databases with names matching regexp  --使用正规表达式

--suffix=#          suffix for names of copied databases

--checkpoint=#      insert checkpoint entry into specified db.table    --插入检查点条目

--flushlog          flush logs once all tables are locked                    --所有表锁定后刷新日志

--resetmaster        reset the binlog once all tables are locked        --一旦锁表重置binlog文件

--resetslave        reset the master.info once all tables are locked  --一旦锁表重置master.info文件

--tmpdir=#        temporary directory (instead of /tmp)

--record_log_pos=#  record slave and master status in specified db.table

--chroot=#          base directory of chroot jail in which mysqld operates

[root@tong2 ~]# ll /opt/tong/

total 112

-rw-rw----. 1 mysql mysql    15 Jan  5 14:35 q.isl

-rw-rw----. 1 mysql mysql  8554 Jan  4 18:03 t.frm

-rw-rw----. 1 mysql mysql 98304 Jan  4 18:03 t.ibd

[root@tong2 ~]# ll /var/lib/mysql/tong

total 112

-rw-rw----. 1 mysql mysql    15 Jan  5 14:35 q.isl

-rw-rw----. 1 mysql mysql  8554 Jan  4 18:03 t.frm

-rw-rw----. 1 mysql mysql 98304 Jan  4 18:03 t.ibd

[root@tong2 ~]#

[root@tong2 ~]# ll /opt/

total 8

drwxr-x---. 2 mysql mysql 4096 Jan  5 15:29 mysql

drwxr-x---. 2 mysql mysql 4096 Jan  5 15:29 tong

[root@tong2 ~]# ll /var/lib/mysql/{mysql,tong} -d

drwxr-xr-x. 2 mysql mysql 4096 Jan  5 15:29 /var/lib/mysql/mysql

drwxr-xr-x. 2 mysql mysql 4096 Jan  5 15:29 /var/lib/mysql/tong

[root@tong2 ~]#

[root@tong2 ~]# ll /opt/mysql/

total 20

-rw-r--r--. 1 mysql mysql 10684 Jan  4 16:49 user.frm

-rw-r--r--. 1 mysql mysql  784 Jan  4 16:49 user.MYD

-rw-r--r--. 1 mysql mysql  2048 Jan  4 16:49 user.MYI

[root@tong2 ~]# ll /var/lib/mysql/mysql/user.*

-rw-r--r--. 1 mysql mysql 10684 Jan  4 16:49 /var/lib/mysql/mysql/user.frm

-rw-r--r--. 1 mysql mysql  784 Jan  4 16:49 /var/lib/mysql/mysql/user.MYD

-rw-r--r--. 1 mysql mysql  2048 Jan  4 16:49 /var/lib/mysql/mysql/user.MYI

[root@tong2 ~]#

[root@tong2 ~]# rm -rf /var/lib/mysql/tong

[root@tong2 ~]# mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 29

Server version: 5.6.21-log MySQL Community Server (GPL)

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

mysql> show databases;

+--------------------+

| Database          |

+--------------------+

| information_schema |

| mysql              |

| performance_schema |

| test              |

+--------------------+

4 rows in set (0.00 sec)

[root@tong2 ~]# cp -arp /opt/tong /var/lib/mysql/        --将备份的数据移到mysql数据根目录

[root@tong2 ~]# mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 30

Server version: 5.6.21-log MySQL Community Server (GPL)

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

mysql> \u tong

Database changed

mysql> show tables;

+----------------+

| Tables_in_tong |

+----------------+

| t              |

+----------------+

2 rows in set (0.00 sec)