加快 7.2 升级 X2 的速度

通常情况下，由于 cdb_posts  和 cdb_threads 还有 cdb_attachments 是所有表中数据最大的。
所以升级的时候大部分时间也都花在了 cdb_posts  和 cdb_threads 和 cdb_attachments 表上。

那么可以在升级的时候，到升级页面勾选数据库表的这一步，将  cdb_posts  cdb_threads  threadsattachments 表前面的勾去掉。然后升级其他表。

然后使用SQL语句把老数据导入到新表来，注意下面的x2是x2的数据库名字，dz72的老的7.2的数据库名字

1. INSERT INTO x2.pre_forum_thread (tid,fid,typeid,sortid,readperm,price,author,authorid,subject,dateline,lastpost,lastposter,views,replies,displayorder,highlight,digest,rate,special,attachment,moderated,closed,recommends,recommend_add,recommend_sub,heats,status) (SELECT tid,fid,typeid,sortid,readperm,price,author,authorid,subject,dateline,lastpost,lastposter,views,replies,displayorder,highlight,digest,rate,special,attachment,moderated,closed,recommends,recommend_add,recommend_sub,heats,status FROM dz72.cdb_threads);
   
2. 
   
3. INSERT INTO x2.pre_forum_post (pid,fid,tid,first,author,authorid,subject,dateline,message,useip,invisible,anonymous,usesig,htmlon,bbcodeoff,smileyoff,parseurloff,attachment,rate,ratetimes,status) (select pid,fid,tid,first,author,authorid,subject,dateline,message,useip,invisible,anonymous,usesig,htmlon,bbcodeoff,smileyoff,parseurloff,attachment,rate,ratetimes,status FROM dz72.cdb_posts);

复制代码

修复pre_forum_post_tableid

找到现在 pre_forum_post  表最大的 pid

1. SELECT max( pid ) FROM `pre_forum_post`;

复制代码

将得到的最大 pid 加 1 后，执行SQL
（假如刚才查到的数值是1001)

1. ALTER TABLE  `pre_forum_post_tableid` AUTO_INCREMENT=1001+1;

复制代码

附件分表部分：
执行以下SQL，同样x2是x2的数据库名字，dz72的老的7.2的数据库名字

1. TRUNCATE pre_forum_attachment;
   
2. TRUNCATE pre_forum_threadimage;
   
3. TRUNCATE pre_forum_attachment_0;
   
4. TRUNCATE pre_forum_attachment_1;
   
5. TRUNCATE pre_forum_attachment_2;
   
6. TRUNCATE pre_forum_attachment_3;
   
7. TRUNCATE pre_forum_attachment_4;
   
8. TRUNCATE pre_forum_attachment_5;
   
9. TRUNCATE pre_forum_attachment_6;
   
10. TRUNCATE pre_forum_attachment_7;
    
11. TRUNCATE pre_forum_attachment_8;
    
12. TRUNCATE pre_forum_attachment_9;
    
13. REPLACE INTO pre_forum_attachment (aid,tid,pid,uid,downloads)(SELECT aid,tid,pid,uid,downloads FROM dz72.cdb_attachments);
    
14. UPDATE pre_forum_attachment SET tableid='0' where tid % 10 = 0;
    
15. UPDATE pre_forum_attachment SET tableid='1' where tid % 10 = 1;
    
16. UPDATE pre_forum_attachment SET tableid='2' where tid % 10 = 2;
    
17. UPDATE pre_forum_attachment SET tableid='3' where tid % 10 = 3;
    
18. UPDATE pre_forum_attachment SET tableid='4' where tid % 10 = 4;
    
19. UPDATE pre_forum_attachment SET tableid='5' where tid % 10 = 5;
    
20. UPDATE pre_forum_attachment SET tableid='6' where tid % 10 = 6;
    
21. UPDATE pre_forum_attachment SET tableid='7' where tid % 10 = 7;
    
22. UPDATE pre_forum_attachment SET tableid='8' where tid % 10 = 8;
    
23. UPDATE pre_forum_attachment SET tableid='9' where tid % 10 = 9;
    
24. REPLACE INTO pre_forum_attachment_0 (aid,tid,pid,uid,dateline,filename,filesize,attachment,remote,description,readperm,price,isimage,width,thumb)(SELECT a.aid,a.tid,a.pid,a.uid,a.dateline,a.filename,a.filesize,a.attachment,a.remote,af.description,a.readperm,a.price,a.isimage,a.width,a.thumb FROM dz72.cdb_attachments a LEFT JOIN dz72.cdb_attachmentfields af USING(aid) WHERE  a.tid % 10 = 0);
    
25. REPLACE INTO pre_forum_attachment_1 (aid,tid,pid,uid,dateline,filename,filesize,attachment,remote,description,readperm,price,isimage,width,thumb)(SELECT a.aid,a.tid,a.pid,a.uid,a.dateline,a.filename,a.filesize,a.attachment,a.remote,af.description,a.readperm,a.price,a.isimage,a.width,a.thumb FROM dz72.cdb_attachments a LEFT JOIN dz72.cdb_attachmentfields af USING(aid) WHERE  a.tid % 10 = 1);
    
