Zeroing a MySQL database

[RFH Reseller: UKFlyer]

I have imported the database structure of a MySQL database onto RFH. I deleted all the users listed before the export, however adding a new user after the import the entry was sequential from the last one deleted on the previous host. I'd like it to start again from 1, is there an easy way this can be done?

[RFH Reseller: MooMF]

A Truncate Table usually resets identity columns - not sure if that's the case with MySql, (I'm a MS Sql Server bod), but might be worth a shot.

Regards,
Jim.

[RFH Reseller: askjim]

in sql server you can set the starting position for an identity column would need to look for similiar in mysql

[RFH Customer: Steve]

There are a few suggestions on this page,
http://dev.mysql.com/doc/refman/5.0/...increment.html

I've not tried any of them, so I can't say if they work or not.

[RFH Reseller: UKFlyer]

Within phpMyAdmin for each table there is an empty function - which appears not to work if you have already manually deleted the data; this however I presume would clear the entries of that table.

You've also an 'operations' tab. Within that you have table options. My users table still had me and one other as an admin. I set 'auto_increment to 3 added another user and it worked. User number 3!

Some of the other tables have no data, so I'm presuming 1 is to be used for auto_increment, where there is data, I've set the auto_increment to the next consecutive number.

Thanks to everyone offering advice....