Home Newest Hot Active Unanswered Views Votes Tags Rank
 
Anderson

Converting MyISAM to InnoDB or InnoDB to MyISAM - phpBB3


MyISAM to INNODB

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;

INNODB to MyISAM

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;

Anderson
SELECT CONCAT('ALTER TABLE ', TABLE_NAME, ' ENGINE=INNODB;') 
FROM information_schema.TABLES 
WHERE TABLE_SCHEMA = 'dbname' AND engine = 'MyISAM'
GuruQA
GuruQA
 
 
7Ouros

sXe Injected Client 15.3

souza

GuruQa - Servers

Anderson

/teste - Meu primeiro plugin - AMXX

Anderson

Existe algum animal que nunca dorme?

Gluke

[TUTORIAL] Como Conseguir Curtidas na suas Fotos do Facebook

Anderson

Como alterar um nome de interface de rede no CentOS 7

Anderson

rehlds - Atualização para o velho HLDS

Anderson

Comandos para saber versão dos mods usado em um Server de Counter-Strike 1.6

Anderson

Server Redirect - Lote o seu Server de Counter-Strike 1.6

enigma

Carandiru - A casa do Diabo