As my server does not get alot of traffic I tend to shutdown mysql, and do an OS copy of the complete /var/lib/mysql directory to another partition on another drive. Then restart mysql again.
This may not be a feasable option on a busy server. Obviously each person has their way of doing backups. I do need to study the manual myself on all available backup options. Regards Keith On Mon, 3 Apr 2006, Nico Schefer wrote: > To: [EMAIL PROTECTED] > From: Nico Schefer <[EMAIL PROTECTED]> > Subject: Re: Undelete rows with .MYD-File? > > Hi Keith > > > It looks like someone has packed this table with myisampack, > > which means it's read only. Did you use myisampack on the > > table before it got dropped Nico? > > Thanks a lot for looking at the problem. As far as i know the table has > not been compressed, and i've not used myisampack. I'v tried to run > myisamchk -e -r as well, but is has trunctated my MYD-File as well. > I think i have to live with it, i begun to recunstruct the data by hand > wich took me the whole day now and i'm not finished by far.. but well, > i'll certainly do some backups now ;-) > > Thanks and greetings, Nico -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]