Skip to content


修复discuz误删分类

同事在discuz后台不小心将贴子分类全部删除。

解压今日凌晨的备份

cd /home/backup
tar -xvf discuz.tar
#discuz后台出公告后,关闭discuz
/opt/lemp stopmysql
#备份当前discuz
cd /opt/mysql/var
tar -cvf discuz090316.tar ./discuz
mkdir discuz2
chown mysql:mysql discuz2
mv /home/backup/opt/mysql/var/discuz/* ./discuz2/
/opt/lemp startmysql

#进入phpmyadmin
导出discuz2库的threadtypes结构的数据+droptable,导入discuz库
执行sql

update discuz.cdb_forumfields,discuz2.cdb_forumfields set discuz.cdb_forumfields.threadtypes=discuz2.cdb_forumfields.threadtypes where discuz.cdb_forumfields.fid=discuz2.cdb_forumfields.fid;

update discuz.cdb_threads,discuz2.cdb_threads set discuz.cdb_threads.typeid=discuz2.cdb_threads.typeid where discuz.cdb_threads.tid=discuz2.cdb_threads.tid;


完成

Posted in Mysql, 技术.

Tagged with , .


No Responses (yet)

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.



Some HTML is OK

or, reply to this post via trackback.