How to copy the two modules configured in database a to database B ​

There are two ways

The first: through the Microi application store ​

project a uploads the database package to the application mall, and project B downloads and installs the application in the application mall. this method is not recommend for the time being. one is the upload audit problem, and the other is that the application mall system is not perfect yet.

type 2: extract relevant SQL statements by Navicat ​

2.1, get diy_table table data

select * from diy_table WHERE `Name` IN ('diy_lang', 'diy_project') AND IsDeleted=0

2.2, and then extract the insert statement as shown in the figure (select all data, copy the right mouse button as-> insert statement)

2.3. put the SQL statement into database B for execution (note that the database name after INSERT INTO should be removed.)

the above three steps, through the following SQL to obtain the data and then do it twice, the method is the same

//获取上面两张表的所有字段数据
select * from diy_field WHERE TableID IN(select Id from  diy_table WHERE `Name` IN ('diy_lang', 'diy_project') AND IsDeleted=0) AND IsDeleted=0
//获取模块引擎数据（用于复制模块）
select * from sys_menu where `Name` In('多语言管理', '项目管理')

recently, remember to go to the role management office to set up the menu module permissions corresponding to [multi-language management] and [project management] for the account.