RUN SQL
mysql config details in [login to view URL]
select old_asinid,new_asinid from combine_asin_log where img_copied='no'
example output
| old_asinid | new_asinid |
+------------+------------+
| 135997 | 173739 |
| 135998 | 173740 |
| 136000 | 173741 |
| 136001 | 173742 |
for each old_asinid
RUN
sql1=select img_id,encrypt from AmazonImageList where asin_id=[old_asinid];
for each img_id then run
sql2=select encrypt from AmazonImageList where asin_id=[new_asinid] and img_id=[img_id from above]
Run sql select country from amazonASIN where id=old_asinid
copy /path1/[country]/[encrypt from sql1] to /path2/[country]/[encrypt from sql2]
Run update combine_asin_log set img_copied='yes' where new_asinid=[new_asinid]