Re: Loosing Autoincrement

On Fri, 7 Sep 2001, scott.alexander wrote: > Hi, > > Why would I loose all of a sudden my autoincrement feature on a table. > > I have not changed the table definition and all of a sudden I get > DUPLICATE ENTRY for KEY 1 errors. > BTW it is of type INT and the last entry w

Loosing Autoincrement

Hi, Why would I loose all of a sudden my autoincrement feature on a table. I have not changed the table definition and all of a sudden I get DUPLICATE ENTRY for KEY 1 errors. thanks Scott - Before posting, please check: h

mysqldump ?

When I am on machine A and my database is on machine B can I force mysqldump to dump the data to files on machine A. When I try from machine A and use mysqldump it dumps to a directory in machine B. thanks Scott - Before post

resetting mysqladmin status

Hi, If I run mysqladmin status it shows uptime, no of questions etc. Can I reset these values to zero without stopping and starting the server. thanks Scott - Before posting, please check: http://www.mysql.com/manual.php