cancel
Showing results for 
Search instead for 
Did you mean: 

Base table or view not found issue in Migration

Highlighted

Base table or view not found issue in Migration

I am migrating from 1.9.3.6 to 2.3.4.I have prefix in Magento 1 database 'mgbv_'. I used `<source_prefix>` in `config.xml` file. I have no prefix in Magento 2 database. I am getting below error. What is the solution ?

 

17 REPLIES 17
Highlighted

Re: Base table or view not found issue in Migration

Hi @foysal ,

 

This issue seems like occurring because of some unwanted table in Magento 1 database. Can you please share your Magento 1 database tables list here.

 

Thanks!

 

Problem Solved! Click Kudos & Accept as Solution!

Highlighted

Re: Base table or view not found issue in Migration

Thanks @Nishu Jindal . Here is the list of Magento 1 tables.

 

MariaDB [trendytr_db123]> show tables;
+-------------------------------------------------------+
| Tables_in_trendytr_db123                              |
+-------------------------------------------------------+
| mgbv_admin_assert                                     |
| mgbv_admin_role                                       |
| mgbv_admin_rule                                       |
| mgbv_admin_user                                       |
| mgbv_adminnotification_inbox                          |
| mgbv_al_botgento_data                                 |
| mgbv_al_botgento_subscriber_quote_mapping             |
| mgbv_al_botgento_sync_attributes                      |
| mgbv_al_botgento_sync_log                             |
| mgbv_al_botgento_users                                |
| mgbv_api2_acl_attribute                               |
| mgbv_api2_acl_role                                    |
| mgbv_api2_acl_rule                                    |
| mgbv_api2_acl_user                                    |
| mgbv_api_assert                                       |
| mgbv_api_role                                         |
| mgbv_api_rule                                         |
| mgbv_api_session                                      |
| mgbv_api_user                                         |
| mgbv_aw_affiliate_affiliate                           |
| mgbv_aw_affiliate_campaign                            |
| mgbv_aw_affiliate_client                              |
| mgbv_aw_affiliate_client_history                      |
| mgbv_aw_affiliate_profit                              |
| mgbv_aw_affiliate_profit_tier_rate                    |
| mgbv_aw_affiliate_traffic_source                      |
| mgbv_aw_affiliate_transaction_profit                  |
| mgbv_aw_affiliate_transaction_withdrawal              |
| mgbv_aw_affiliate_withdrawal_request                  |
| mgbv_aw_blog                                          |
| mgbv_aw_blog_cat                                      |
| mgbv_aw_blog_cat_store                                |
| mgbv_aw_blog_comment                                  |
| mgbv_aw_blog_post_cat                                 |
| mgbv_aw_blog_store                                    |
| mgbv_aw_blog_tags                                     |
| mgbv_captcha_log                                      |
| mgbv_cartreservation_item                             |
| mgbv_cartreservation_log                              |
| mgbv_catalog_category_anc_categs_index_idx            |
| mgbv_catalog_category_anc_categs_index_tmp            |
| mgbv_catalog_category_anc_products_index_idx          |
| mgbv_catalog_category_anc_products_index_tmp          |
| mgbv_catalog_category_entity                          |
| mgbv_catalog_category_entity_datetime                 |
| mgbv_catalog_category_entity_decimal                  |
| mgbv_catalog_category_entity_int                      |
| mgbv_catalog_category_entity_text                     |
| mgbv_catalog_category_entity_varchar                  |
| mgbv_catalog_category_flat_store_1                    |
| mgbv_catalog_category_product                         |
| mgbv_catalog_category_product_index                   |
| mgbv_catalog_category_product_index_enbl_idx          |
| mgbv_catalog_category_product_index_enbl_tmp          |
| mgbv_catalog_category_product_index_idx               |
| mgbv_catalog_category_product_index_tmp               |
| mgbv_catalog_compare_item                             |
| mgbv_catalog_eav_attribute                            |
| mgbv_catalog_product_bundle_option                    |
| mgbv_catalog_product_bundle_option_value              |
| mgbv_catalog_product_bundle_price_index               |
| mgbv_catalog_product_bundle_selection                 |
| mgbv_catalog_product_bundle_selection_price           |
| mgbv_catalog_product_bundle_stock_index               |
| mgbv_catalog_product_enabled_index                    |
| mgbv_catalog_product_entity                           |
| mgbv_catalog_product_entity_datetime                  |
| mgbv_catalog_product_entity_decimal                   |
| mgbv_catalog_product_entity_gallery                   |
| mgbv_catalog_product_entity_group_price               |
| mgbv_catalog_product_entity_int                       |
| mgbv_catalog_product_entity_media_gallery             |
| mgbv_catalog_product_entity_media_gallery_value       |
| mgbv_catalog_product_entity_text                      |
| mgbv_catalog_product_entity_tier_price                |
| mgbv_catalog_product_entity_varchar                   |
| mgbv_catalog_product_flat_1                           |
| mgbv_catalog_product_index_eav                        |
| mgbv_catalog_product_index_eav_decimal                |
| mgbv_catalog_product_index_eav_decimal_idx            |
| mgbv_catalog_product_index_eav_decimal_tmp            |
| mgbv_catalog_product_index_eav_idx                    |
| mgbv_catalog_product_index_eav_tmp                    |
| mgbv_catalog_product_index_group_price                |
| mgbv_catalog_product_index_price                      |
| mgbv_catalog_product_index_price_bundle_idx           |
| mgbv_catalog_product_index_price_bundle_opt_idx       |
| mgbv_catalog_product_index_price_bundle_opt_tmp       |
| mgbv_catalog_product_index_price_bundle_sel_idx       |
| mgbv_catalog_product_index_price_bundle_sel_tmp       |
| mgbv_catalog_product_index_price_bundle_tmp           |
| mgbv_catalog_product_index_price_cfg_opt_agr_idx      |
| mgbv_catalog_product_index_price_cfg_opt_agr_tmp      |
| mgbv_catalog_product_index_price_cfg_opt_idx          |
| mgbv_catalog_product_index_price_cfg_opt_tmp          |
| mgbv_catalog_product_index_price_downlod_idx          |
| mgbv_catalog_product_index_price_downlod_tmp          |
| mgbv_catalog_product_index_price_final_idx            |
| mgbv_catalog_product_index_price_final_tmp            |
| mgbv_catalog_product_index_price_idx                  |
| mgbv_catalog_product_index_price_opt_agr_idx          |
| mgbv_catalog_product_index_price_opt_agr_tmp          |
| mgbv_catalog_product_index_price_opt_idx              |
| mgbv_catalog_product_index_price_opt_tmp              |
| mgbv_catalog_product_index_price_tmp                  |
| mgbv_catalog_product_index_tier_price                 |
| mgbv_catalog_product_index_website                    |
| mgbv_catalog_product_link                             |
| mgbv_catalog_product_link_attribute                   |
| mgbv_catalog_product_link_attribute_decimal           |
| mgbv_catalog_product_link_attribute_int               |
| mgbv_catalog_product_link_attribute_varchar           |
| mgbv_catalog_product_link_type                        |
| mgbv_catalog_product_option                           |
| mgbv_catalog_product_option_price                     |
| mgbv_catalog_product_option_title                     |
| mgbv_catalog_product_option_type_price                |
| mgbv_catalog_product_option_type_title                |
| mgbv_catalog_product_option_type_value                |
| mgbv_catalog_product_relation                         |
| mgbv_catalog_product_super_attribute                  |
| mgbv_catalog_product_super_attribute_label            |
| mgbv_catalog_product_super_attribute_pricing          |
| mgbv_catalog_product_super_link                       |
| mgbv_catalog_product_website                          |
| mgbv_cataloginventory_stock                           |
| mgbv_cataloginventory_stock_item                      |
| mgbv_cataloginventory_stock_status                    |
| mgbv_cataloginventory_stock_status_idx                |
| mgbv_cataloginventory_stock_status_tmp                |
| mgbv_catalogrule                                      |
| mgbv_catalogrule_affected_product                     |
| mgbv_catalogrule_customer_group                       |
| mgbv_catalogrule_group_website                        |
| mgbv_catalogrule_product                              |
| mgbv_catalogrule_product_price                        |
| mgbv_catalogrule_website                              |
| mgbv_catalogsearch_fulltext                           |
| mgbv_catalogsearch_query                              |
| mgbv_catalogsearch_result                             |
| mgbv_cdz_slideshow                                    |
| mgbv_checkout_agreement                               |
| mgbv_checkout_agreement_store                         |
| mgbv_cms_block                                        |
| mgbv_cms_block_store                                  |
| mgbv_cms_page                                         |
| mgbv_cms_page_store                                   |
| mgbv_codazon_megamenu                                 |
| mgbv_core_cache                                       |
| mgbv_core_cache_option                                |
| mgbv_core_cache_tag                                   |
| mgbv_core_config_data                                 |
| mgbv_core_email_queue                                 |
| mgbv_core_email_queue_recipients                      |
| mgbv_core_email_template                              |
| mgbv_core_flag                                        |
| mgbv_core_layout_link                                 |
| mgbv_core_layout_update                               |
| mgbv_core_resource                                    |
| mgbv_core_session                                     |
| mgbv_core_store                                       |
| mgbv_core_store_group                                 |
| mgbv_core_translate                                   |
| mgbv_core_url_rewrite                                 |
| mgbv_core_variable                                    |
| mgbv_core_variable_value                              |
| mgbv_core_website                                     |
Highlighted

