I have only seen this when some thing was looking are the db files
independed of mysqld.
This was when I used isamchk to resort and fix a table but did not flush
tables after.
Hope this helps
Simon
-----Original Message-----
From: Richard McKenney [mailto:[EMAIL PROTECTED]]
Sent: 05 June 2001 13:09
To: [EMAIL PROTECTED]
Subject: URGENT Disappear - Reappear Problem
We have a table whose entries seem to be disappearing at random. We are
accessing our MySQL 3.22.32 database with PHP4 on a Linux 6.0 586 machine.
Up until yesterday, we would lose about one entry per week in a single
table. The rest of the tables seem fine. However, yesterday one of our
entries reappeared. Our affected table has 39 fields with one
auto-increment primary key zerofill field. isamchk returned that everything
was fine. Has anyone seen this happen before? Thanks in advance.
Shawn McKenney
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php