Jump to content

merge db 1.5 & 1.6


Recommended Posts

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...