Thought I saw this but can't find

[Kevman]

I thought I saw a thread that talked about reseting the auto increment value in mysql but can not find it again.

I have a table that I have been doing some testing with. I have now taken out all the test data. I want to reset the auto increment value for the prime key to use 1 again and start over. Can somebody tell me how to do this?

Thank you

[lwyau]

One way to do this is to drop then recreate the table.

Download sohoadmin/program/webmaster/backups/9999999999/data_tables.sql

where 999999999 is a 10 digit folder name for your lastest soho backup.

This file contains sql statements meant for restoring ALL soho data tables. You ought to be able to isolate the drop and create sql statements for the table you want. You can then copy and paste it into cpanel > mysql database > phpmyadmin sql execution.