fireridlle Posted May 7, 2014 Share Posted May 7, 2014 Hi, how are you? I need to merge data. I have .sh script, which makes dump. But when i tried to restore from this backup i got error "Column count doesn't match value count at row 1". I wondered if someone can help me with this issue. The reason why i don't want to truncate tables, because i don't know if there any necessary data. #/usr/bin bash echo "enter login" read SQL_LOGIN echo "enter pass" read SQL_PASS mysqldump -u $SQL_LOGIN -p$SQL_PASS podorozhe_db --no-create-db --no-create-info --restore --tables\ ps_shops_cat\ ps_shops_brand\ ps_category_group\ ps_category_lang\ ps_category_shop\ ps_cms_category\ ps_cms_category_lang\ ps_group\ ps_group_lang\ ps_group_shop\ ps_contact\ ps_contact_lang\ ps_contact_shop\ ps_delivery\ ps_profile\ ps_profile_lang\ ps_access\ ps_carrier_lang\ ps_carrier_group\ ps_carrier_shop\ ps_carrier_tax_rules_group_shop\ ps_carrier_zone\ ps_product_lang\ ps_product_comment\ ps_product_comment_criterion\ ps_product_comment_criterion_category\ ps_product_comment_criterion_lang\ ps_product_comment_criterion_product\ ps_product_comment_grade\ ps_product_comment_report\ ps_shop_url\ ps_webservice_account\ ps_webservice_account_shop\ ps_webservice_permission\ ps_employee\ ps_employee_shop\ ps_guest\ ps_web_browser\ ps_customer_group\ ps_customer\ ps_operating_system\ ps_connections\ ps_connections_page\ ps_page\ ps_page_type\ ps_connections_source\ ps_risk\ ps_risk_lang\ ps_page_viewed\ ps_referrer\ ps_referrer_shop\ ps_referrer_cache\ ps_date_range\ ps_address\ ps_gender_lang\ ps_gender\ ps_customer_message_sync_imap\ ps_customer_message\ ps_customer_thread\ ps_address_format\ ps_order_return_state_lang\ ps_order_return_state\ ps_order_return\ ps_order_detail_tax\ ps_order_slip\ ps_order_slip_detail\ ps_order_detail\ ps_order_state\ ps_order_history\ ps_order_state_lang\ ps_order_message_lang\ ps_orders\ ps_order_return_detail\ ps_order_message\ ps_order_cart_rule\ ps_order_invoice_tax\ ps_supply_order\ ps_supply_order_receipt_history\ ps_supply_order_detail\ ps_message\ ps_message_readed\ ps_supply_order_history\ ps_supply_order_state_lang\ ps_supply_order_state\ ps_cart_product\ ps_cart\ ps_cart_rule_product_rule_group\ ps_cart_rule_product_rule\ ps_cart_rule_product_rule_value\ ps_cart_cart_rule\ ps_cart_rule_country\ ps_cart_rule_lang\ ps_cart_rule_carrier\ ps_cart_rule_group\ ps_cart_rule_combination\ ps_cart_rule_shop\ ps_cart_rule\ ps_accessory\ ps_product_tag\ ps_product_download\ ps_product\ ps_tag\ ps_pack\ ps_product_attachment\ ps_attachment\ ps_attachment_lang\ ps_product_shop\ ps_category_product\ ps_customized_data\ ps_attribute_lang\ ps_product_sale\ ps_compare_product\ ps_product_group_reduction_cache\ ps_product_attribute_shop\ ps_compare\ ps_product_attribute\ ps_product_attribute_combination\ ps_product_attribute_image\ ps_attribute_impact\ ps_attribute\ ps_product_supplier\ ps_attribute_shop\ ps_attribute_group_lang\ ps_attribute_group\ ps_customization\ ps_attribute_group_shop\ ps_scene\ ps_customization_field_lang\ ps_customization_field\ ps_scene_shop\ ps_scene_lang\ ps_feature_value\ ps_feature_value_lang\ ps_feature\ ps_feature_shop\ ps_image_shop\ ps_image\ ps_image_lang\ ps_image_type\ ps_soc_users\ ps_soc_type\ ps_mails\ > dump.sql Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now