mysql数据还原
一、表结构还原
1.方案一:使用mysqlfrm 工具(推荐)
由于mysqlfrm是mysql-utilities工具一部分,那么我们安装mysql-utilities即可,下载好对应的源码包,进行编译安装
shell> wget https://cdn.mysql.com/archives/mysql-utilities/mysql-utilities-1.6.5.tar.gz
shell> tar -xvzf mysql-utilities-1.6.4.tar.gz
shell> cd mysql-utilities-1.6.4
shell> python ./setup.py build
shell> python ./setup.py install
用–help 可看mysqlfrm 使用帮助
mysqlfrm --server=root:root@127.0.0.1:3306 /root/databases_backup_20200530162626/dd20/order.frm --port=3434 --user=mysql --diagnostic
执行上面语句,会得到下面结果
WARNING: Using a password on the command line interface can be insecure.
# WARNING The --port option is not used in the --diagnostic mode.
# WARNING: The --user option is only used for the default mode.
# Source on 127.0.0.1: ... connected.
# CAUTIO