mark_roach - 12:37 pm on Oct 4, 2011 (gmt 0)

Just realised you have the data in a seperate database. Never done this but I think the following should work :

update db1.table, db2.table set db1.table.cola=db2.table.cola where db1.table.colb=db2.table.colb

If ir doesn't just dump the table you need from the backup using mysldump and then import it into the original database using a different name and use the SQL in my first post.