mysql5.7使用mysqldumper数据库导入导出备份迁移数据

MySQL 5.7安装

一、下载MySQL的repo源

wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
安装MySQL源
rpm -ivh mysql57-community-release-el7-8.noarch.rpm
使用yum安装mysql-server(这个过程可能要30分钟左右)
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
yum -y install mysql-server

二、数据库配置

1、启动MySQL：

	systemctl start mysqld.service

2、查找数据库root用户的 临时密码：

 grep "password" /var/log/mysqld.log

使用临时密码进入数据库：mysql -uroot -p
如果不修改密码，会有如下报错

mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

调整密码：

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '****';

MySQL 操作命令

启动: systemctl start mysqld.service
重启: systemctl restart mysqld.service
停止: systemctl stop mysqld.service
状态: systemctl status mysqld.service
设置MySQL开机启动: systemctl enable mysqld.service
停止MySQL开机启动: systemctl disable mysqld.service

Mydumper 工具安装

2、安装依赖

mydumper安装所依赖的软件包，glibc, zlib, pcre, pcre-devel, gcc, gcc-c++, cmake, make, mysql客户端库文件

[root@mysql-150 ~]# yum -y install glib2-devel mysql-devel zlib-devel pcre-devel zlib gcc-c++ gcc cmake
[root@mysql-150 ~]# wget https://launchpad.net/mydumper/0.9/0.9.1/+download/mydumper-0.9.1.tar.gz
[root