Restart Discussion ID Numbering

[deleted]

Hello,
I wanted to start Flarum instance from scratch in terms of its content (deleted discussions and posts). Now, when I open a new discussion it gets ID starting from 400 (yes, I had so many test discussions/titles). How can I "restart" this so my first discussion and post ID could be "1"... Discussion ID is visible in discussion's URL

I.E. This Discussion has this ID: /d/21758-restart-discussion-id-numbering

clarkwinkelmann

[deleted] this happens at the MySQL level, here's how to reset the increment ID https://stackoverflow.com/questions/8923114/how-to-reset-auto-increment-in-mysql

TL;DR: Running an SQL query like this should reset the count (adjust table prefix if needed):

ALTER TABLE discussions AUTO_INCREMENT = 1

Tip: If you TRUNCATE the table instead of deleting individual rows, it will also reset the auto-increment. This can be good to know when using a Flarum for testing purposes.

[deleted]

clarkwinkelmann ALTER TABLE discussions AUTO_INCREMENT = 1

Where can I find this table/row 😀
Thanks for your reply and help, @clarkwinkelmann

sorry, I have to read this link: https://stackoverflow.com/questions/8923114/how-to-reset-auto-increment-in-mysql

clarkwinkelmann

[deleted] oops forgot to say it's an SQL query 🙉 I'll do a quick costmetic update to my post for future reference.

[deleted]

So,
in phpMyAdmin I found my flarum related database, visited xxx_discussions table, in the Operation Tab I found TABLE OPTIONS - AUTO_INCREMENT (was 400+), just returned it to "1"

clarkwinkelmann

[deleted] with phpMyAdmin it's indeed even easier 👍️