Hello,
MySQL version: 3.23.58
Each week I make a hotcopy of numerous database files. I tar them and gzip them, and move them to an archive machine.
I then use a second machine to read from the archive, untar and ungzip the files, and presto! I have exact copies of my databases running on a backup server.
I even prove that the MyISAM files are the same using MD5 checksums.
Then why do I get different results from the queries?
The copied tables are sometimes missing weeks worth of data, even though the MyISAM files appear to be identical. Strange, eh!?
Andy:
This is a very strange problem. I've had a few of those when something seemingly impossible appeared to be happening, and I was on the verge of believing that a magic fairy was causing it. What helped was an attempt to thoroughly document the bug with the idea that you will be presenting it to someone who is both knowledgeable and skeptical. It helped me find something I was doing wrong.
So I suggest you start with that. If you have a colleage at work who could listen to you and question/confirm your logic that would help. If indeed you discover that you have copied every file the same, and it works different on different machines, I would start checking the RAM it make sure it is not going bad.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
