Re: problem restoring backup made from mysqlhotcopy

2004-06-01 Thread venkata ramana
On Tue, 1 Jun 2004 18:33:53 -0700 (PDT), Abuzar Chaudhary <[EMAIL PROTECTED]> wrote: > > Aye, wish the documentation said something to that effect, it only said > to restore it, simply copy the files back, without any examples or > further explanation. > > Okay, so I'm not very good at linux, how

Re: problem restoring backup made from mysqlhotcopy

2004-06-01 Thread Abuzar Chaudhary
Aye, wish the documentation said something to that effect, it only said to restore it, simply copy the files back, without any examples or further explanation. Okay, so I'm not very good at linux, how do I stop and start the server without messing up how it starts or stops when the server is boote

Re: problem restoring backup made from mysqlhotcopy

2004-06-01 Thread gerald_clark
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

problem restoring backup made from mysqlhotcopy

2004-06-01 Thread Abuzar Chaudhary
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: