Loosing Autoincrement

2001-09-06 Thread scott.alexander
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:

resetting mysqladmin status

2001-08-22 Thread scott.alexander
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

mysqldump ?

2001-08-22 Thread scott.alexander
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