The downside to this is that the user ids of some users are too high, even though my new forum only has about 20 members or so (t the latest member has an id in the hundreds). I realise that the user id is used in a lot of tables so you can't simply change it. Also, auto increment means that new users will be set in the hundreds so all future members will be affected by this.
Perhaps this is irrelevant but I'd like to correct it. What's the quickest way to resolve this?
At the moment the user ids are:
Is it possible to change the database directly and reorganise the ids in order so that they go from 1 to 29?
Would exporting the users and content and importing them back in resolve this?