26. REPLACE INTO pre_forum_attachment_2 (aid,tid,pid,uid,dateline,filename,filesize,attachment,remote,description,readperm,price,isimage,width,thumb)(SELECT a.aid,a.tid,a.pid,a.uid,a.dateline,a.filename,a.filesize,a.attachment,a.remote,af.description,a.readperm,a.price,a.isimage,a.width,a.thumb FROM dz72.cdb_attachments a LEFT JOIN dz72.cdb_attachmentfields af USING(aid) WHERE  a.tid % 10 = 2);
    
27. REPLACE INTO pre_forum_attachment_3 (aid,tid,pid,uid,dateline,filename,filesize,attachment,remote,description,readperm,price,isimage,width,thumb)(SELECT a.aid,a.tid,a.pid,a.uid,a.dateline,a.filename,a.filesize,a.attachment,a.remote,af.description,a.readperm,a.price,a.isimage,a.width,a.thumb FROM dz72.cdb_attachments a LEFT JOIN dz72.cdb_attachmentfields af USING(aid) WHERE  a.tid % 10 = 3);
    
28. REPLACE INTO pre_forum_attachment_4 (aid,tid,pid,uid,dateline,filename,filesize,attachment,remote,description,readperm,price,isimage,width,thumb)(SELECT a.aid,a.tid,a.pid,a.uid,a.dateline,a.filename,a.filesize,a.attachment,a.remote,af.description,a.readperm,a.price,a.isimage,a.width,a.thumb FROM dz72.cdb_attachments a LEFT JOIN dz72.cdb_attachmentfields af USING(aid) WHERE  a.tid % 10 = 4);
    
29. REPLACE INTO pre_forum_attachment_5 (aid,tid,pid,uid,dateline,filename,filesize,attachment,remote,description,readperm,price,isimage,width,thumb)(SELECT a.aid,a.tid,a.pid,a.uid,a.dateline,a.filename,a.filesize,a.attachment,a.remote,af.description,a.readperm,a.price,a.isimage,a.width,a.thumb FROM dz72.cdb_attachments a LEFT JOIN dz72.cdb_attachmentfields af USING(aid) WHERE  a.tid % 10 = 5);
    
30. REPLACE INTO pre_forum_attachment_6 (aid,tid,pid,uid,dateline,filename,filesize,attachment,remote,description,readperm,price,isimage,width,thumb)(SELECT a.aid,a.tid,a.pid,a.uid,a.dateline,a.filename,a.filesize,a.attachment,a.remote,af.description,a.readperm,a.price,a.isimage,a.width,a.thumb FROM dz72.cdb_attachments a LEFT JOIN dz72.cdb_attachmentfields af USING(aid) WHERE  a.tid % 10 = 6);
    
31. REPLACE INTO pre_forum_attachment_7 (aid,tid,pid,uid,dateline,filename,filesize,attachment,remote,description,readperm,price,isimage,width,thumb)(SELECT a.aid,a.tid,a.pid,a.uid,a.dateline,a.filename,a.filesize,a.attachment,a.remote,af.description,a.readperm,a.price,a.isimage,a.width,a.thumb FROM dz72.cdb_attachments a LEFT JOIN dz72.cdb_attachmentfields af USING(aid) WHERE  a.tid % 10 = 7);
    
32. REPLACE INTO pre_forum_attachment_8 (aid,tid,pid,uid,dateline,filename,filesize,attachment,remote,description,readperm,price,isimage,width,thumb)(SELECT a.aid,a.tid,a.pid,a.uid,a.dateline,a.filename,a.filesize,a.attachment,a.remote,af.description,a.readperm,a.price,a.isimage,a.width,a.thumb FROM dz72.cdb_attachments a LEFT JOIN dz72.cdb_attachmentfields af USING(aid) WHERE  a.tid % 10 = 8);
    
33. REPLACE INTO pre_forum_attachment_9 (aid,tid,pid,uid,dateline,filename,filesize,attachment,remote,description,readperm,price,isimage,width,thumb)(SELECT a.aid,a.tid,a.pid,a.uid,a.dateline,a.filename,a.filesize,a.attachment,a.remote,af.description,a.readperm,a.price,a.isimage,a.width,a.thumb FROM dz72.cdb_attachments a LEFT JOIN dz72.cdb_attachmentfields af USING(aid) WHERE  a.tid % 10 = 9);
    
34. REPLACE INTO pre_forum_threadimage (tid,attachment,remote) (SELECT tid,attachment,remote FROM dz72.cdb_attachments WHERE isimage <> 0 and dateline > 1293811200 group by tid);

复制代码

这样，数据库最大的3个表就直接通过SQL导入到了X2的表里面，其他的操作按正常升级操作即可，如果页面显示不正常，可以到后台更新下缓存。

支持下了哦

支持、支持、哈哈

了然~O了

好方法！加快速度！

最后一条sql语句中 dateline > 1293811200 是啥意思呀？希望不吝赐教~

谢谢管理员，很快。
昨天发现的那些错误原来是升级后后台转换的问题

非常感谢{:soso_e182:}