How to set back id numbers? [Archive] - Canon Digital Photography Forums

Cyclist

29th of July 2004 (Thu), 12:47

I had to delete all photos and now before uploading new ones I would like to set back id numbers so it would start with id=1 instead of 1345 when starting again. How is this possible?

wkitty42

31st of July 2004 (Sat), 19:56

I had to delete all photos and now before uploading new ones I would like to set back id numbers so it would start with id=1 instead of 1345 when starting again. How is this possible?

there are two ways to do this... the first is a manual edit that may cause pekka to not support you... i've done it in other databases when a similar situation came up... i used phpMyAdmin and had to go into the database, itself, and modify the "index" counter... sorry, i don't remember exactly what it is called but the link is down the page and is an icon, IIRC...

the best way would be to simlay drop all the tables in the bit bucket and start over... essentially a complete reinstall but only as far as getting the database tables going...

HTH