•  
     

phpBB3 - Alterando IINNODB para MyISAM e MyISAM para IINNODB

IINNODB to MyISAM

Código: Selecionar todos

ALTER TABLE phpbb_acl_groups ENGINE=MyISAM;
ALTER TABLE phpbb_acl_options ENGINE=MyISAM;
ALTER TABLE phpbb_acl_roles ENGINE=MyISAM;
ALTER TABLE phpbb_acl_roles_data ENGINE=MyISAM;
ALTER TABLE phpbb_acl_users ENGINE=MyISAM;
ALTER TABLE phpbb_attachments ENGINE=MyISAM;
ALTER TABLE phpbb_banlist ENGINE=MyISAM;
ALTER TABLE phpbb_bbcodes ENGINE=MyISAM;
ALTER TABLE phpbb_bookmarks ENGINE=MyISAM;
ALTER TABLE phpbb_bots ENGINE=MyISAM;
ALTER TABLE phpbb_config ENGINE=MyISAM;
ALTER TABLE phpbb_confirm ENGINE=MyISAM;
ALTER TABLE phpbb_disallow ENGINE=MyISAM;
ALTER TABLE phpbb_drafts ENGINE=MyISAM;
ALTER TABLE phpbb_extensions ENGINE=MyISAM;
ALTER TABLE phpbb_extension_groups ENGINE=MyISAM;
ALTER TABLE phpbb_forums ENGINE=MyISAM;
ALTER TABLE phpbb_forums_access ENGINE=MyISAM;
ALTER TABLE phpbb_forums_track ENGINE=MyISAM;
ALTER TABLE phpbb_forums_watch ENGINE=MyISAM;
ALTER TABLE phpbb_groups ENGINE=MyISAM;
ALTER TABLE phpbb_icons ENGINE=MyISAM;
ALTER TABLE phpbb_lang ENGINE=MyISAM;
ALTER TABLE phpbb_log ENGINE=MyISAM;
ALTER TABLE phpbb_login_attempts ENGINE=MyISAM;
ALTER TABLE phpbb_moderator_cache ENGINE=MyISAM;
ALTER TABLE phpbb_modules ENGINE=MyISAM;
ALTER TABLE phpbb_poll_options ENGINE=MyISAM;
ALTER TABLE phpbb_poll_votes ENGINE=MyISAM;
ALTER TABLE phpbb_posts ENGINE=MyISAM;
ALTER TABLE phpbb_privmsgs ENGINE=MyISAM;
ALTER TABLE phpbb_privmsgs_folder ENGINE=MyISAM;
ALTER TABLE phpbb_privmsgs_rules ENGINE=MyISAM;
ALTER TABLE phpbb_privmsgs_to ENGINE=MyISAM;
ALTER TABLE phpbb_profile_fields ENGINE=MyISAM;
ALTER TABLE phpbb_profile_fields_data ENGINE=MyISAM;
ALTER TABLE phpbb_profile_fields_lang ENGINE=MyISAM;
ALTER TABLE phpbb_profile_lang ENGINE=MyISAM;
ALTER TABLE phpbb_ranks ENGINE=MyISAM;
ALTER TABLE phpbb_reports ENGINE=MyISAM;
ALTER TABLE phpbb_reports_reasons ENGINE=MyISAM;
ALTER TABLE phpbb_search_results ENGINE=MyISAM;
ALTER TABLE phpbb_search_wordlist ENGINE=MyISAM;
ALTER TABLE phpbb_search_wordmatch ENGINE=MyISAM;
ALTER TABLE phpbb_sessions ENGINE=MyISAM;
ALTER TABLE phpbb_sessions_keys ENGINE=MyISAM;
ALTER TABLE phpbb_sitelist ENGINE=MyISAM;
ALTER TABLE phpbb_smilies ENGINE=MyISAM;
ALTER TABLE phpbb_styles ENGINE=MyISAM;
ALTER TABLE phpbb_styles_imageset ENGINE=MyISAM;
ALTER TABLE phpbb_styles_imageset_data ENGINE=MyISAM;
ALTER TABLE phpbb_styles_template ENGINE=MyISAM;
ALTER TABLE phpbb_styles_template_data ENGINE=MyISAM;
ALTER TABLE phpbb_styles_theme ENGINE=MyISAM;
ALTER TABLE phpbb_topics ENGINE=MyISAM;
ALTER TABLE phpbb_topics_posted ENGINE=MyISAM;
ALTER TABLE phpbb_topics_track ENGINE=MyISAM;
ALTER TABLE phpbb_topics_watch ENGINE=MyISAM;
ALTER TABLE phpbb_users ENGINE=MyISAM;
ALTER TABLE phpbb_user_group ENGINE=MyISAM;
ALTER TABLE phpbb_warnings ENGINE=MyISAM;
ALTER TABLE phpbb_words ENGINE=MyISAM;
ALTER TABLE phpbb_zebra ENGINE=MyISAM;






