You know you do too many drugs when this happens. And you know you are online a bit too long once you find this. I’m actually tempted to respond to the latter one.
Oh man, it’s the autoincrement values on the primary keys, if you can dump the tables without the ID in each entry and then let it assign an ID on import (leave that column out of the INSERT so that the auto-value gets used) you’ll probably get everything, but I can’t guarantee that the timestamps and the like will be correct. I don’t have direct experience with the WP DB structures to work from.
Robby
November 22, 2020 @ 8:46 pm
Oh man, it’s the autoincrement values on the primary keys, if you can dump the tables without the ID in each entry and then let it assign an ID on import (leave that column out of the INSERT so that the auto-value gets used) you’ll probably get everything, but I can’t guarantee that the timestamps and the like will be correct. I don’t have direct experience with the WP DB structures to work from.
jimmy
November 22, 2020 @ 10:03 pm
So my problem is I don’t know how to get it to dump without that column. The timestamps should still be correct because that’s its own column.