magento在改版网站时，需在另外一个模拟站，进行网站的改版和调试，当改好时，如何将自在运营中的magento的客户和订单数据迁移新站呢，以我把我订单和客户所涉及的数据库罗列如下

订单：

 

magento批量导入导出客订单数据

mysqldump -u用户 -p密码  magento数据库 sales_bestsellers_aggregated_daily sales_bestsellers_aggregated_monthly sales_bestsellers_aggregated_yearly sales_billing_agreement sales_billing_agreement_order sales_flat_creditmemo sales_flat_creditmemo_comment sales_flat_creditmemo_grid sales_flat_creditmemo_item sales_flat_invoice sales_flat_invoice_comment sales_flat_invoice_grid sales_flat_invoice_item sales_flat_order sales_flat_order_address sales_flat_order_grid sales_flat_order_item sales_flat_order_payment sales_flat_order_status_history sales_flat_quote sales_flat_quote_address sales_flat_quote_address_item sales_flat_quote_item sales_flat_quote_item_option sales_flat_quote_payment sales_flat_quote_shipping_rate sales_flat_shipment sales_flat_shipment_comment sales_flat_shipment_grid sales_flat_shipment_item sales_flat_shipment_track sales_invoiced_aggregated sales_invoiced_aggregated_order sales_order_aggregated_created sales_order_status sales_order_status_label sales_order_status_state sales_order_tax sales_payment_transaction sales_recurring_profile sales_recurring_profile_order sales_refunded_aggregated sales_refunded_aggregated_order sales_shipping_aggregated sales_shipping_aggregated_order salesrule salesrule_coupon salesrule_coupon_usage salesrule_customer salesrule_label salesrule_product_attribute wishlist eav_entity_store>order.sql

eav_entity_store 是记录了订单的一些最后一个Id号资料，这个不拷，会在支付最后一步出错的！

 

客户

 

magento批量导入导出客户资料

mysqldump -u用户 -p密码  magento数据库 customer_address_entity customer_address_entity_datetime customer_address_entity_decimal customer_address_entity_int customer_address_entity_text customer_address_entity_varchar customer_eav_attribute customer_eav_attribute_website customer_entity customer_entity_datetime customer_entity_decimal customer_entity_int customer_entity_text customer_entity_varchar customer_form_attribute customer_group log_customer>custom.sql

将上述运营站导出的表，导入到新版的站中，即可实现客户和订单的迁移.