+
1 row in set (0.60 sec)
MariaDB [(none)]> drop database wind;
Query OK, 1 row affected (0.24 sec)
MariaDB [(none)]> commit;
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| jason |
| mysql |
| performance_schema |
| test |
+--------------------+
5 rows in set (0.00 sec)
--3.3 还原指定表空间
mysqlbackup --defaults-file=/usr/local/mysql/my.cnf \
--datadir=/usr/local/mysql/data/ \
--log-bin-index=/usr/local/mysql/mysql_logs/binary_log/mysqldb01-bin.index \
--backup-dir=/backup/2015-04-01_09-39-09 \
--databases="wind" \
copy-back
chown -R mysql /usr/local/mysql
chgrp -R mysql /usr/local/mysql
--3.4验证表空间恢复情况
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| jason |
| mysql |
| performance_schema |
| test |
| wind |
+--------------------+
6 rows in set (0.01 sec)
MariaDB [wind]> select count(*) from t1;
+----------+
| count(*) |
+----------+
| 3000000 |
+----------+
1 row in set (0.60 sec)
|