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 booted or shutdown? i.e. is it like Apache where "apache stop", and "apache start" kind of commands will do the job? Thanx :) Abuzar --- gerald_clark <[EMAIL PROTECTED]> wrote: > 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] > __________________________________ 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]
