1. 安装与解压xtrabackup!
1.1 创建一个xtrabackup目录,然后将xtrabackup解压,并安装!!
[root@lzz ~]# mkdir xtrabackup
[root@lzz ~]# cd xtrabackup/
[root@lzz xtrabackup]# ls
[root@lzz xtrabackup]# wget https://downloads.percona.com/downloads/Percona-XtraBackup-2.4/Percona-XtraBackup-2.4.22/binary/redhat/8/x86_64/Percona-XtraBackup-2.4.22-rc99a781-el8-x86_64-bundle.tar
--2021-05-09 19:33:34-- https://downloads.percona.com/downloads/Percona-XtraBackup-2.4/Percona-XtraBackup-2.4.22/binary/redhat/8/x86_64/Percona-XtraBackup-2.4.22-rc99a781-el8-x86_64-bundle.tar
正在解析主机 downloads.percona.com (downloads.percona.com)... 162.220.4.222
正在连接 downloads.percona.com (downloads.percona.com)|162.220.4.222|:443... 已连接。
已发出 HTTP 请求,正在等待回应... 200 OK
长度:76595200 (73M) [application/x-tar]
正在保存至: “Percona-XtraBackup-2.4.22-rc99a781-el8-x86_64-bundle.tar”
Percona-XtraBack 100%[=======>] 73.05M 10.4MB/s 用时 8.9s
2021-05-09 19:33:44 (8.23 MB/s) - 已保存 “Percona-XtraBackup-2.4.22-rc99a781-el8-x86_64-bundle.tar” [76595200/76595200])
[root@lzz xtrabackup]# ————————————————
bash: ————————————————: 未找到命令...
[root@lzz xtrabackup]# 版权声明:本文为CSDN博主「dieyo」的原创文 章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
bash: 版权声明:本文为CSDN博主「dieyo」的原创文章,遵循CC: 未找到命令...
[root@lzz xtrabackup]# 原文链接:https://blog.csdn.net/dieyo/article/details/116574991
-bash: 原文链接:https://blog.csdn.net/dieyo/article/details/116574991: 没有那个文件或目录
[root@lzz xtrabackup]# ls
Percona-XtraBackup-2.4.22-rc99a781-el8-x86_64-bundle.tar
[root@lzz xtrabackup]# tar xf Percona-XtraBackup-2.4.22-rc99a781-el8-x86_64-bundle.tar
[root@lzz xtrabackup]# ls
Percona-XtraBackup-2.4.22-rc99a781-el8-x86_64-bundle.tar
percona-xtrabackup-24-2.4.22-1.el8.x86_64.rpm
percona-xtrabackup-24-debuginfo-2.4.22-1.el8.x86_64.rpm
percona-xtrabackup-24-debugsource-2.4.22-1.el8.x86_64.rpm
percona-xtrabackup-test-24-2.4.22-1.el8.x86_64.rpm
percona-xtrabackup-test-24-debuginfo-2.4.22-1.el8.x86_64.rpm
[root@lzz xtrabackup]# dnf -y install percona-xtrabackup-24-2.4.22-1.el8.x86_64.rpm
CentOS Stream 8 - AppStream 8.8 kB/s | 4.4 kB 00:00
CentOS Stream 8 - AppStream 6.2 MB/s | 8.5 MB 00:01
CentOS Stream 8 - BaseOS 7.1 kB/s | 3.9 kB 00:00
CentOS Stream 8 - BaseOS 2.7 MB/s | 2.7 MB 00:00
CentOS Stream 8 - Extras 2.2 kB/s | 1.5 kB 00:00
依赖关系解决。
=================================================================
软件包 架构 版本 仓库 大小
=================================================================
安装:
percona-xtrabackup-24 x86_64 2.4.22-1.el8 @commandline 7.7 M
安装依赖关系:
libev x86_64 4.24-6.el8 appstream 52 k
mariadb-connector-c x86_64 3.1.11-2.el8_3 appstream 200 k
mariadb-connector-c-config
noarch 3.1.11-2.el8_3 appstream 15 k
perl-DBD-MySQL x86_64 4.046-3.module_el8.3.0+419+c2dec72b
appstream 156 k
启用模块流:
perl-DBD-MySQL 4.046
事务概要
=================================================================
安装 5 软件包
总计:8.1 M
总下载:423 k
安装大小:32 M
下载软件包:
(1/4): libev-4.24-6.el8.x86_64.r 777 kB/s | 52 kB 00:00
(2/4): mariadb-connector-c-3.1.1 1.8 MB/s | 200 kB 00:00
(3/4): mariadb-connector-c-confi 128 kB/s | 15 kB 00:00
(4/4): perl-DBD-MySQL-4.046-3.mo 2.6 MB/s | 156 kB 00:00
-----------------------------------------------------------------
总计 860 kB/s | 423 kB 00:00
运行事务检查
事务检查成功。
运行事务测试
事务测试成功。
运行事务
准备中 : 1/1
安装 : mariadb-connector-c-config-3.1.11-2.el8_3.noar 1/5
警告:/etc/my.cnf 已建立为 /etc/my.cnf.rpmnew
安装 : mariadb-connector-c-3.1.11-2.el8_3.x86_64 2/5
安装 : perl-DBD-MySQL-4.046-3.module_el8.3.0+419+c2de 3/5
安装 : libev-4.24-6.el8.x86_64 4/5
安装 : percona-xtrabackup-24-2.4.22-1.el8.x86_64 5/5
运行脚本: percona-xtrabackup-24-2.4.22-1.el8.x86_64 5/5
验证 : libev-4.24-6.el8.x86_64 1/5
验证 : mariadb-connector-c-3.1.11-2.el8_3.x86_64 2/5
验证 : mariadb-connector-c-config-3.1.11-2.el8_3.noar 3/5
验证 : perl-DBD-MySQL-4.046-3.module_el8.3.0+419+c2de 4/5
验证 : percona-xtrabackup-24-2.4.22-1.el8.x86_64 5/5
Installed products updated.
已安装:
libev-4.24-6.el8.x86_64
mariadb-connector-c-3.1.11-2.el8_3.x86_64
mariadb-connector-c-config-3.1.11-2.el8_3.noarch
percona-xtrabackup-24-2.4.22-1.el8.x86_64
perl-DBD-MySQL-4.046-3.module_el8.3.0+419+c2dec72b.x86_64
完毕!
[root@lzz xtrabackup]#
1.2 将mysql的套接文字连接到以下目录下!
[root@lzz xtrabackup]# mkdir /var/lib/mysql
[root@lzz xtrabackup]# ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
[root@lzz xtrabackup]#
1.3 创建备份存放的目录!
[root@lzz xtrabackup]# cd /
[root@lzz /]# mkdir /backup
[root@lzz /]# mkdir /backup/all
[root@lzz /]# mkdir /backup/e1
[root@lzz /]# mkdir /backup/e2
[root@lzz /]#
1.4 将密码写入配置文件中!
[root@lzz /]# vim ~/.mysql_cnf
[root@lzz /]# cat ~/.mysql_cnf
[client]
user=root
password=liuZEzheng123!
[innobackupex]
user=root
password=liuZEzheng123!
2. 开始增量备份!
2.1 备份之前查看数据库里面原有的内容!
mysql> select * from lzz.lp;
+------+-----------+------+
| id | name | age |
+------+-----------+------+
| 1 | xieer | 20 |
| 2 | chengling | 15 |
| 3 | wink | 29 |
| 4 | zzh | 30 |
| 5 | ljj | 31 |
| 6 | zhouxu | 25 |
| 7 | zky | 24 |
| 8 | fuwenduo | 24 |
| 9 | yangyuan | 23 |
| 10 | tangmo | 20 |
+------+-----------+------+
10 rows in set (0.00 sec)
2.2 开始全量备份!
[root@lzz ~]# xtrabackup --backup --target-dir /backup/all
xtrabackup: recognized server arguments: --datadir=/opt/data --server-id=1 --log_bin=mysql_bin
xtrabackup: recognized client arguments: --user=root --password=* --backup=1 --target-dir=/backup/all
210509 20:11:08 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: YES).
210509 20:11:08 version_check Connected to MySQL server
210509 20:11:08 version_check Executing a version check against the server...
......
210509 20:11:12 Executing UNLOCK TABLES
210509 20:11:12 All tables unlocked
210509 20:11:12 [00] Copying ib_buffer_pool to /backup/all/ib_buffer_pool
210509 20:11:12 [00] ...done
210509 20:11:12 Backup created in directory '/backup/all/'
MySQL binlog position: filename 'mysql_bin.000006', position '154'
210509 20:11:12 [00] Writing /backup/all/backup-my.cnf
210509 20:11:12 [00] ...done
210509 20:11:12 [00] Writing /backup/all/xtrabackup_info
210509 20:11:12 [00] ...done
xtrabackup: Transaction log of lsn (8922688) to (8922697) was copied.
210509 20:11:13 completed OK!
[root@lzz ~]# ll /backup/all
总用量 12340
-rw-r-----. 1 root root 487 5月 9 20:11 backup-my.cnf
drwxr-x---. 2 root root 20 5月 9 20:11 gj
-rw-r-----. 1 root root 669 5月 9 20:11 ib_buffer_pool
-rw-r-----. 1 root root 12582912 5月 9 20:11 ibdata1
drwxr-x---. 2 root root 76 5月 9 20:11 lzz
drwxr-x---. 2 root root 4096 5月 9 20:11 mysql
drwxr-x---. 2 root root 8192 5月 9 20:11 performance_schema
drwxr-x---. 2 root root 8192 5月 9 20:11 sys
-rw-r-----. 1 root root 21 5月 9 20:11 xtrabackup_binlog_info
-rw-r-----. 1 root root 135 5月 9 20:11 xtrabackup_checkpoints
-rw-r-----. 1 root root 462 5月 9 20:11 xtrabackup_info
-rw-r-----. 1 root root 2560 5月 9 20:11 xtrabackup_logfile
drwxr-x---. 2 root root 20 5月 9 20:11 zzh
[root@lzz ~]# cat /backup/all/xtrabackup_checkpoints
backup_type = full-backuped
from_lsn = 0
to_lsn = 8922688
last_lsn = 8922697
compact = 0
recover_binlog_info = 0
flushed_lsn = 8922697
2.3 返回MySQL 再已经备份的表中添入新的数据!
mysql> insert into lp(id,name,age) values(11,'xioasg',24),(12,'bz',25);
Query OK, 2 rows affected (0.01 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> select * from lp;
+------+-----------+------+
| id | name | age |
+------+-----------+------+
| 1 | xieer | 20 |
| 2 | chengling | 15 |
| 3 | wink | 29 |
| 4 | zzh | 30 |
| 5 | ljj | 31 |
| 6 | zhouxu | 25 |
| 7 | zky | 24 |
| 8 | fuwenduo | 24 |
| 9 | yangyuan | 23 |
| 10 | tangmo | 20 |
| 11 | xioasg | 24 |
| 12 | bz | 25 |
+------+-----------+------+
12 rows in set (0.00 sec)
2.4 我们再全备的基础上进行增备!
[root@lzz ~]# xtrabackup --backup --target-dir /backup/e1/ --incremental-basedir /backup/all/
xtrabackup: recognized server arguments: --datadir=/opt/data --server-id=1 --log_bin=mysql_bin
xtrabackup: recognized client arguments: --user=root --password=* --backup=1 --target-dir=/backup/e1/ --incremental-basedir=/backup/all/
210509 20:18:39 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: YES).
210509 20:18:39 version_check Connected to MySQL server
210509 20:18:39 version_check Executing a version check against the server...
210509 20:18:39 version_check Done.
210509 20:18:39 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set
Using server version 5.7.33-log
xtrabackup version 2.4.22 based on MySQL server 5.7.32 Linux (x86_64) (revision id: c99a781)
......
210509 20:18:41 Executing UNLOCK TABLES
210509 20:18:41 All tables unlocked
210509 20:18:41 [00] Copying ib_buffer_pool to /backup/e1/ib_buffer_pool
210509 20:18:41 [00] ...done
210509 20:18:41 Backup created in directory '/backup/e1/'
MySQL binlog position: filename 'mysql_bin.000006', position '426'
210509 20:18:41 [00] Writing /backup/e1/backup-my.cnf
210509 20:18:41 [00] ...done
210509 20:18:41 [00] Writing /backup/e1/xtrabackup_info
210509 20:18:41 [00] ...done
xtrabackup: Transaction log of lsn (8923152) to (8923161) was copied.
210509 20:18:41 completed OK!
[root@lzz ~]# ll /backup/e
e1/ e2/
[root@lzz ~]# ll /backup/e
e1/ e2/
[root@lzz ~]# ll /backup/e1
总用量 184
-rw-r-----. 1 root root 487 5月 9 20:18 backup-my.cnf
drwxr-x---. 2 root root 20 5月 9 20:18 gj
-rw-r-----. 1 root root 669 5月 9 20:18 ib_buffer_pool
-rw-r-----. 1 root root 131072 5月 9 20:18 ibdata1.delta
-rw-r-----. 1 root root 60 5月 9 20:18 ibdata1.meta
drwxr-x---. 2 root root 126 5月 9 20:18 lzz
drwxr-x---. 2 root root 4096 5月 9 20:18 mysql
drwxr-x---. 2 root root 8192 5月 9 20:18 performance_schema
drwxr-x---. 2 root root 8192 5月 9 20:18 sys
-rw-r-----. 1 root root 21 5月 9 20:18 xtrabackup_binlog_info
-rw-r-----. 1 root root 139 5月 9 20:18 xtrabackup_checkpoints
-rw-r-----. 1 root root 503 5月 9 20:18 xtrabackup_info
-rw-r-----. 1 root root 2560 5月 9 20:18 xtrabackup_logfile
drwxr-x---. 2 root root 20 5月 9 20:18 zzh
2.5 我们再次返回mysql 上添加数据!
mysql> insert into lp(id,name,age) values(13,'tom',26),(14,'jerry',23);
Query OK, 2 rows affected (0.01 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> select * from lp;
+------+-----------+------+
| id | name | age |
+------+-----------+------+
| 1 | xieer | 20 |
| 2 | chengling | 15 |
| 3 | wink | 29 |
| 4 | zzh | 30 |
| 5 | ljj | 31 |
| 6 | zhouxu | 25 |
| 7 | zky | 24 |
| 8 | fuwenduo | 24 |
| 9 | yangyuan | 23 |
| 10 | tangmo | 20 |
| 11 | xioasg | 24 |
| 12 | bz | 25 |
| 13 | tom | 26 |
| 14 | jerry | 23 |
+------+-----------+------+
14 rows in set (0.00 sec)
2.6 在第一次的基础上做第二次增备!!
[root@lzz ~]# xtrabackup --backup --target-dir /backup/e2/ --incremental-basedir /backup/e1/
xtrabackup: recognized server arguments: --datadir=/opt/data --server-id=1 --log_bin=mysql_bin
xtrabackup: recognized client arguments: --user=root --password=* --backup=1 --target-dir=/backup/e2/ --incremental-basedir=/backup/e1/
210509 20:26:00 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: YES).
210509 20:26:00 version_check Connected to MySQL server
210509 20:26:00 version_check Executing a version check against the server...
210509 20:26:00 version_check Done.
210509 20:26:00 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set
Using server version 5.7.33-log
xtrabackup version 2.4.22 based on MySQL server 5.7.32 Linux (x86_64) (revision id: c99a781)
......
210509 20:26:02 Executing UNLOCK TABLES
210509 20:26:02 All tables unlocked
210509 20:26:02 [00] Copying ib_buffer_pool to /backup/e2/ib_buffer_pool
210509 20:26:02 [00] ...done
210509 20:26:02 Backup created in directory '/backup/e2/'
MySQL binlog position: filename 'mysql_bin.000006', position '698'
210509 20:26:02 [00] Writing /backup/e2/backup-my.cnf
210509 20:26:02 [00] ...done
210509 20:26:02 [00] Writing /backup/e2/xtrabackup_info
210509 20:26:02 [00] ...done
xtrabackup: Transaction log of lsn (8923580) to (8923589) was copied.
210509 20:26:02 completed OK!
[root@lzz ~]# ll /backup/e2
总用量 152
-rw-r-----. 1 root root 487 5月 9 20:26 backup-my.cnf
drwxr-x---. 2 root root 20 5月 9 20:26 gj
-rw-r-----. 1 root root 669 5月 9 20:26 ib_buffer_pool
-rw-r-----. 1 root root 98304 5月 9 20:26 ibdata1.delta
-rw-r-----. 1 root root 60 5月 9 20:26 ibdata1.meta
drwxr-x---. 2 root root 126 5月 9 20:26 lzz
drwxr-x---. 2 root root 4096 5月 9 20:26 mysql
drwxr-x---. 2 root root 8192 5月 9 20:26 performance_schema
drwxr-x---. 2 root root 8192 5月 9 20:26 sys
-rw-r-----. 1 root root 21 5月 9 20:26 xtrabackup_binlog_info
-rw-r-----. 1 root root 139 5月 9 20:26 xtrabackup_checkpoints
-rw-r-----. 1 root root 502 5月 9 20:26 xtrabackup_info
-rw-r-----. 1 root root 2560 5月 9 20:26 xtrabackup_logfile
drwxr-x---. 2 root root 20 5月 9 20:26 zzh
2.7 恢复备份!
防止全备和增量备份日志回滚(除了最后一次的增量备份外)
80 xtrabackup --prepare --apply-log-only --target-dir /backup/all/
81 xtrabackup --prepare --apply-log-only --target-dir /backup/all/ --incremental-dir /backup/e1/
82 history
最后一次增量备份不使用apply-log-only参数 (防止回滚!)
[root@lzz ~]# xtrabackup --prepare --target-dir /backup/all/ --incremental-dir /backup/e2/
xtrabackup: recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksum_algorithm=strict_crc32 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_files_in_group=2 --innodb_log_file_size=50331648 --innodb_fast_checksum=0 --innodb_page_size=16384 --innodb_log_block_size=512 --innodb_undo_directory=./ --innodb_undo_tablespaces=0 --server-id=1 --redo-log-version=1
xtrabackup: recognized client arguments: --prepare=1 --target-dir=/backup/all/ --incremental-dir=/backup/e2/
xtrabackup version 2.4.22 based on MySQL server 5.7.32 Linux (x86_64) (revision id: c99a781)
......
InnoDB: File './ibtmp1' size is now 12 MB.
InnoDB: 96 redo rollback segment(s) found. 1 redo rollback segment(s) are active.
InnoDB: 32 non-redo rollback segment(s) are active.
InnoDB: Waiting for purge to start
InnoDB: 5.7.32 started; log sequence number 8923669
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 8923688
210509 20:32:40 completed OK!
[root@lzz ~]#
[root@lzz ~]# cat /backup/all/xtrabackup_checkpoints
backup_type = full-prepared
from_lsn = 0
to_lsn = 8923580
last_lsn = 8923589
compact = 0
recover_binlog_info = 0
flushed_lsn = 8923589
[root@lzz ~]# cat /backup/e1/xtrabackup_checkpoints
backup_type = incremental
from_lsn = 8922688
to_lsn = 8923152
last_lsn = 8923161
compact = 0
recover_binlog_info = 0
flushed_lsn = 8923161
[root@lzz ~]# cat /backup/e2/xtrabackup_checkpoints
backup_type = incremental
from_lsn = 8923152
to_lsn = 8923580
last_lsn = 8923589
compact = 0
recover_binlog_info = 0
flushed_lsn = 8923589
2.8 删除数据库!!!
mysql> drop database lzz;
Query OK, 2 rows affected (0.01 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| gj |
| mysql |
| performance_schema |
| sys |
| zzh |
+--------------------+
6 rows in set (0.00 sec)
2.9 恢复数据!!
[root@lzz /]# service mysqld stop
Shutting down MySQL.. SUCCESS!
[root@lzz /]# rm -rf /opt/data/*
[root@lzz /]# xtrabackup --copy-back --target-dir /backup/all/
xtrabackup: recognized server arguments: --datadir=/opt/data --server-id=1 --log_bin=mysql_bin
xtrabackup: recognized client arguments: --user=root --password=* --copy-back=1 --target-dir=/backup/all/
xtrabackup version 2.4.22 based on MySQL server 5.7.32 Linux (x86_64) (revision id: c99a781)
......
210509 20:48:02 [01] Copying ./performance_schema/session_connect_attrs.frm to /opt/data/performance_schema/session_connect_attrs.frm
210509 20:48:02 [01] ...done
210509 20:48:02 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /opt/data/performance_schema/session_account_connect_attrs.frm
210509 20:48:02 [01] ...done
210509 20:48:02 [01] Copying ./performance_schema/table_handles.frm to /opt/data/performance_schema/table_handles.frm
210509 20:48:02 [01] ...done
210509 20:48:02 [01] Copying ./performance_schema/metadata_locks.frm to /opt/data/performance_schema/metadata_locks.frm
210509 20:48:02 [01] ...done
210509 20:48:02 [01] Copying ./performance_schema/user_variables_by_thread.frm to /opt/data/performance_schema/user_variables_by_thread.frm
210509 20:48:02 [01] ...done
210509 20:48:02 [01] Copying ./performance_schema/variables_by_thread.frm to /opt/data/performance_schema/variables_by_thread.frm
210509 20:48:02 [01] ...done
210509 20:48:02 [01] Copying ./performance_schema/global_variables.frm to /opt/data/performance_schema/global_variables.frm
210509 20:48:02 [01] ...done
210509 20:48:02 [01] Copying ./performance_schema/session_variables.frm to /opt/data/performance_schema/session_variables.frm
210509 20:48:02 [01] ...done
210509 20:48:02 [01] Copying ./performance_schema/status_by_thread.frm to /opt/data/performance_schema/status_by_thread.frm
210509 20:48:02 [01] ...done
210509 20:48:02 [01] Copying ./performance_schema/status_by_user.frm to /opt/data/performance_schema/status_by_user.frm
210509 20:48:02 [01] ...done
210509 20:48:02 [01] Copying ./performance_schema/status_by_host.frm to /opt/data/performance_schema/status_by_host.frm
210509 20:48:02 [01] ...done
210509 20:48:02 [01] Copying ./performance_schema/status_by_account.frm to /opt/data/performance_schema/status_by_account.frm
210509 20:48:02 [01] ...done
210509 20:48:02 [01] Copying ./performance_schema/global_status.frm to /opt/data/performance_schema/global_status.frm
210509 20:48:02 [01] ...done
210509 20:48:02 [01] Copying ./performance_schema/session_status.frm to /opt/data/performance_schema/session_status.frm
210509 20:48:02 [01] ...done
210509 20:48:02 [01] Copying ./gj/db.opt to /opt/data/gj/db.opt
210509 20:48:02 [01] ...done
210509 20:48:02 [01] Copying ./zzh/db.opt to /opt/data/zzh/db.opt
210509 20:48:02 [01] ...done
210509 20:48:02 [01] Copying ./ib_buffer_pool to /opt/data/ib_buffer_pool
210509 20:48:02 [01] ...done
210509 20:48:02 [01] Copying ./xtrabackup_binlog_pos_innodb to /opt/data/xtrabackup_binlog_pos_innodb
210509 20:48:02 [01] ...done
210509 20:48:02 [01] Copying ./xtrabackup_master_key_id to /opt/data/xtrabackup_master_key_id
210509 20:48:02 [01] ...done
210509 20:48:02 [01] Copying ./xtrabackup_info to /opt/data/xtrabackup_info
210509 20:48:02 [01] ...done
210509 20:48:02 [01] Copying ./ibtmp1 to /opt/data/ibtmp1
210509 20:48:02 [01] ...done
210509 20:48:02 completed OK!
[root@lzz /]# chown -R mysql.mysql /opt/data
[root@lzz /]# ll /opt/data
总用量 122924
drwxr-x---. 2 root root 20 5月 9 20:48 gj
-rw-r-----. 1 root root 669 5月 9 20:48 ib_buffer_pool
-rw-r-----. 1 root root 12582912 5月 9 20:48 ibdata1
-rw-r-----. 1 root root 50331648 5月 9 20:48 ib_logfile0
-rw-r-----. 1 root root 50331648 5月 9 20:48 ib_logfile1
-rw-r-----. 1 root root 12582912 5月 9 20:48 ibtmp1
drwxr-x---. 2 root root 76 5月 9 20:48 lzz
drwxr-x---. 2 root root 4096 5月 9 20:48 mysql
drwxr-x---. 2 root root 8192 5月 9 20:48 performance_schema
drwxr-x---. 2 root root 8192 5月 9 20:48 sys
-rw-r-----. 1 root root 21 5月 9 20:48 xtrabackup_binlog_pos_innodb
-rw-r-----. 1 root root 502 5月 9 20:48 xtrabackup_info
-rw-r-----. 1 root root 1 5月 9 20:48 xtrabackup_master_key_id
drwxr-x---. 2 root root 20 5月 9 20:48 zzh
[root@lzz /]# service mysqld start
Starting MySQL.Logging to '/opt/data/lzz.err'.
.. SUCCESS!
[root@lzz /]#
mysql> show databases;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 2
Current database: *** NONE ***
+--------------------+
| Database |
+--------------------+
| information_schema |
| gj |
| mysql |
| performance_schema |
| sys |
| zzh |
+--------------------+
6 rows in set (0.00 sec)
mysql> show databases;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 2
Current database: *** NONE ***
+--------------------+
| Database |
+--------------------+
| information_schema |
| gj |
| lzz |
| mysql |
| performance_schema |
| sys |
| zzh |
+--------------------+
7 rows in set (0.01 sec)
mysql> use lzz;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+---------------+
| Tables_in_lzz |
+---------------+
| lg |
| lp |
+---------------+
2 rows in set (0.00 sec)
mysql> select * from lp;
+------+-----------+------+
| id | name | age |
+------+-----------+------+
| 1 | xieer | 20 |
| 2 | chengling | 15 |
| 3 | wink | 29 |
| 4 | zzh | 30 |
| 5 | ljj | 31 |
| 6 | zhouxu | 25 |
| 7 | zky | 24 |
| 8 | fuwenduo | 24 |
| 9 | yangyuan | 23 |
| 10 | tangmo | 20 |
| 11 | xioasg | 24 |
| 12 | bz | 25 |
| 13 | tom | 26 |
| 14 | jerry | 23 |
+------+-----------+------+
14 rows in set (0.00 sec)