Data Migration

Prerequisites

RuoYi data has been imported to the source MySQL database. You can log in to the MySQL database and run the following command to import the file:

mysql> create database ry;
mysql> use ry;
mysql> source /path/ry_20240601.sql
mysql> source /path/quartz.sql

/path: path for storing the .sql file. Replace it with the actual one. The .sql file is stored in the RuoYi-master/sql path generated after decompressing RuoYi-master.zip.

Procedure

1. View the migration report and click View Details.

   

2. Enable the DM database firewall port based on the verification method.

   

3. Log in to the database migration tool. For details about the user name and password, see the Online Help in Tips.

   

4. Enter the user name and password to log in to the DM management system.

   

5. Create a migration project, set the project name to devkit, and click OK.

   

   

6. Select MySQL==>DM and click Next.

   

7. Enter the source database information and click Next.

   

8. Enter the DM database information and click Next.

   

9. Select Keep Case and click Next.

   

10. Select the source database ry and click Next.

    

11. Select all tables and click Next.

    

12. View the migration details and click Next.

    

    When the progress reaches 100%, the migration is complete.