Reseting Auto Increment for Indexes?

[Matthias Karl]

I have a bunch of tables that have seen a lot of activity for a long time already . The indexes are bigint fields populated with auto increment in two tables. The auto increment value is close to a billion by now, the other at 500 million. Table 2 is linked to table 1 via the index field of table 1.

I am wondering what the best way would be to reset the index values of the two tables. If it was only one table, I could just copy the structure, make an INSERT FROM INTO new_table, but how will I be able to do that with table 2 and the link to table 1 when the index suddenly changes?