同事在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;完成
No Responses (yet)
Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.