Migrate SQL users table but keep their original id's

Question

How to copy users table between wordpress databases but keep their original id from the origin table?

when I export -> import users to a new table, the new id's are written incrementally instead of getting the original id's

I expect user id 567 in the new table to get the user id 567 in the new table even though there are no users in id numbers 2 to 566.

Answer 1

when you export you database via phpmyadmin, in the "Object creation options" you can tick off the "auto_increment value" to export the database in the original id's as the table you are exporting.