Mysql数据库导出导入
1.在服务上安装mysql:mysql> yum install -y mysql
2.打开授权:mysql> GRANT PROCESS ON . TO ‘bii_budget’@‘10.99.205.165’;
3.备份到.sql文件: mysqldump --opt --single-transaction -ubii_budget -p"X&VKaIt5mueM" -h10.99.205.165 -P3307 --default-character-set=utf8 budget > budget.20220606.sql;
4.导入新的服务器上:
create database dmc;
use dmc;
source budget.20220606.sql;