Magento fix database table engines.

Posted by Damodar Bashyal on September 23, 2013

 

Magento-logo

/*run these if exists*/

ALTER TABLE `catalog_category_flat_store_1` ENGINE=InnoDB;
ALTER TABLE `catalog_category_flat_store_2` ENGINE=InnoDB;
ALTER TABLE `catalog_category_flat_store_3` ENGINE=InnoDB;
ALTER TABLE `catalog_category_flat_store_4` ENGINE=InnoDB;
ALTER TABLE `catalog_product_flat_1` ENGINE=InnoDB;
ALTER TABLE `catalog_product_flat_2` ENGINE=InnoDB;
ALTER TABLE `catalog_product_flat_3` ENGINE=InnoDB;
ALTER TABLE `catalog_product_flat_4` ENGINE=InnoDB;

/*below table exists in enterprise version. tested on 1.12.0.2*/

ALTER TABLE `admin_assert` ENGINE=InnoDB;
ALTER TABLE `admin_role` ENGINE=InnoDB;
ALTER TABLE `admin_rule` ENGINE=InnoDB;
ALTER TABLE `admin_user` ENGINE=InnoDB;
ALTER TABLE `adminnotification_inbox` ENGINE=InnoDB;
ALTER TABLE `api_assert` ENGINE=InnoDB;
ALTER TABLE `api_role` ENGINE=InnoDB;
ALTER TABLE `api_rule` ENGINE=InnoDB;
ALTER TABLE `api_session` ENGINE=InnoDB;
ALTER TABLE `api_user` ENGINE=InnoDB;
ALTER TABLE `catalog_category_anc_categs_index_idx` ENGINE=InnoDB;
ALTER TABLE `catalog_category_anc_categs_index_tmp` ENGINE=InnoDB;
ALTER TABLE `catalog_category_anc_products_index_idx` ENGINE=InnoDB;
ALTER TABLE `catalog_category_anc_products_index_tmp` ENGINE=InnoDB;
ALTER TABLE `catalog_category_entity` ENGINE=InnoDB;
ALTER TABLE `catalog_category_entity_datetime` ENGINE=InnoDB;
ALTER TABLE `catalog_category_entity_decimal` ENGINE=InnoDB;
ALTER TABLE `catalog_category_entity_int` ENGINE=InnoDB;
ALTER TABLE `catalog_category_entity_text` ENGINE=InnoDB;
ALTER TABLE `catalog_category_entity_varchar` ENGINE=InnoDB;
ALTER TABLE `catalog_category_product` ENGINE=InnoDB;
ALTER TABLE `catalog_category_product_index` ENGINE=InnoDB;
ALTER TABLE `catalog_category_product_index_enbl_idx` ENGINE=InnoDB;
ALTER TABLE `catalog_category_product_index_enbl_tmp` ENGINE=InnoDB;
ALTER TABLE `catalog_category_product_index_idx` ENGINE=InnoDB;
ALTER TABLE `catalog_category_product_index_tmp` ENGINE=InnoDB;
ALTER TABLE `catalog_compare_item` ENGINE=InnoDB;
ALTER TABLE `catalog_eav_attribute` ENGINE=InnoDB;
ALTER TABLE `catalog_product_bundle_option` ENGINE=InnoDB;
ALTER TABLE `catalog_product_bundle_option_value` ENGINE=InnoDB;
ALTER TABLE `catalog_product_bundle_price_index` ENGINE=InnoDB;
ALTER TABLE `catalog_product_bundle_selection` ENGINE=InnoDB;
ALTER TABLE `catalog_product_bundle_selection_price` ENGINE=InnoDB;
ALTER TABLE `catalog_product_bundle_stock_index` ENGINE=InnoDB;
ALTER TABLE `catalog_product_enabled_index` ENGINE=InnoDB;
ALTER TABLE `catalog_product_entity` ENGINE=InnoDB;
ALTER TABLE `catalog_product_entity_datetime` ENGINE=InnoDB;
ALTER TABLE `catalog_product_entity_decimal` ENGINE=InnoDB;
ALTER TABLE `catalog_product_entity_gallery` ENGINE=InnoDB;
ALTER TABLE `catalog_product_entity_int` ENGINE=InnoDB;
ALTER TABLE `catalog_product_entity_media_gallery` ENGINE=InnoDB;
ALTER TABLE `catalog_product_entity_media_gallery_value` ENGINE=InnoDB;
ALTER TABLE `catalog_product_entity_text` ENGINE=InnoDB;
ALTER TABLE `catalog_product_entity_tier_price` ENGINE=InnoDB;
ALTER TABLE `catalog_product_entity_varchar` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_eav` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_eav_decimal` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_eav_decimal_idx` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_eav_decimal_tmp` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_eav_idx` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_eav_tmp` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_price` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_price_bundle_idx` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_price_bundle_opt_idx` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_price_bundle_opt_tmp` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_price_bundle_sel_idx` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_price_bundle_sel_tmp` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_price_bundle_tmp` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_price_cfg_opt_agr_idx` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_price_cfg_opt_agr_tmp` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_price_cfg_opt_idx` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_price_cfg_opt_tmp` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_price_downlod_idx` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_price_downlod_tmp` ENGINE=MEMORY;
ALTER TABLE `catalog_product_index_price_final_idx` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_price_final_tmp` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_price_idx` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_price_opt_agr_idx` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_price_opt_agr_tmp` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_price_opt_idx` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_price_opt_tmp` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_price_tmp` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_tier_price` ENGINE=InnoDB;
ALTER TABLE `catalog_product_index_website` ENGINE=InnoDB;
ALTER TABLE `catalog_product_link` ENGINE=InnoDB;
ALTER TABLE `catalog_product_link_attribute` ENGINE=InnoDB;
ALTER TABLE `catalog_product_link_attribute_decimal` ENGINE=InnoDB;
ALTER TABLE `catalog_product_link_attribute_int` ENGINE=InnoDB;
ALTER TABLE `catalog_product_link_attribute_varchar` ENGINE=InnoDB;
ALTER TABLE `catalog_product_link_type` ENGINE=InnoDB;
ALTER TABLE `catalog_product_option` ENGINE=InnoDB;
ALTER TABLE `catalog_product_option_price` ENGINE=InnoDB;
ALTER TABLE `catalog_product_option_title` ENGINE=InnoDB;
ALTER TABLE `catalog_product_option_type_price` ENGINE=InnoDB;
ALTER TABLE `catalog_product_option_type_title` ENGINE=InnoDB;
ALTER TABLE `catalog_product_option_type_value` ENGINE=InnoDB;
ALTER TABLE `catalog_product_relation` ENGINE=InnoDB;
ALTER TABLE `catalog_product_super_attribute` ENGINE=InnoDB;
ALTER TABLE `catalog_product_super_attribute_label` ENGINE=InnoDB;
ALTER TABLE `catalog_product_super_attribute_pricing` ENGINE=InnoDB;
ALTER TABLE `catalog_product_super_link` ENGINE=InnoDB;
ALTER TABLE `catalog_product_website` ENGINE=InnoDB;
ALTER TABLE `cataloginventory_stock` ENGINE=InnoDB;
ALTER TABLE `cataloginventory_stock_item` ENGINE=InnoDB;
ALTER TABLE `cataloginventory_stock_status` ENGINE=InnoDB;
ALTER TABLE `cataloginventory_stock_status_idx` ENGINE=InnoDB;
ALTER TABLE `cataloginventory_stock_status_tmp` ENGINE=InnoDB;
ALTER TABLE `catalogrule` ENGINE=InnoDB;
ALTER TABLE `catalogrule_affected_product` ENGINE=InnoDB;
ALTER TABLE `catalogrule_group_website` ENGINE=InnoDB;
ALTER TABLE `catalogrule_product` ENGINE=InnoDB;
ALTER TABLE `catalogrule_product_price` ENGINE=InnoDB;
ALTER TABLE `catalogsearch_fulltext` ENGINE=MyISAM;
ALTER TABLE `catalogsearch_query` ENGINE=InnoDB;
ALTER TABLE `catalogsearch_recommendations` ENGINE=InnoDB;
ALTER TABLE `catalogsearch_result` ENGINE=InnoDB;
ALTER TABLE `checkout_agreement` ENGINE=InnoDB;
ALTER TABLE `checkout_agreement_store` ENGINE=InnoDB;
ALTER TABLE `cms_block` ENGINE=InnoDB;
ALTER TABLE `cms_page_store` ENGINE=InnoDB;
ALTER TABLE `core_cache` ENGINE=InnoDB;
ALTER TABLE `core_cache_option` ENGINE=InnoDB;
ALTER TABLE `core_cache_tag` ENGINE=InnoDB;
ALTER TABLE `core_config_data` ENGINE=InnoDB;
ALTER TABLE `core_email_template` ENGINE=InnoDB;
ALTER TABLE `core_flag` ENGINE=InnoDB;
ALTER TABLE `core_layout_link` ENGINE=InnoDB;
ALTER TABLE `core_layout_update` ENGINE=InnoDB;
ALTER TABLE `core_resource` ENGINE=InnoDB;
ALTER TABLE `core_session` ENGINE=InnoDB;
ALTER TABLE `core_store` ENGINE=InnoDB;
ALTER TABLE `core_store_group` ENGINE=InnoDB;
ALTER TABLE `core_translate` ENGINE=InnoDB;
ALTER TABLE `core_url_rewrite` ENGINE=InnoDB;
ALTER TABLE `core_variable` ENGINE=InnoDB;
ALTER TABLE `core_variable_value` ENGINE=InnoDB;
ALTER TABLE `core_website` ENGINE=InnoDB;
ALTER TABLE `coupon_aggregated` ENGINE=InnoDB;
ALTER TABLE `coupon_aggregated_order` ENGINE=InnoDB;
ALTER TABLE `coupon_aggregated_updated` ENGINE=InnoDB;
ALTER TABLE `cron_schedule` ENGINE=InnoDB;
ALTER TABLE `customer_address_entity` ENGINE=InnoDB;
ALTER TABLE `customer_address_entity_datetime` ENGINE=InnoDB;
ALTER TABLE `customer_address_entity_decimal` ENGINE=InnoDB;
ALTER TABLE `customer_address_entity_int` ENGINE=InnoDB;
ALTER TABLE `customer_address_entity_text` ENGINE=InnoDB;
ALTER TABLE `customer_address_entity_varchar` ENGINE=InnoDB;
ALTER TABLE `customer_eav_attribute` ENGINE=InnoDB;
ALTER TABLE `customer_eav_attribute_website` ENGINE=InnoDB;
ALTER TABLE `customer_entity` ENGINE=InnoDB;
ALTER TABLE `customer_entity_datetime` ENGINE=InnoDB;
ALTER TABLE `customer_entity_decimal` ENGINE=InnoDB;
ALTER TABLE `customer_entity_int` ENGINE=InnoDB;
ALTER TABLE `customer_entity_text` ENGINE=InnoDB;
ALTER TABLE `customer_entity_varchar` ENGINE=InnoDB;
ALTER TABLE `customer_form_attribute` ENGINE=InnoDB;
ALTER TABLE `customer_group` ENGINE=InnoDB;
ALTER TABLE `dataflow_batch` ENGINE=InnoDB;
ALTER TABLE `dataflow_batch_export` ENGINE=InnoDB;
ALTER TABLE `dataflow_batch_import` ENGINE=InnoDB;
ALTER TABLE `dataflow_import_data` ENGINE=InnoDB;
ALTER TABLE `dataflow_profile` ENGINE=InnoDB;
ALTER TABLE `dataflow_profile_history` ENGINE=InnoDB;
ALTER TABLE `dataflow_session` ENGINE=InnoDB;
ALTER TABLE `design_change` ENGINE=InnoDB;
ALTER TABLE `directory_country` ENGINE=InnoDB;
ALTER TABLE `directory_country_format` ENGINE=InnoDB;
ALTER TABLE `directory_country_region` ENGINE=InnoDB;
ALTER TABLE `directory_country_region_name` ENGINE=InnoDB;
ALTER TABLE `directory_currency_rate` ENGINE=InnoDB;
ALTER TABLE `downloadable_link` ENGINE=InnoDB;
ALTER TABLE `downloadable_link_price` ENGINE=InnoDB;
ALTER TABLE `downloadable_link_purchased` ENGINE=InnoDB;
ALTER TABLE `downloadable_link_purchased_item` ENGINE=InnoDB;
ALTER TABLE `downloadable_link_title` ENGINE=InnoDB;
ALTER TABLE `downloadable_sample` ENGINE=InnoDB;
ALTER TABLE `downloadable_sample_title` ENGINE=InnoDB;
ALTER TABLE `eav_attribute` ENGINE=InnoDB;
ALTER TABLE `eav_attribute_group` ENGINE=InnoDB;
ALTER TABLE `eav_attribute_label` ENGINE=InnoDB;
ALTER TABLE `eav_attribute_option` ENGINE=InnoDB;
ALTER TABLE `eav_attribute_option_value` ENGINE=InnoDB;
ALTER TABLE `eav_attribute_set` ENGINE=InnoDB;
ALTER TABLE `eav_entity` ENGINE=InnoDB;
ALTER TABLE `eav_entity_attribute` ENGINE=InnoDB;
ALTER TABLE `eav_entity_datetime` ENGINE=InnoDB;
ALTER TABLE `eav_entity_decimal` ENGINE=InnoDB;
ALTER TABLE `eav_entity_int` ENGINE=InnoDB;
ALTER TABLE `eav_entity_store` ENGINE=InnoDB;
ALTER TABLE `eav_entity_text` ENGINE=InnoDB;
ALTER TABLE `eav_entity_type` ENGINE=InnoDB;
ALTER TABLE `eav_entity_varchar` ENGINE=InnoDB;
ALTER TABLE `eav_form_element` ENGINE=InnoDB;
ALTER TABLE `eav_form_fieldset` ENGINE=InnoDB;
ALTER TABLE `eav_form_fieldset_label` ENGINE=InnoDB;
ALTER TABLE `eav_form_type` ENGINE=InnoDB;
ALTER TABLE `eav_form_type_entity` ENGINE=InnoDB;
ALTER TABLE `enterprise_admin_passwords` ENGINE=InnoDB;
ALTER TABLE `enterprise_banner` ENGINE=InnoDB;
ALTER TABLE `enterprise_banner_catalogrule` ENGINE=InnoDB;
ALTER TABLE `enterprise_banner_content` ENGINE=InnoDB;
ALTER TABLE `enterprise_banner_customersegment` ENGINE=InnoDB;
ALTER TABLE `enterprise_banner_salesrule` ENGINE=InnoDB;
ALTER TABLE `enterprise_catalogevent_event` ENGINE=InnoDB;
ALTER TABLE `enterprise_catalogevent_event_image` ENGINE=InnoDB;
ALTER TABLE `enterprise_catalogpermissions` ENGINE=InnoDB;
ALTER TABLE `enterprise_catalogpermissions_index` ENGINE=InnoDB;
ALTER TABLE `enterprise_catalogpermissions_index_product` ENGINE=InnoDB;
ALTER TABLE `enterprise_cms_hierarchy_lock` ENGINE=InnoDB;
ALTER TABLE `enterprise_cms_hierarchy_metadata` ENGINE=InnoDB;
ALTER TABLE `enterprise_cms_hierarchy_node` ENGINE=InnoDB;
ALTER TABLE `enterprise_cms_increment` ENGINE=InnoDB;
ALTER TABLE `enterprise_cms_page_revision` ENGINE=InnoDB;
ALTER TABLE `enterprise_cms_page_version` ENGINE=InnoDB;
ALTER TABLE `enterprise_customer_sales_flat_order` ENGINE=InnoDB;
ALTER TABLE `enterprise_customer_sales_flat_order_address` ENGINE=InnoDB;
ALTER TABLE `enterprise_customer_sales_flat_quote` ENGINE=InnoDB;
ALTER TABLE `enterprise_customer_sales_flat_quote_address` ENGINE=InnoDB;
ALTER TABLE `enterprise_customerbalance` ENGINE=InnoDB;
ALTER TABLE `enterprise_customerbalance_history` ENGINE=InnoDB;
ALTER TABLE `enterprise_customersegment_customer` ENGINE=InnoDB;
ALTER TABLE `enterprise_customersegment_event` ENGINE=InnoDB;
ALTER TABLE `enterprise_customersegment_segment` ENGINE=InnoDB;
ALTER TABLE `enterprise_customersegment_website` ENGINE=InnoDB;
ALTER TABLE `enterprise_giftcard_amount` ENGINE=InnoDB;
ALTER TABLE `enterprise_giftcardaccount` ENGINE=InnoDB;
ALTER TABLE `enterprise_giftcardaccount_history` ENGINE=InnoDB;
ALTER TABLE `enterprise_giftcardaccount_pool` ENGINE=InnoDB;
ALTER TABLE `enterprise_giftregistry_data` ENGINE=InnoDB;
ALTER TABLE `enterprise_giftregistry_entity` ENGINE=InnoDB;
ALTER TABLE `enterprise_giftregistry_item` ENGINE=InnoDB;
ALTER TABLE `enterprise_giftregistry_item_option` ENGINE=InnoDB;
ALTER TABLE `enterprise_giftregistry_label` ENGINE=InnoDB;
ALTER TABLE `enterprise_giftregistry_person` ENGINE=InnoDB;
ALTER TABLE `enterprise_giftregistry_type` ENGINE=InnoDB;
ALTER TABLE `enterprise_giftregistry_type_info` ENGINE=InnoDB;
ALTER TABLE `enterprise_giftwrapping` ENGINE=InnoDB;
ALTER TABLE `enterprise_giftwrapping_store_attributes` ENGINE=InnoDB;
ALTER TABLE `enterprise_giftwrapping_website` ENGINE=InnoDB;
ALTER TABLE `enterprise_invitation` ENGINE=InnoDB;
ALTER TABLE `enterprise_invitation_status_history` ENGINE=InnoDB;
ALTER TABLE `enterprise_invitation_track` ENGINE=InnoDB;
ALTER TABLE `enterprise_logging_event` ENGINE=InnoDB;
ALTER TABLE `enterprise_logging_event_changes` ENGINE=InnoDB;
ALTER TABLE `enterprise_reminder_rule` ENGINE=InnoDB;
ALTER TABLE `enterprise_reminder_rule_coupon` ENGINE=InnoDB;
ALTER TABLE `enterprise_reminder_rule_log` ENGINE=InnoDB;
ALTER TABLE `enterprise_reminder_rule_website` ENGINE=InnoDB;
ALTER TABLE `enterprise_reminder_template` ENGINE=InnoDB;
ALTER TABLE `enterprise_reward` ENGINE=InnoDB;
ALTER TABLE `enterprise_reward_history` ENGINE=InnoDB;
ALTER TABLE `enterprise_reward_rate` ENGINE=InnoDB;
ALTER TABLE `enterprise_reward_salesrule` ENGINE=InnoDB;
ALTER TABLE `enterprise_rma` ENGINE=InnoDB;
ALTER TABLE `enterprise_rma_grid` ENGINE=InnoDB;
ALTER TABLE `enterprise_rma_item_eav_attribute` ENGINE=InnoDB;
ALTER TABLE `enterprise_rma_item_eav_attribute_website` ENGINE=InnoDB;
ALTER TABLE `enterprise_rma_item_entity` ENGINE=InnoDB;
ALTER TABLE `enterprise_rma_item_entity_datetime` ENGINE=InnoDB;
ALTER TABLE `enterprise_rma_item_entity_decimal` ENGINE=InnoDB;
ALTER TABLE `enterprise_rma_item_entity_int` ENGINE=InnoDB;
ALTER TABLE `enterprise_rma_item_entity_text` ENGINE=InnoDB;
ALTER TABLE `enterprise_rma_item_entity_varchar` ENGINE=InnoDB;
ALTER TABLE `enterprise_rma_item_form_attribute` ENGINE=InnoDB;
ALTER TABLE `enterprise_rma_shipping_label` ENGINE=InnoDB;
ALTER TABLE `enterprise_rma_status_history` ENGINE=InnoDB;
ALTER TABLE `enterprise_sales_creditmemo_grid_archive` ENGINE=InnoDB;
ALTER TABLE `enterprise_sales_invoice_grid_archive` ENGINE=InnoDB;
ALTER TABLE `enterprise_sales_order_grid_archive` ENGINE=InnoDB;
ALTER TABLE `enterprise_sales_shipment_grid_archive` ENGINE=InnoDB;
ALTER TABLE `enterprise_scheduled_operations` ENGINE=InnoDB;
ALTER TABLE `enterprise_staging` ENGINE=InnoDB;
ALTER TABLE `enterprise_staging_action` ENGINE=InnoDB;
ALTER TABLE `enterprise_staging_item` ENGINE=InnoDB;
ALTER TABLE `enterprise_staging_log` ENGINE=InnoDB;
ALTER TABLE `enterprise_staging_product_unlinked` ENGINE=InnoDB;
ALTER TABLE `enterprise_targetrule` ENGINE=InnoDB;
ALTER TABLE `enterprise_targetrule_customersegment` ENGINE=InnoDB;
ALTER TABLE `enterprise_targetrule_index` ENGINE=InnoDB;
ALTER TABLE `enterprise_targetrule_index_crosssell` ENGINE=InnoDB;
ALTER TABLE `enterprise_targetrule_index_related` ENGINE=InnoDB;
ALTER TABLE `enterprise_targetrule_index_upsell` ENGINE=InnoDB;
ALTER TABLE `enterprise_targetrule_product` ENGINE=InnoDB;
ALTER TABLE `gift_message` ENGINE=InnoDB;
ALTER TABLE `googlecheckout_notification` ENGINE=InnoDB;
ALTER TABLE `importexport_importdata` ENGINE=InnoDB;
ALTER TABLE `index_event` ENGINE=InnoDB;
ALTER TABLE `index_process` ENGINE=InnoDB;
ALTER TABLE `index_process_event` ENGINE=InnoDB;
ALTER TABLE `log_customer` ENGINE=InnoDB;
ALTER TABLE `log_quote` ENGINE=InnoDB;
ALTER TABLE `log_summary` ENGINE=InnoDB;
ALTER TABLE `log_summary_type` ENGINE=InnoDB;
ALTER TABLE `log_url` ENGINE=InnoDB;
ALTER TABLE `log_url_info` ENGINE=InnoDB;
ALTER TABLE `log_visitor` ENGINE=InnoDB;
ALTER TABLE `log_visitor_info` ENGINE=InnoDB;
ALTER TABLE `log_visitor_online` ENGINE=InnoDB;
ALTER TABLE `newsletter_problem` ENGINE=InnoDB;
ALTER TABLE `newsletter_queue` ENGINE=InnoDB;
ALTER TABLE `newsletter_queue_link` ENGINE=InnoDB;
ALTER TABLE `newsletter_queue_store_link` ENGINE=InnoDB;
ALTER TABLE `newsletter_subscriber` ENGINE=InnoDB;
ALTER TABLE `newsletter_template` ENGINE=InnoDB;
ALTER TABLE `paypal_cert` ENGINE=InnoDB;
ALTER TABLE `paypal_payment_transaction` ENGINE=InnoDB;
ALTER TABLE `paypal_settlement_report` ENGINE=InnoDB;
ALTER TABLE `paypal_settlement_report_row` ENGINE=InnoDB;
ALTER TABLE `persistent_session` ENGINE=InnoDB;
ALTER TABLE `poll` ENGINE=InnoDB;
ALTER TABLE `poll_answer` ENGINE=InnoDB;
ALTER TABLE `poll_store` ENGINE=InnoDB;
ALTER TABLE `poll_vote` ENGINE=InnoDB;
ALTER TABLE `product_alert_price` ENGINE=InnoDB;
ALTER TABLE `product_alert_stock` ENGINE=InnoDB;
ALTER TABLE `rating` ENGINE=InnoDB;
ALTER TABLE `rating_entity` ENGINE=InnoDB;
ALTER TABLE `rating_option` ENGINE=InnoDB;
ALTER TABLE `rating_option_vote` ENGINE=InnoDB;
ALTER TABLE `rating_option_vote_aggregated` ENGINE=InnoDB;
ALTER TABLE `rating_store` ENGINE=InnoDB;
ALTER TABLE `rating_title` ENGINE=InnoDB;
ALTER TABLE `report_compared_product_index` ENGINE=InnoDB;
ALTER TABLE `report_event` ENGINE=InnoDB;
ALTER TABLE `report_event_types` ENGINE=InnoDB;
ALTER TABLE `report_viewed_product_index` ENGINE=InnoDB;
ALTER TABLE `review` ENGINE=InnoDB;
ALTER TABLE `review_detail` ENGINE=InnoDB;
ALTER TABLE `review_entity` ENGINE=InnoDB;
ALTER TABLE `review_entity_summary` ENGINE=InnoDB;
ALTER TABLE `review_status` ENGINE=InnoDB;
ALTER TABLE `review_store` ENGINE=InnoDB;
ALTER TABLE `sales_bestsellers_aggregated_daily` ENGINE=InnoDB;
ALTER TABLE `sales_bestsellers_aggregated_monthly` ENGINE=InnoDB;
ALTER TABLE `sales_bestsellers_aggregated_yearly` ENGINE=InnoDB;
ALTER TABLE `sales_billing_agreement` ENGINE=InnoDB;
ALTER TABLE `sales_billing_agreement_order` ENGINE=InnoDB;
ALTER TABLE `sales_flat_creditmemo` ENGINE=InnoDB;
ALTER TABLE `sales_flat_creditmemo_comment` ENGINE=InnoDB;
ALTER TABLE `sales_flat_creditmemo_grid` ENGINE=InnoDB;
ALTER TABLE `sales_flat_creditmemo_item` ENGINE=InnoDB;
ALTER TABLE `sales_flat_invoice` ENGINE=InnoDB;
ALTER TABLE `sales_flat_invoice_comment` ENGINE=InnoDB;
ALTER TABLE `sales_flat_invoice_grid` ENGINE=InnoDB;
ALTER TABLE `sales_flat_invoice_item` ENGINE=InnoDB;
ALTER TABLE `sales_flat_order` ENGINE=InnoDB;
ALTER TABLE `sales_flat_order_address` ENGINE=InnoDB;
ALTER TABLE `sales_flat_order_grid` ENGINE=InnoDB;
ALTER TABLE `sales_flat_order_item` ENGINE=InnoDB;
ALTER TABLE `sales_flat_order_payment` ENGINE=InnoDB;
ALTER TABLE `sales_flat_order_status_history` ENGINE=InnoDB;
ALTER TABLE `sales_flat_quote` ENGINE=InnoDB;
ALTER TABLE `sales_flat_quote_address` ENGINE=InnoDB;
ALTER TABLE `sales_flat_quote_address_item` ENGINE=InnoDB;
ALTER TABLE `sales_flat_quote_item` ENGINE=InnoDB;
ALTER TABLE `sales_flat_quote_item_option` ENGINE=InnoDB;
ALTER TABLE `sales_flat_quote_payment` ENGINE=InnoDB;
ALTER TABLE `sales_flat_quote_shipping_rate` ENGINE=InnoDB;
ALTER TABLE `sales_flat_shipment` ENGINE=InnoDB;
ALTER TABLE `sales_flat_shipment_comment` ENGINE=InnoDB;
ALTER TABLE `sales_flat_shipment_grid` ENGINE=InnoDB;
ALTER TABLE `sales_flat_shipment_item` ENGINE=InnoDB;
ALTER TABLE `sales_flat_shipment_track` ENGINE=InnoDB;
ALTER TABLE `sales_invoiced_aggregated` ENGINE=InnoDB;
ALTER TABLE `sales_invoiced_aggregated_order` ENGINE=InnoDB;
ALTER TABLE `sales_order_aggregated_created` ENGINE=InnoDB;
ALTER TABLE `sales_order_aggregated_updated` ENGINE=InnoDB;
ALTER TABLE `sales_order_status` ENGINE=InnoDB;
ALTER TABLE `sales_order_status_label` ENGINE=InnoDB;
ALTER TABLE `sales_order_status_state` ENGINE=InnoDB;
ALTER TABLE `sales_order_tax` ENGINE=InnoDB;
ALTER TABLE `sales_order_tax_item` ENGINE=InnoDB;
ALTER TABLE `sales_payment_transaction` ENGINE=InnoDB;
ALTER TABLE `sales_recurring_profile` ENGINE=InnoDB;
ALTER TABLE `sales_recurring_profile_order` ENGINE=InnoDB;
ALTER TABLE `sales_refunded_aggregated` ENGINE=InnoDB;
ALTER TABLE `sales_refunded_aggregated_order` ENGINE=InnoDB;
ALTER TABLE `sales_shipping_aggregated` ENGINE=InnoDB;
ALTER TABLE `sales_shipping_aggregated_order` ENGINE=InnoDB;
ALTER TABLE `salesrule` ENGINE=InnoDB;
ALTER TABLE `salesrule_coupon` ENGINE=InnoDB;
ALTER TABLE `salesrule_coupon_usage` ENGINE=InnoDB;
ALTER TABLE `salesrule_customer` ENGINE=InnoDB;
ALTER TABLE `salesrule_label` ENGINE=InnoDB;
ALTER TABLE `salesrule_product_attribute` ENGINE=InnoDB;
ALTER TABLE `sendfriend_log` ENGINE=InnoDB;
ALTER TABLE `shipping_tablerate` ENGINE=InnoDB;
ALTER TABLE `sitemap` ENGINE=InnoDB;
ALTER TABLE `tag` ENGINE=InnoDB;
ALTER TABLE `tag_properties` ENGINE=InnoDB;
ALTER TABLE `tag_relation` ENGINE=InnoDB;
ALTER TABLE `tag_summary` ENGINE=InnoDB;
ALTER TABLE `tax_calculation` ENGINE=InnoDB;
ALTER TABLE `tax_calculation_rate` ENGINE=InnoDB;
ALTER TABLE `tax_calculation_rate_title` ENGINE=InnoDB;
ALTER TABLE `tax_calculation_rule` ENGINE=InnoDB;
ALTER TABLE `tax_class` ENGINE=InnoDB;
ALTER TABLE `tax_order_aggregated_created` ENGINE=InnoDB;
ALTER TABLE `tax_order_aggregated_updated` ENGINE=InnoDB;
ALTER TABLE `weee_discount` ENGINE=InnoDB;
ALTER TABLE `weee_tax` ENGINE=InnoDB;
ALTER TABLE `widget` ENGINE=InnoDB;
ALTER TABLE `widget_instance` ENGINE=InnoDB;
ALTER TABLE `widget_instance_page` ENGINE=InnoDB;
ALTER TABLE `widget_instance_page_layout` ENGINE=InnoDB;
ALTER TABLE `wishlist` ENGINE=InnoDB;
ALTER TABLE `wishlist_item` ENGINE=InnoDB;
ALTER TABLE `wishlist_item_option` ENGINE=InnoDB;
ALTER TABLE `xmlconnect_application` ENGINE=InnoDB;
ALTER TABLE `xmlconnect_config_data` ENGINE=InnoDB;
ALTER TABLE `xmlconnect_history` ENGINE=InnoDB;
ALTER TABLE `xmlconnect_notification_template` ENGINE=InnoDB;
ALTER TABLE `xmlconnect_queue` ENGINE=InnoDB;

Michael Leiss posted on - Tuesday 2nd of June 2015 12:04:45 AM

`catalog_product_index_price_tmp`

with any _tmp table setting to innodb you make a big mistake...those tables are in memory tables!
 
not published on website


QR Code: Magento fix database table engines.