mysql 整库迁移

Last updated on September 15, 2024 pm

🧙 Questions

使用mysqldump迁移mysql数据库

☄️ Ideas

下载并安装 mysql workbanch
创建目标数据源
create database leo_migrate_db;
数据导出

20220706142316

20220706142448

  • mysqldump命令位置: C:/Program Files/MySQL/MySQL Workbench 8.0 CE/mysqldump.exe
  • 导出位置: C:\Users\ispon\Desktop\{data_source}-{timestamp}-dump.sql

20220706142513

20220706142537

数据导入

20220706142623

20220706142728

  • mysql命令位置: C:/Program Files/MySQL/MySQL Workbench 8.0 CE/mysql.exe
  • dump文件位置: C:\Users\ispon\Desktop\leo_dev-2022_07_06_14_24_55-dump.sql

NOTE:
没有消息提示，只能看进度条

20220706142905

20220706142930

mysql
mysql 整库迁移
https://ispong.isxcode.com/db/mysql/mysql 整库迁移/
Author
ispong
Posted on
July 6, 2022
Licensed under