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

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

Setting Blog IDs back to 1

@nickbwatson

Participant

14 years, 11 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)

@djpaul

Keymaster

14 years, 11 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.

@nickbwatson

Participant

14 years, 11 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.

@nexia

Participant

14 years, 11 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_r

Participant

14 years, 11 months ago

The blog ID numbers are only used internally.

@nickbwatson

Participant

14 years, 11 months ago

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

@andrea_r

Participant

14 years, 11 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.