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 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? login as superuser and try
service mysqld stop servive mysqld start If your system complains that service command not found try /sbin/service mysqld stop /sbin/service mysqld start > > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]