I'm trying to move a live site to a dev server. Export SQL has been done with phpmyadmin. When importing via CLI; mysql -u "user" -p "name_new_database" < bupsqlfile.sql

I get this error: ERROR 1062 (23000) at line 4659855: Duplicate entry 'NULL' for key 'sales_order_grid.SALES_ORDER_GRID_PICKUP_LOCATION_CODE'

The part where the line number refers to :

-- -- Indexes for table sales_order_grid-- ALTER TABLEsales_order_grid ADD PRIMARY KEY (entity_id), ADD UNIQUE KEY SALES_ORDER_GRID_INCREMENT_ID_STORE_ID (increment_id,store_id), ADD KEY SALES_ORDER_GRID_STATUS (status), ADD KEY SALES_ORDER_GRID_STORE_ID (store_id), ADD KEY SALES_ORDER_GRID_BASE_GRAND_TOTAL (base_grand_total), ADD KEY SALES_ORDER_GRID_BASE_TOTAL_PAID (base_total_paid), ADD KEY SALES_ORDER_GRID_GRAND_TOTAL (grand_total), ADD KEY SALES_ORDER_GRID_TOTAL_PAID (total_paid), ADD KEY SALES_ORDER_GRID_SHIPPING_NAME (shipping_name), ADD KEY SALES_ORDER_GRID_BILLING_NAME (billing_name), ADD KEY SALES_ORDER_GRID_CREATED_AT (created_at), ADD KEY SALES_ORDER_GRID_CUSTOMER_ID (customer_id), ADD KEY SALES_ORDER_GRID_UPDATED_AT (updated_at), ADD KEY SALES_ORDER_GRID_PICKUP_LOCATION_CODE (pickup_location_code); ALTER TABLE sales_order_gridADD FULLTEXT KEYFTI_randomkeygoeshere (increment_id,billing_name,shipping_name,shipping_address,billing_address,customer_name,customer_email);

When I look in the table "sales_order_grid" most records have the value "null" in the key "pickup_location_code"

What can I do to go ahead with the import?

I've tried disabling the foreign key check, but without success.

1 Answer 1


Ok, lesson learned... I shouldn't have done the export via phpmyadmin...

Done the export via CLI and solved it!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.