UseBB Community

Is there a way to delete all forums except forum-1.html and the next will forum-2 and so on.

Probably within phpMyAdmin I would guess, but not sure how yet.

Thanks.

You can reset auto increment on a table using

ALTER TABLE table AUTO_INCREMENT = x

Of course you first need to delete the forums you don't want, using UseBB, not pMA as it may break things.

Dietrich wrote

You can reset auto increment on a table using

ALTER TABLE table AUTO_INCREMENT = x

Of course you first need to delete the forums you don't want, using UseBB, not pMA as it may break things.

I get within UseBB:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'table AUTO_INCREMENT = x' at line 1.

I even tried = 1, = 5, = 6

"table" needs to be an existing MySQL table.

Dietrich wrote

"table" needs to be an existing MySQL table.

You lost me.

For example you need

ALTER TABLE usebb_forums AUTO_INCREMENT = x

Dietrich wrote

For example you need

ALTER TABLE usebb_forums AUTO_INCREMENT = x

I knew there was something missing, above worked, thank you.
Did

ALTER TABLE usebb_forums AUTO_INCREMENT = 6

I am learning PHP on my own slowly, haven't touched MySQL yet.

Decided to remove all except 5 forums.