MyISAM para INNODB

Código: Selecionar todos

ALTER TABLE phpbb_acl_groups ENGINE=INNODB;
ALTER TABLE phpbb_acl_options ENGINE=INNODB;
ALTER TABLE phpbb_acl_roles ENGINE=INNODB;
ALTER TABLE phpbb_acl_roles_data ENGINE=INNODB;
ALTER TABLE phpbb_acl_users ENGINE=INNODB;
ALTER TABLE phpbb_attachments ENGINE=INNODB;
ALTER TABLE phpbb_banlist ENGINE=INNODB;
ALTER TABLE phpbb_bbcodes ENGINE=INNODB;
ALTER TABLE phpbb_bookmarks ENGINE=INNODB;
ALTER TABLE phpbb_bots ENGINE=INNODB;
ALTER TABLE phpbb_config ENGINE=INNODB;
ALTER TABLE phpbb_confirm ENGINE=INNODB;
ALTER TABLE phpbb_disallow ENGINE=INNODB;
ALTER TABLE phpbb_drafts ENGINE=INNODB;
ALTER TABLE phpbb_extensions ENGINE=INNODB;
ALTER TABLE phpbb_extension_groups ENGINE=INNODB;
ALTER TABLE phpbb_forums ENGINE=INNODB;
ALTER TABLE phpbb_forums_access ENGINE=INNODB;
ALTER TABLE phpbb_forums_track ENGINE=INNODB;
ALTER TABLE phpbb_forums_watch ENGINE=INNODB;
ALTER TABLE phpbb_groups ENGINE=INNODB;
ALTER TABLE phpbb_icons ENGINE=INNODB;
ALTER TABLE phpbb_lang ENGINE=INNODB;
ALTER TABLE phpbb_log ENGINE=INNODB;
ALTER TABLE phpbb_login_attempts ENGINE=INNODB;
ALTER TABLE phpbb_moderator_cache ENGINE=INNODB;
ALTER TABLE phpbb_modules ENGINE=INNODB;
ALTER TABLE phpbb_poll_options ENGINE=INNODB;
ALTER TABLE phpbb_poll_votes ENGINE=INNODB;
ALTER TABLE phpbb_posts ENGINE=INNODB;
ALTER TABLE phpbb_privmsgs ENGINE=INNODB;
ALTER TABLE phpbb_privmsgs_folder ENGINE=INNODB;
ALTER TABLE phpbb_privmsgs_rules ENGINE=INNODB;
ALTER TABLE phpbb_privmsgs_to ENGINE=INNODB;
ALTER TABLE phpbb_profile_fields ENGINE=INNODB;
ALTER TABLE phpbb_profile_fields_data ENGINE=INNODB;
ALTER TABLE phpbb_profile_fields_lang ENGINE=INNODB;
ALTER TABLE phpbb_profile_lang ENGINE=INNODB;
ALTER TABLE phpbb_ranks ENGINE=INNODB;
ALTER TABLE phpbb_reports ENGINE=INNODB;
ALTER TABLE phpbb_reports_reasons ENGINE=INNODB;
ALTER TABLE phpbb_search_results ENGINE=INNODB;
ALTER TABLE phpbb_search_wordlist ENGINE=INNODB;
ALTER TABLE phpbb_search_wordmatch ENGINE=INNODB;
ALTER TABLE phpbb_sessions ENGINE=INNODB;
ALTER TABLE phpbb_sessions_keys ENGINE=INNODB;
ALTER TABLE phpbb_sitelist ENGINE=INNODB;
ALTER TABLE phpbb_smilies ENGINE=INNODB;
ALTER TABLE phpbb_styles ENGINE=INNODB;
ALTER TABLE phpbb_styles_imageset ENGINE=INNODB;
ALTER TABLE phpbb_styles_imageset_data ENGINE=INNODB;
ALTER TABLE phpbb_styles_template ENGINE=INNODB;
ALTER TABLE phpbb_styles_template_data ENGINE=INNODB;
ALTER TABLE phpbb_styles_theme ENGINE=INNODB;
ALTER TABLE phpbb_topics ENGINE=INNODB;
ALTER TABLE phpbb_topics_posted ENGINE=INNODB;
ALTER TABLE phpbb_topics_track ENGINE=INNODB;
ALTER TABLE phpbb_topics_watch ENGINE=INNODB;
ALTER TABLE phpbb_users ENGINE=INNODB;
ALTER TABLE phpbb_user_group ENGINE=INNODB;
ALTER TABLE phpbb_warnings ENGINE=INNODB;
ALTER TABLE phpbb_words ENGINE=INNODB;
ALTER TABLE phpbb_zebra ENGINE=INNODB;