0

Possible Duplicate:
How do I delete cases?

I want to clear all of the cases from my database and reset the autonumber back to 1.

How can I do this easily? Or at least, how can I do this?

I am importing data from our old system, and I want to run some import tests, but preserving my original bug numbers is very important, so subsequent imports have to allow me to use all the bug numbers starting from 1.

flag

closed as exact duplicate by Rich Armstrong♦♦ Jan 13 at 14:31

1 Answer

0

The answer depends on whether you're running on your own servers or FogBugz On Demand, and depends on which database platform.

For On Demand, we can reset your entire database to its initial state if you contact us directly.

link|flag
It is our server, and we are using Linux with MySQL. – Chris M Jan 11 at 18:07
I also only want to clear the bugs, not the other data such as Statuses, Projects, plugins, etc. Just the bug data. – Chris M Jan 11 at 18:08
please see the duplicate question. – Rich Armstrong♦ Jan 13 at 14:31
Resetting the Bug ID should happen with ALTER TABLE Bug AUTO_INCREMENT = 1;... Even better would be to take a backup after you do this and just restore the database after each import attempt. – Rich Armstrong♦ Jan 13 at 14:39

Not the answer you're looking for? Browse other questions tagged or ask your own question.