Description

AUTO_INCREMENT values in MySQL can be modified. So, after a rollback...

Steps
  1. set AUTO_INCREMENT id to the next proper ID according to the new content
  2. reimport / resync new content back into the older restored site maintaining ID's