Merging WordPress data between two databases is challenging because IDs may be deeply encoded in char fields inside base64-ed JSON structures and such. We need a way to identify likely IDs and rewrite them between two different ID spaces (local and remote). Setting all autoincrement fields to a large randomized offset such as 186452724000000 would provide a useful prefix for guessing what is an id and what isn't.
Merging WordPress data between two databases is challenging because IDs may be deeply encoded in char fields inside base64-ed JSON structures and such. We need a way to identify likely IDs and rewrite them between two different ID spaces (local and remote). Setting all autoincrement fields to a large randomized offset such as
186452724000000would provide a useful prefix for guessing what is an id and what isn't.