I accidentally used the "Generate Description" feature on the Opencart SEO tool and it overwrote all of my product descriptions with the product title.
I have over 600 products and it would be a pain to remake them all.
I have a MYSQL backup that is 2 months old and contains most of the products except about 20 that were added later.
I have imported an old backup into a newly created database, what query can I run to copy and overwrite all the description column data from the backup table into the current table?
They are located at database.oc_product_description.description
Any help is greatly appreciated. This is driving me crazy
If the two schemas are located in the same MySQL instance, please use the
REPLACE INTO
statement (backup before operation)老 means: restored database Database means: current database
This statement will replace the data with the primary key
If you don't want to copy the entire table, do an update and copy the data from the old table to the database (product_id and language_id columns are primary keys)