MySQL备份与恢复之percona-xtrabackup实现增量备份及恢复 - 数据库编程

wn mysql.mysql /usr/local/mysql/data/ -R

第十六步，启动服务

[root@serv01 data]# /etc/init.d/mysqld start
Starting MySQL.. SUCCESS!

第十七步，登录数据库，然后查看数据

[root@serv01 data]# mysql -uroot -p123456
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| game               |
| hello              |
| larrydb            |
| mnt                |
| mysql              |
| performance_schema |
| test               |
+--------------------+
8 rows in set (0.00 sec)

mysql> select * from larrydb.class;
+------+-------+
| cid  | cname |
+------+-------+
|    1 | linux |
|    2 | dab   |
|    3 | Devel |
+------+-------+
3 rows in set (0.00 sec)

mysql> select * from larrydb.stu;
+------+----------+------+
| sid  | sname    | cid  |
+------+----------+------+
|    1 | larry007 |    1 |
|    2 | larry02  |    1 |
|    3 | larry03  |    1 |
|    4 | larry04  |    1 |
+------+----------+------+
4 rows in set (0.00 sec)

  我的邮箱：wgbno27@163.com
  新浪微博：@jutdb         
  微信公众平台：JustOracle（微信号：justoracle）
  数据库技术交流群：336882565（加群时验证 From CSDN XXX）
  All is well
  2013年12月1日
  By Larry Wen

MySQL备份与恢复之percona-xtrabackup实现增量备份及恢复(三)