CODEWITHSUNDEEP
mysqlmagentophpmyadmin
Matt
Matt

Reputation: 1757

phpMyAdmin Magento Price Update

I have backup of my Magento database, somehow I need to update the database that is on the live site with the prices from the old database backup I have exported mg_catalog_product_index_price.sql but not sure if there are any more tables.

I need to somehow import that table onto the live site database, when i tried to just use the import tab in phpMyAdmin I got this error.

#1062 - Duplicate entry '108-0-1' for key 'PRIMARY'

Anyone shed some light on this?

Upvotes: 1

Views: 1346

Answers (1)

Tim Bezhashvyly
Tim Bezhashvyly

Reputation: 9100

Please note that "Structure" is unchecked ad "Export type" is set to "UPDATE":

enter image description here

Upvotes: 1

Related Questions