这是我的操作方式.我当时在根目录下的测试文件夹中建立了一家新商店，与此同时，生产过程中出现了销售，新产品/客户以及库存变化.

Here's how I did this. I was building a new store in a test folder off root, and in the meantime production had sales, new products/customers and also inventory changes obviously.

您还需要获取所有的mage_cataloginventory_stock表:

You also need to get all mage_cataloginventory_stock tables:

mage_cataloginventory_stock
mage_cataloginventory_stock_item
mage_cataloginventory_stock_status
mage_cataloginventory_stock_idx
mage_cataloginventory_stock_tmp

• 禁用编译器和缓存，清除缓存

除了以上答案中列出的正确的表外，删除我的表后(在拖放时禁用外键检查，从phpmyadmin截断不起作用)，这是要做的事

In addition to the tables listed in the above answer, which are correct, upon dropping my tables (disable foreign key checks at drop, truncate didn't work from phpmyadmin), here's what to do

• 导入数据
• 重新编制索引.

媒体(图像)与安装URL有关，因此，我将生产存储从根目录移到了子目录，一切都很好.

Media (images) are related to install URL, so, I was moving a production store in root directory to sub directory and all was fine.

先备份目标数据库.