| Author |
Post |
|
|
#1 Thu Jan 26, 2006 5:22 am
|
|
Member
Registered: May 2005
Posts: 294
Location: 98671
|
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.
|
|
|
#2 Thu Jan 26, 2006 12:27 pm
|
|
Developer
Registered: Apr 2004
Posts: 2202
Location: Belgium
|
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.
|
|
|
#3 Thu Jan 26, 2006 12:42 pm
|
|
Member
Registered: May 2005
Posts: 294
Location: 98671
|
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
|
|
|
#4 Thu Jan 26, 2006 12:44 pm
|
|
Developer
Registered: Apr 2004
Posts: 2202
Location: Belgium
|
"table" needs to be an existing MySQL table.
|
|
|
#5 Thu Jan 26, 2006 12:46 pm
|
|
Member
Registered: May 2005
Posts: 294
Location: 98671
|
Dietrich wrote "table" needs to be an existing MySQL table.
You lost me.
|
|
|
#6 Thu Jan 26, 2006 12:48 pm
|
|
Developer
Registered: Apr 2004
Posts: 2202
Location: Belgium
|
For example you need ALTER TABLE usebb_forums AUTO_INCREMENT = x
|
|
|
#7 Thu Jan 26, 2006 12:54 pm
|
|
Member
Registered: May 2005
Posts: 294
Location: 98671
|
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. « Last edit by William on Thu Jan 26, 2006 12:56 pm. »
|