auto_increment丢失的解决办法

把mysql5.0的数据通过mysqldump的方法导入到mysql4.1以下的版本的时候数据表的 auto_increment会丢失，这样就会导致无法发表主题，无法注册等等。错误现象如下：

解决办法：
1:就是把各个字段的auto_increment属性再增加上，在phpmyadmin， 论坛后台的数据库升级或者mysql的控制台运行下面的sql语句：

1. ALTER TABLE `cdb_adminnotes` CHANGE `id` `id` MEDIUMINT( 8 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
2. ALTER TABLE `cdb_advertisements` CHANGE `advid` `advid` MEDIUMINT( 8 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
3. ALTER TABLE `cdb_announcements` CHANGE `id` `id` SMALLINT( 6 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
4. ALTER TABLE `cdb_attachments` CHANGE `aid` `aid` MEDIUMINT( 8 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
5. ALTER TABLE `cdb_attachtypes` CHANGE `id` `id` SMALLINT( 6 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
6. ALTER TABLE `cdb_banned` CHANGE `id` `id` SMALLINT( 6 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
7. ALTER TABLE `cdb_bbcodes` CHANGE `id` `id` MEDIUMINT( 8 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
8. ALTER TABLE `cdb_crons` CHANGE `cronid` `cronid` SMALLINT( 6 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
9. ALTER TABLE `cdb_forumlinks` CHANGE `id` `id` SMALLINT( 6 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
10. ALTER TABLE `cdb_forums` CHANGE `fid` `fid` SMALLINT( 6 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
11. ALTER TABLE `cdb_medals` CHANGE `medalid` `medalid` SMALLINT( 6 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
12. ALTER TABLE `cdb_members` CHANGE `uid` `uid` MEDIUMINT( 8 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
13. ALTER TABLE `cdb_pluginhooks` CHANGE `pluginhookid` `pluginhookid` MEDIUMINT( 8 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
14. ALTER TABLE `cdb_plugins` CHANGE `pluginid` `pluginid` SMALLINT( 6 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
15. ALTER TABLE `cdb_pluginvars` CHANGE `pluginvarid` `pluginvarid` MEDIUMINT( 8 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
16. ALTER TABLE `cdb_pms` CHANGE `pmid` `pmid` INT( 10 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
17. ALTER TABLE `cdb_pmsearchindex` CHANGE `searchid` `searchid` INT( 10 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
18. ALTER TABLE `cdb_posts` CHANGE `pid` `pid` INT( 10 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
19. ALTER TABLE `cdb_profilefields` CHANGE `fieldid` `fieldid` SMALLINT( 6 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
20. ALTER TABLE `cdb_ranks` CHANGE `rankid` `rankid` SMALLINT( 6 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
21. ALTER TABLE `cdb_searchindex` CHANGE `searchid` `searchid` INT( 10 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
22. ALTER TABLE `cdb_smilies` CHANGE `id` `id` SMALLINT( 6 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
23. ALTER TABLE `cdb_styles` CHANGE `styleid` `styleid` SMALLINT( 6 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
24. ALTER TABLE `cdb_stylevars` CHANGE `stylevarid` `stylevarid` SMALLINT( 6 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
25. ALTER TABLE `cdb_templates` CHANGE `templateid` `templateid` SMALLINT( 6 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
26. ALTER TABLE `cdb_threads` CHANGE `tid` `tid` MEDIUMINT( 8 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
27. ALTER TABLE `cdb_threadtypes` CHANGE `typeid` `typeid` SMALLINT( 6 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
28. ALTER TABLE `cdb_usergroups` CHANGE `groupid` `groupid` SMALLINT( 6 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
29. ALTER TABLE `cdb_words` CHANGE `id` `id` SMALLINT( 6 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;

复制代码

如果你装有supesite还需要运行下面的语句：

1. ALTER TABLE `supe_attachments` CHANGE `aid` `aid` MEDIUMINT( 8 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
2. ALTER TABLE `supe_categories` CHANGE `catid` `catid` SMALLINT( 6 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
3. ALTER TABLE `supe_crons` CHANGE `cronid` `cronid` SMALLINT( 6 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
4. ALTER TABLE `supe_spacecomments` CHANGE `cid` `cid` INT( 10 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
5. ALTER TABLE `supe_spaceitems` CHANGE `itemid` `itemid` MEDIUMINT( 8 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;
6. ALTER TABLE `supe_tags` CHANGE `tagid` `tagid` MEDIUMINT( 8 ) UNSIGNED NULL DEFAULT NULL AUTO_INCREMENT;

复制代码

有些讨厌AUTO_INCREMENT了

phpmyadmin 记住了。

谢了，很不错的，楼主辛苦了。:) :)

如题。具体在哪设啊。

原帖由 hprenj 于 2008-2-20 18:56 发表
如题。具体在哪设啊。

后台-其它设置那里看看.

:) :) 收藏了。。。。

用上了.......

试试看

不错，耗用啊！










中国站长论坛：www.hotwzw.cn（全国站长扎堆的地方!）