Title: Reset multisite ID’s
Last modified: August 25, 2020

---

# Reset multisite ID’s

 *  Resolved [vons](https://wordpress.org/support/users/vons/)
 * (@vons)
 * [5 years, 8 months ago](https://wordpress.org/support/topic/reset-multisite-ids/)
 * Hello!
    I recently created a multisite network and added a subsite that I was
   going to import content into from another WP installation. But I ran into some
   issues in the export/import process and it became a bit off a mess, so I decided
   to delete the subsite and just create a fresh new one to avoid any issues.
 * This new subsite got ID#3 and /03/ in the uploads folder, it’s not a major issue
   in any way. But I was curious if it’s possible to delete the new subsite, reset
   the counter and create a new one with ID#2? I read around and [it seems like you can](https://derekshirk.com/reseting-the-wordpress-multisite-blog-id/).
   Does anyone here have experience with this?
 * Thanks!
    -  This topic was modified 5 years, 8 months ago by [James Huff](https://wordpress.org/support/users/macmanx/).
      Reason: moved to Networking WordPress since this is a multisite issue

Viewing 3 replies - 16 through 18 (of 18 total)

[←](https://wordpress.org/support/topic/reset-multisite-ids/?output_format=md) [1](https://wordpress.org/support/topic/reset-multisite-ids/?output_format=md)
2

 *  Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * (@bcworkz)
 * [5 years, 8 months ago](https://wordpress.org/support/topic/reset-multisite-ids/page/2/#post-13393146)
 * Sorry I missed your earlier reply, it’s been a hectic few days IRL.
 * There was nothing in blog meta when I tried this out on my site. However, since
   then, the site was updated and there are entries related to DB version and when
   it was updated. They only relate to blog_id 1. You’ll want to keep anything related
   to blog_id 1 and delete anything related to removed blogs. You’ll then want to
   reset that table’s auto_increment to one more than the highest numbered meta_id
   value.
 * So other than not necessarily removing everything for item 1c, I think you have
   a clear understanding of what’s involved.
 *  Thread Starter [vons](https://wordpress.org/support/users/vons/)
 * (@vons)
 * [5 years, 8 months ago](https://wordpress.org/support/topic/reset-multisite-ids/page/2/#post-13398847)
 * No worries! I’ve had a couple of things myself.
 * Great! Sorry if it sounds like I’m repeating myself, it’s just been a pretty 
   terrible experience with this site moving project. And I was just a bit surprised
   that this process was so straightforward compared to the other things that have
   occurred.
 * Thanks again, I’ll get back to this thread when I get around to moving forward
   with this part!
 *  Thread Starter [vons](https://wordpress.org/support/users/vons/)
 * (@vons)
 * [5 years, 6 months ago](https://wordpress.org/support/topic/reset-multisite-ids/page/2/#post-13664535)
 * Hello again,
    Sorry for the wait, but there’s been a lot going on which has kept
   me from going forward with this.
 * Thankfully, it all went with a breeze! Here was the process:
    1.  Deleted the old `_2_` tables (in phpMyAdmin after backing those up)
        Deleted
       the “new” subsite with ID#3 in the network’s website page Deleted its leftover`/
       3/` uploads folder in `/wp-content/uploads/sites/` Deleted its `_3_` tables (
       again, in phpMyAdmin after backing those up) Created a new subsite with the “
       old” name and URL Success!
 * Hopefully this’ll help another perfectionist in the future who’s annoyed with
   incrementing ID’s in the uploads folder, DB etc.
 * Big thanks again [@bcworkz](https://wordpress.org/support/users/bcworkz/) for
   the help and trying it out yourself, really appreciate it!

Viewing 3 replies - 16 through 18 (of 18 total)

[←](https://wordpress.org/support/topic/reset-multisite-ids/?output_format=md) [1](https://wordpress.org/support/topic/reset-multisite-ids/?output_format=md)
2

The topic ‘Reset multisite ID’s’ is closed to new replies.

## Tags

 * [auto-increment](https://wordpress.org/support/topic-tag/auto-increment/)
 * [multisite](https://wordpress.org/support/topic-tag/multisite/)

 * In: [Networking WordPress](https://wordpress.org/support/forum/multisite/)
 * 18 replies
 * 2 participants
 * Last reply from: [vons](https://wordpress.org/support/users/vons/)
 * Last activity: [5 years, 6 months ago](https://wordpress.org/support/topic/reset-multisite-ids/page/2/#post-13664535)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics