-
That wasn't my question. and your answer was very generic. I know all those links. Please would you mind reading my post again? Thank you!
Regarding preserving IDs sequences: it isn't good solution in my opinion, however it's still possible to change autoincrement value for the table by executing the following query, considering it doesn't include any existing IDs:
ALTER TABLE `table_name_here` AUTO_INCREMENT = 123;