i'm not sure to get what you want to do exactly.
If you just want to get a clean start for once, just drop all 3 tables (accounts, character_ and inventory, plus char and corpse backup) and start over on fresh clean tables, creating admin account. It'll start from id 1 on all tables, and no char/account/inventory pbs
If you plan to make a system to backup char info, tweak database, then reinsert char info ... well it's a bit harder. i could only advise you to backup every step :/
Basically, if you want to remove only some old account or chars, just delete the rows, and let mysql skip over the empty slots. It's the RDBMS engine's job to access rows equally fast whether contiguous id or not.
|