What's the best way to reset an installation?

rbl · February 21st, 2005, 08:22 AM

Hi!
Is there any way to delete all images on Gallery so that the IDs start again at #1 and not mess totally the installation?

On my dev gallery installation I've made quite a few changes I want to keep but I have a gazzilion test posts I want to delete.
Since dealing with smaller post ids is better when you want to go to a particular page, I would like to "reset" and not mass delete.

What tables should I empty beside the images table?

Thanks!
Ricardo

February 21st, 2005, 10:17 AM

Use phpMyAdmin to empty the tables. Then go to the table you're trying to reset, click on the 'Operations' link at the top, then at the bottom of that page you will see the auto_increment field.

rbl · February 21st, 2005, 10:26 AM

It should be set to zero?

February 21st, 2005, 10:47 AM

Just leave it blank and that should do the trick.

rbl · February 21st, 2005, 06:57 PM

Thanks Brian! Everything went ok!