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]