Re: Base table or view not found issue in Migration

@Nishu Jindal, rest of the tables are below

| mgbv_coupon_aggregated                                |
| mgbv_coupon_aggregated_order                          |
| mgbv_coupon_aggregated_updated                        |
| mgbv_cron_schedule                                    |
| mgbv_customer_address_entity                          |
| mgbv_customer_address_entity_datetime                 |
| mgbv_customer_address_entity_decimal                  |
| mgbv_customer_address_entity_int                      |
| mgbv_customer_address_entity_text                     |
| mgbv_customer_address_entity_varchar                  |
| mgbv_customer_eav_attribute                           |
| mgbv_customer_eav_attribute_website                   |
| mgbv_customer_entity                                  |
| mgbv_customer_entity_datetime                         |
| mgbv_customer_entity_decimal                          |
| mgbv_customer_entity_int                              |
| mgbv_customer_entity_text                             |
| mgbv_customer_entity_varchar                          |
| mgbv_customer_flowpassword                            |
| mgbv_customer_form_attribute                          |
| mgbv_customer_group                                   |
| mgbv_dataflow_batch                                   |
| mgbv_dataflow_batch_export                            |
| mgbv_dataflow_batch_import                            |
| mgbv_dataflow_import_data                             |
| mgbv_dataflow_profile                                 |
| mgbv_dataflow_profile_history                         |
| mgbv_dataflow_session                                 |
| mgbv_design_change                                    |
| mgbv_directory_country                                |
| mgbv_directory_country_format                         |
| mgbv_directory_country_region                         |
| mgbv_directory_country_region_name                    |
| mgbv_directory_currency_rate                          |
| mgbv_downloadable_link                                |
| mgbv_downloadable_link_price                          |
| mgbv_downloadable_link_purchased                      |
| mgbv_downloadable_link_purchased_item                 |
| mgbv_downloadable_link_title                          |
| mgbv_downloadable_sample                              |
| mgbv_downloadable_sample_title                        |
| mgbv_eav_attribute                                    |
| mgbv_eav_attribute_group                              |
| mgbv_eav_attribute_label                              |
| mgbv_eav_attribute_option                             |
| mgbv_eav_attribute_option_value                       |
| mgbv_eav_attribute_set                                |
| mgbv_eav_entity                                       |
| mgbv_eav_entity_attribute                             |
| mgbv_eav_entity_datetime                              |
| mgbv_eav_entity_decimal                               |
| mgbv_eav_entity_int                                   |
| mgbv_eav_entity_store                                 |
| mgbv_eav_entity_text                                  |
| mgbv_eav_entity_type                                  |
| mgbv_eav_entity_varchar                               |
| mgbv_eav_form_element                                 |
| mgbv_eav_form_fieldset                                |
| mgbv_eav_form_fieldset_label                          |
| mgbv_eav_form_type                                    |
| mgbv_eav_form_type_entity                             |
| mgbv_gift_message                                     |
| mgbv_importexport_importdata                          |
| mgbv_index_event                                      |
| mgbv_index_process                                    |
| mgbv_index_process_event                              |
| mgbv_livechat                                         |
| mgbv_log_customer                                     |
| mgbv_log_quote                                        |
| mgbv_log_summary                                      |
| mgbv_log_summary_type                                 |
| mgbv_log_url                                          |
| mgbv_log_url_info                                     |
| mgbv_log_visitor                                      |
| mgbv_log_visitor_info                                 |
| mgbv_log_visitor_online                               |
| mgbv_m2_cl_catalog_category_entity                    |
| mgbv_m2_cl_catalog_category_entity_datetime           |
| mgbv_m2_cl_catalog_category_entity_decimal            |
| mgbv_m2_cl_catalog_category_entity_int                |
| mgbv_m2_cl_catalog_category_entity_text               |
| mgbv_m2_cl_catalog_category_entity_varchar            |
| mgbv_m2_cl_catalog_category_product                   |
| mgbv_m2_cl_catalog_compare_item                       |
| mgbv_m2_cl_catalog_product_bundle_option              |
| mgbv_m2_cl_catalog_product_bundle_option_value        |
| mgbv_m2_cl_catalog_product_bundle_selection           |
| mgbv_m2_cl_catalog_product_bundle_selection_price     |
| mgbv_m2_cl_catalog_product_entity                     |
| mgbv_m2_cl_catalog_product_entity_datetime            |
| mgbv_m2_cl_catalog_product_entity_decimal             |
| mgbv_m2_cl_catalog_product_entity_group_price         |
| mgbv_m2_cl_catalog_product_entity_int                 |
| mgbv_m2_cl_catalog_product_entity_media_gallery       |
| mgbv_m2_cl_catalog_product_entity_media_gallery_value |
| mgbv_m2_cl_catalog_product_entity_text                |
| mgbv_m2_cl_catalog_product_entity_tier_price          |
| mgbv_m2_cl_catalog_product_entity_varchar             |
| mgbv_m2_cl_catalog_product_link                       |
| mgbv_m2_cl_catalog_product_link_attribute             |
| mgbv_m2_cl_catalog_product_link_attribute_decimal     |
| mgbv_m2_cl_catalog_product_link_attribute_int         |
| mgbv_m2_cl_catalog_product_link_attribute_varchar     |
| mgbv_m2_cl_catalog_product_option                     |
| mgbv_m2_cl_catalog_product_option_price               |
| mgbv_m2_cl_catalog_product_option_title               |
| mgbv_m2_cl_catalog_product_option_type_price          |
| mgbv_m2_cl_catalog_product_option_type_title          |
| mgbv_m2_cl_catalog_product_option_type_value          |
| mgbv_m2_cl_catalog_product_relation                   |
| mgbv_m2_cl_catalog_product_super_attribute            |
| mgbv_m2_cl_catalog_product_super_attribute_label      |
| mgbv_m2_cl_catalog_product_super_attribute_pricing    |
| mgbv_m2_cl_catalog_product_super_link                 |
| mgbv_m2_cl_catalog_product_website                    |
| mgbv_m2_cl_cataloginventory_stock_item                |
| mgbv_m2_cl_core_url_rewrite                           |
| mgbv_m2_cl_customer_address_entity                    |
| mgbv_m2_cl_customer_address_entity_datetime           |
| mgbv_m2_cl_customer_address_entity_decimal            |
| mgbv_m2_cl_customer_address_entity_int                |
| mgbv_m2_cl_customer_address_entity_text               |
| mgbv_m2_cl_customer_address_entity_varchar            |
| mgbv_m2_cl_customer_entity                            |
| mgbv_m2_cl_customer_entity_datetime                   |
| mgbv_m2_cl_customer_entity_decimal                    |
| mgbv_m2_cl_customer_entity_int                        |
| mgbv_m2_cl_customer_entity_text                       |
| mgbv_m2_cl_customer_entity_varchar                    |
| mgbv_m2_cl_downloadable_link                          |
| mgbv_m2_cl_downloadable_link_price                    |
| mgbv_m2_cl_downloadable_link_purchased                |
| mgbv_m2_cl_downloadable_link_purchased_item           |
| mgbv_m2_cl_downloadable_link_title                    |
| mgbv_m2_cl_downloadable_sample                        |
| mgbv_m2_cl_downloadable_sample_title                  |
| mgbv_m2_cl_eav_entity_store                           |
| mgbv_m2_cl_gift_message                               |
| mgbv_m2_cl_log_visitor                                |
| mgbv_m2_cl_newsletter_subscriber                      |
| mgbv_m2_cl_rating_option_vote                         |
| mgbv_m2_cl_rating_option_vote_aggregated              |
| mgbv_m2_cl_report_compared_product_index              |
| mgbv_m2_cl_report_event                               |
| mgbv_m2_cl_report_viewed_product_index                |
| mgbv_m2_cl_review                                     |
| mgbv_m2_cl_review_detail                              |
| mgbv_m2_cl_review_entity_summary                      |
| mgbv_m2_cl_review_store                               |
| mgbv_m2_cl_sales_flat_creditmemo                      |
| mgbv_m2_cl_sales_flat_creditmemo_grid                 |
| mgbv_m2_cl_sales_flat_creditmemo_item                 |
| mgbv_m2_cl_sales_flat_invoice                         |
| mgbv_m2_cl_sales_flat_invoice_grid                    |
| mgbv_m2_cl_sales_flat_invoice_item                    |
| mgbv_m2_cl_sales_flat_order                           |
| mgbv_m2_cl_sales_flat_order_address                   |
| mgbv_m2_cl_sales_flat_order_grid                      |
| mgbv_m2_cl_sales_flat_order_item                      |
| mgbv_m2_cl_sales_flat_order_payment                   |
| mgbv_m2_cl_sales_flat_order_status_history            |
| mgbv_m2_cl_sales_flat_quote                           |
| mgbv_m2_cl_sales_flat_quote_address                   |
| mgbv_m2_cl_sales_flat_quote_address_item              |
| mgbv_m2_cl_sales_flat_quote_item                      |
| mgbv_m2_cl_sales_flat_quote_item_option               |
| mgbv_m2_cl_sales_flat_quote_payment                   |
| mgbv_m2_cl_sales_flat_quote_shipping_rate             |
| mgbv_m2_cl_sales_flat_shipment                        |
| mgbv_m2_cl_sales_flat_shipment_comment                |
| mgbv_m2_cl_sales_flat_shipment_grid                   |
| mgbv_m2_cl_sales_flat_shipment_item                   |
| mgbv_m2_cl_sales_flat_shipment_track                  |
| mgbv_m2_cl_sales_order_tax                            |
| mgbv_m2_cl_sales_order_tax_item                       |
| mgbv_m2_cl_sales_payment_transaction                  |
| mgbv_m2_cl_wishlist                                   |
| mgbv_m2_cl_wishlist_item                              |
| mgbv_m2_cl_wishlist_item_option                       |
| mgbv_magegiant_dailydeal                              |
| mgbv_magenotification                                 |
| mgbv_magenotification_extension_feedback              |
| mgbv_magenotification_extension_feedbackmessage       |
| mgbv_magenotification_license                         |
| mgbv_magenotification_log                             |
| mgbv_newsletter_problem                               |
| mgbv_newsletter_queue                                 |
| mgbv_newsletter_queue_link                            |
| mgbv_newsletter_queue_store_link                      |
| mgbv_newsletter_subscriber                            |
| mgbv_newsletter_template                              |
| mgbv_oauth_consumer                                   |
| mgbv_oauth_nonce                                      |
| mgbv_oauth_token                                      |
| mgbv_oneall_sociallogin_entity                        |
| mgbv_outofstock                                       |
| mgbv_paypal_cert                                      |
| mgbv_paypal_payment_transaction                       |
| mgbv_paypal_settlement_report                         |
| mgbv_paypal_settlement_report_row                     |
| mgbv_permission_block                                 |
| mgbv_permission_variable                              |
| mgbv_persistent_session                               |
| mgbv_plumbase_product                                 |
| mgbv_plumrocket_search_fulltext                       |
| mgbv_poll                                             |
| mgbv_poll_answer                                      |
| mgbv_poll_store                                       |
| mgbv_poll_vote                                        |
| mgbv_product_alert_price                              |
| mgbv_product_alert_stock                              |
| mgbv_rating                                           |
| mgbv_rating_entity                                    |
| mgbv_rating_option                                    |
| mgbv_rating_option_vote                               |
| mgbv_rating_option_vote_aggregated                    |
| mgbv_rating_store                                     |
| mgbv_rating_title                                     |
| mgbv_recaptcha                                        |
| mgbv_report_compared_product_index                    |
| mgbv_report_event                                     |
| mgbv_report_event_types                               |
| mgbv_report_viewed_product_aggregated_daily           |
| mgbv_report_viewed_product_aggregated_monthly         |
| mgbv_report_viewed_product_aggregated_yearly          |
| mgbv_report_viewed_product_index                      |
| mgbv_review                                           |
| mgbv_review_detail                                    |
| mgbv_review_entity                                    |
| mgbv_review_entity_summary                            |
| mgbv_review_status                                    |
| mgbv_review_store                                     |
| mgbv_rewards_history                                  |
| mgbv_rewards_points                                   |
| mgbv_sales_bestsellers_aggregated_daily               |
| mgbv_sales_bestsellers_aggregated_monthly             |
| mgbv_sales_bestsellers_aggregated_yearly              |
| mgbv_sales_billing_agreement                          |
| mgbv_sales_billing_agreement_order                    |
| mgbv_sales_flat_creditmemo                            |
| mgbv_sales_flat_creditmemo_comment                    |
| mgbv_sales_flat_creditmemo_grid                       |
| mgbv_sales_flat_creditmemo_item                       |
| mgbv_sales_flat_invoice                               |
| mgbv_sales_flat_invoice_comment                       |
| mgbv_sales_flat_invoice_grid                          |
| mgbv_sales_flat_invoice_item                          |
| mgbv_sales_flat_order                                 |
| mgbv_sales_flat_order_address                         |
| mgbv_sales_flat_order_grid                            |
| mgbv_sales_flat_order_item                            |
| mgbv_sales_flat_order_payment                         |
| mgbv_sales_flat_order_status_history                  |
| mgbv_sales_flat_quote                                 |
| mgbv_sales_flat_quote_address                         |
| mgbv_sales_flat_quote_address_item                    |
| mgbv_sales_flat_quote_item                            |
| mgbv_sales_flat_quote_item_option                     |
| mgbv_sales_flat_quote_payment                         |
| mgbv_sales_flat_quote_shipping_rate                   |
| mgbv_sales_flat_shipment                              |
| mgbv_sales_flat_shipment_comment                      |
| mgbv_sales_flat_shipment_grid                         |
| mgbv_sales_flat_shipment_item                         |
| mgbv_sales_flat_shipment_track                        |
| mgbv_sales_invoiced_aggregated                        |
| mgbv_sales_invoiced_aggregated_order                  |
| mgbv_sales_order_aggregated_created                   |
| mgbv_sales_order_aggregated_updated                   |
| mgbv_sales_order_status                               |
| mgbv_sales_order_status_label                         |
| mgbv_sales_order_status_state                         |
| mgbv_sales_order_tax                                  |
| mgbv_sales_order_tax_item                             |
| mgbv_sales_payment_transaction                        |
| mgbv_sales_recurring_profile                          |
| mgbv_sales_recurring_profile_order                    |
| mgbv_sales_refunded_aggregated                        |
| mgbv_sales_refunded_aggregated_order                  |
| mgbv_sales_shipping_aggregated                        |
| mgbv_sales_shipping_aggregated_order                  |
| mgbv_salesrule                                        |
| mgbv_salesrule_coupon                                 |
| mgbv_salesrule_coupon_usage                           |
| mgbv_salesrule_customer                               |
| mgbv_salesrule_customer_group                         |
| mgbv_salesrule_label                                  |
| mgbv_salesrule_product_attribute                      |
| mgbv_salesrule_website                                |
| mgbv_sendfriend_log                                   |
| mgbv_shipping_tablerate                               |
| mgbv_sitemap                                          |
| mgbv_smsnotify_register_otp                           |
| mgbv_smsnotify_report                                 |
| mgbv_tag                                              |
| mgbv_tag_properties                                   |
| mgbv_tag_relation                                     |
| mgbv_tag_summary                                      |
| mgbv_tawk_widget                                      |
| mgbv_tax_calculation                                  |
| mgbv_tax_calculation_rate                             |
| mgbv_tax_calculation_rate_title                       |
| mgbv_tax_calculation_rule                             |
| mgbv_tax_class                                        |
| mgbv_tax_order_aggregated_created                     |
| mgbv_tax_order_aggregated_updated                     |
| mgbv_webplanet_dailydeal_deal                         |
| mgbv_weee_discount                                    |
| mgbv_weee_tax                                         |
| mgbv_widget                                           |
| mgbv_widget_instance                                  |
| mgbv_widget_instance_page                             |
| mgbv_widget_instance_page_layout                      |
| mgbv_wishlist                                         |
| mgbv_wishlist_item                                    |
| mgbv_wishlist_item_option                             |
+-------------------------------------------------------+
483 rows in set (0.00 sec)



