Skip to:
Content
Pages
Categories
Search
Top
Bottom

Re: Manually reset user id to higher number?


peterverkooijen
Participant

@peterverkooijen

2000 insert/deletes. It’s gonna be a long night… ;-(

Is inflate the technical term?

Found this somewhere:

If you just want to change the auto_increment without deleting everything, you can

ALTER TABLE tbl_name AUTO_INCREMENT = xxx

(where xxx is an integer). Or use the operations page in phpmyadmin …

But what table(s?) should I apply that to? Only wp_users? Would the rest automatically follow?

Scary stuff

Skip to toolbar