I need to integrate two databases, and shift the id’s of two of the imported datasets to avoid collisions. There’s got to be an easy way to do this….
to be more specific, I merged two mydns mysql databases.
UPDATE `rr` SET zone=zone+1000;
UPDATE `rr` SET id=id+600
UPDATE `soa` SET id=id+200;
Had a couple of hiccups with exporting and importing, but its all done now and seemingly running smooth.