Topic: Setting Blog IDs back to 1 · BuddyPress.org

Skip to:: Content; Pages; Categories; Search; Top; Bottom

Setting Blog IDs back to 1

Nick Watson
Participant

@nickbwatson

14 years, 10 months ago

I’ve been creating a few blogs (just for testing).

And I’ve noticed that every time I create a blog, then delete it, the next blog I create will have the NEXT ID number, it doesn’t reset to 1 if I only have 1 blog.

Anyway to reset it? Or where can i find the file that the ID is created?

Thanks

Viewing 6 replies - 1 through 6 (of 6 total)

Paul Wong-Gibbs
Keymaster

@djpaul

14 years, 10 months ago

You can’t; this is a result of the blog IDs being set by an auto-increment primary key integer in the MySQL database. You could do something like export the database, drop the table (wp_sites, or something), create the table again and re-import your data.

However I am not sure of the consequence on WordPress of this being done so not recommended unless you have time to check all the tables and update references where needed.

Nick Watson
Participant

@nickbwatson

14 years, 10 months ago

Ah, okay.

Well I’ll have a look and see what I can do, if it’s an issue then it’s not a problem. I was just annoyed with the numbers.

Jean-Pierre Michaud
Participant

@nexia

14 years, 10 months ago

numbers will do nothing on your site, people are not ranking their position on a site based on the id of their blog… google either…

Andrea Rennick
Participant

@andrea_r

14 years, 10 months ago

The blog ID numbers are only used internally.

Nick Watson
Participant

@nickbwatson

14 years, 10 months ago

I know they’re just internal, I was just curious.

Andrea Rennick
Participant

@andrea_r

14 years, 10 months ago

If you really really wanted to, look in wp_signups. They don’t get cleaned out on delete (partly to prevent deleted spammers from signing up again with the same info).

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Setting Blog IDs back to 1’ is closed to new replies.