Highlighted

Re: Base table or view not found issue in Migration

Hi @foysal 

Kindly refer below link:
https://github.com/mailchimp/mc-magento2/issues/113

It may help you to resolve issue.

Highlighted

Re: Base table or view not found issue in Migration

Hi @foysal ,

 

According to your list it seems like your last table name in Magento 1 database is core_website.

Please confirm?

If yes, then it seems like your magento 1 database is not completed.

 

Thanks!

Highlighted

Re: Base table or view not found issue in Migration

Hi @foysal ,

Can you please confirm some points:

1. How many times have you attempted migration on this database of magento 1.?

2. Could you please count tables of your real database of magento 1 and the one you are using for migration are same.? 

3. If possible, can you try migration on fresh magento 1 database and with fresh magento 2 database again.?

 

Thanks!

Problem Solved! Click Kudos & Accept as Solution!

Highlighted

Re: Base table or view not found issue in Migration

Thanks @Nishu Jindal . I replied total table list in 2 portion. `core_website` is the last table of first portion. Thanks.

Highlighted

Re: Base table or view not found issue in Migration

Hi @foysal ,

 

Can you please check my last comment related to some points.

 

Thanks!

Problem Solved! Click Kudos & Accept as Solution!

Highlighted

Re: Base table or view not found issue in Migration

Thanks @Nishu Jindal . Here are your answers.

1. How many times have you attempted migration on this database of magento 1.?

Ans - I tried several times.

2. Could you please count tables of your real database of magento 1 and the one you are using for migration are same.?
Ans - Actually I don't know how many tables are there in Magento 1.  Previously I mentioned all the table names of my Magento 1.

3. If possible, can you try migration on fresh magento 1 database and with fresh magento 2 database again.?
Ans - I'll try migration on fresh magento 1 database and with fresh magento 2 database again after fixing this issue.

Thanks.