将discuz数据表存储引擎从MYISAM转换成INNODB

2013年10月11日 分类: Discuz, Mysql (901 个脚步)

由于看上了innodb的行锁对论坛的优越性,所以就手动的将discuz的数据表更换掉。

我们需要将当前需要转换的数据库备份一遍,以防中途出现以外或者不想用了直接覆盖回去。

下面就开始转换工作。

首先登录进mysql 的控制台

mysql -u root -p

输入数据密码

然后切换到论坛所用的数据库

use discuz;

显示所有表名

show tables;

复制所有列出来的表名
然后在表名前面加上

ALTER IGNORE TABLE

后面加上

 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

合起来就是类似这样的

ALTER IGNORE TABLE uc_admins CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

然后执行所有语句,数据表的引擎就修改好了
不过还有一个别忘记了 就是本身数据库的引擎

ALTER DATABASE discuz DEFAULT CHARACTER SET utf8;

附上discuzX2 的数据库转换代码

ALTER DATABASE discuz DEFAULT CHARACTER SET utf8;
ALTER IGNORE TABLE pre_activity_pinnedsites CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_addon CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_admincp_cmenu CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_admincp_group CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_admincp_member CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_admincp_perm CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_admincp_session CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_admingroup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_adminnote CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_advertisement CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_advertisement_custom CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_banned CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_block CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_block_favorite CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_block_item CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_block_item_data CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_block_permission CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_block_pic CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_block_style CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_block_xml CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_cache CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_card CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_card_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_card_type CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_credit_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_credit_rule CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_credit_rule_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_credit_rule_log_field CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_cron CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_district CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_diy_data CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_domain CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_failedlogin CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_friendlink CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_grouppm CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_invite CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_magic CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_magiclog CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_mailcron CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_mailqueue CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_member CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_member_action_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_member_connect CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_member_count CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_member_field_forum CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_member_field_home CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_member_grouppm CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_member_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_member_magic CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_member_profile CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_member_profile_setting CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_member_security CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_member_stat_field CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_member_stat_fieldcache CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_member_stat_search CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_member_stat_searchcache CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_member_status CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_member_validate CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_member_verify CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_member_verify_info CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_moderate CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_myapp CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_myinvite CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_mytask CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_nav CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_onlinetime CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_plugin CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_pluginvar CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_process CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_regip CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_relatedlink CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_report CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_searchindex CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_secquestion CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_session CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_setting CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_smiley CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_sphinxcounter CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_stat CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_statuser CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_style CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_stylevar CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_syscache CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_tag CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_tagitem CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_task CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_taskvar CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_template CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_template_block CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_template_permission CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_uin_black CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_usergroup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_usergroup_field CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_word CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_common_word_type CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_connect_feedlog CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_connect_memberbindlog CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_connect_tlog CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_access CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_activity CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_activityapply CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_announcement CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_attachment CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_attachment_0 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_attachment_1 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_attachment_2 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_attachment_3 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_attachment_4 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_attachment_5 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_attachment_6 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_attachment_7 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_attachment_8 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_attachment_9 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_attachment_unused CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_attachtype CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_bbcode CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_creditslog CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_debate CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_debatepost CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_faq CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_forum CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_forum_threadtable CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_forumfield CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_forumrecommend CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_groupcreditslog CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_groupfield CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_groupinvite CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_grouplevel CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_groupranking CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_groupuser CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_imagetype CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_medal CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_medallog CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_memberrecommend CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_moderator CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_modwork CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_onlinelist CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_optionvalue391 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_optionvalue393 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_optionvalue394 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_order CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_poll CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_polloption CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_pollvoter CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_post CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_post_tableid CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_postcomment CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_postlog CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_postposition CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_poststick CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_promotion CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_ratelog CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_read CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_relatedthread CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_replycredit CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_rsscache CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_spacecache CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_statlog CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_thread CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_threadclass CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_threadimage CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_threadlog CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_threadmod CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_threadpartake CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_threadrush CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_threadtype CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_trade CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_tradecomment CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_tradelog CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_typeoption CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_typeoptionvar CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_typevar CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_forum_warning CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_album CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_album_category CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_appcreditlog CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_blacklist CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_blog CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_blog_category CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_blogfield CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_class CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_click CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_clickuser CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_comment CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_docomment CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_doing CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_favorite CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_feed CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_feed_app CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_friend CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_friend_request CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_friendlog CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_notification CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_pic CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_picfield CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_poke CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_pokearchive CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_share CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_show CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_specialuser CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_userapp CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_userappfield CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_viewlog CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_home_visitor CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_myrepeats CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_portal_article_apps CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_portal_article_content CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_portal_article_count CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_portal_article_related CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_portal_article_title CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_portal_article_trash CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_portal_attachment CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_portal_category CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_portal_category_permission CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_portal_comment CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_portal_rsscache CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_portal_topic CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_portal_topic_pic CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_security_evilpost CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_security_eviluser CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_security_failedlog CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_stopspam_thread CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE pre_stopspam_user CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_admins CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_applications CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_badwords CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_domains CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_failedlogins CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_feeds CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_friends CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_mailqueue CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_memberfields CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_members CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_mergemembers CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_newpm CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_notelist CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_pm_indexes CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_pm_lists CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_pm_members CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_pm_messages_0 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_pm_messages_1 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_pm_messages_2 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_pm_messages_3 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_pm_messages_4 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_pm_messages_5 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_pm_messages_6 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_pm_messages_7 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_pm_messages_8 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_pm_messages_9 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_pms CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_protectedmembers CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_settings CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_sqlcache CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_tags CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER IGNORE TABLE uc_vars CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

后记

由于discuzX2.5使用了联合主键,所以不能通过单修改数据库引擎的方式来实现。
如果确实想使用,可以参考下康盛出的扩展框架 和 innodb补丁

将discuz数据表存储引擎从MYISAM转换成INNODB 【声明】本文 将discuz数据表存储引擎从MYISAM转换成INNODB 为柠之漠然原创文章,转载请注明出自 枫之落叶
并保留本文有效链接:https://blog.shiniv.com/2013/10/%e5%b0%86discuz%e6%95%b0%e6%8d%ae%e8%a1%a8%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e%e4%bb%8emyisam%e8%bd%ac%e6%8d%a2%e6%88%90innodb/ , 转载请保留本声明!

标签:
目前还没有任何评论.
你必须要启用 Javascript