Don't EVER copy to database files while the server is running. This is a guaranteed way to crash your database files.
Shutdown the server. Copy the files. Start the server.
Abuzar Chaudhary wrote:
Hi,
Using a sample database, I have tablea and tableb. I populate tablea with some records and I can see the tablea.MYD file size increase on the drive, while tableb.MYD remains at zero bytes.
Then I make a backup: mysqlhotcopy -u username -p password sample ./backup
Next I modify the database: I delete the records from tablea and insert records in tableb and observe tableb file size increase on the drive, then I remove the sample directory inside /var/lib/mysql which contains the sample database
Now I restore it like this: mv backup/sample .
and I see the tableb.MYD file get adjusted back to zero, as it was before the modification, yet when I look at the database through mysql and through mysqlcc, it still shows the modified database!
Anyone know why it isn't restoring to the original backup ?!?
Thanx,
Abuzar ([EMAIL PROTECTED])
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
