转换用户数据,语法正确,但转换后密码不对了。
insert into `carbon_users`(`ID`,`UserName`,`Salt`,`Password`,`UserMail`,`UserRegTime`,`LastLoginTime`)
select `uid`,`username`,`salt`,`email`,`password`,`regdate`,`lastlogintime` from `bbs_ucenter_members`
转换论坛帖子数据
insert into `carbon_posts`(`ID`,`TopicID`,`UserID`,`UserName`,`Subject`,`Content`,`PostIP`,`PostTime`)
select `pid`,`tid`,`authorid`,`author`,`subject`,`message`,`useip`,`dateline` from `bbs_forum_post`
转换论坛话题数据
insert into `carbon_topics`(`ID`,`Topic`,`Tags`,`UserID`,`UserName`,`LastName`,`PostTime`,`LastTime`,`LastViewedTime`,`ListsTime`)
select `tid`,`subject`,`fid`,`authorid`,`author`,`lastposter`,`dateline`,`lastpost`,`lastpost`,`dateline` from `bbs_forum_thread`
转换论坛标签数据
insert into `carbon_tags`(`ID`,`Name`,`TotalPosts`,`MostRecentPostTime`,`DateCreated`)
select `fid`,`name`,`posts`,`rank`,`rank` from `laobird`.`bbs_forum_forum` WHERE fup='2'
- 本文固定链接: https://www.fengshen.cn/2017/01/discuz数据转换到carbon/etcofwind/
- 转载请注明: fengshen 发表于 Dream of Wind | 一梦风神
