auto_increment problem

[modcar]

MYSQL v4.1 running on Server 2003 SP2

 

Randomly, on one database (so far noticed) the auto_increment is reset to 0

 

I thought it was the way its being backed up

 

mysqldump -u db_user -pdb_pass --all-databases > d:\backups\mysql\all-db.sql

 

backups are done every day, and issue is not coming up every day

 

The only piece of code that inserts into that table is

 

$sql="INSERT INTO reg_step_1 VALUES ('','title','first','last','phone1','phone2','email','username','password','address1','address2','city','postcode','p_address1','p_address2','p_city','p_postcode','referred','reged_cars','date')";

 

 

[Mchl]

MySQL 4.x is no longer supported. It's high time you upgraded.

 

Please paste here table structure.