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 , .

rev="post-414" No comments

By C1G – 2009/03/16

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.

« »