Thankyou for your reply Dilipkumar. Much appreciated. Regards
Keith On Tue, 4 Apr 2006, Dilipkumar wrote: > To: [EMAIL PROTECTED] > From: Dilipkumar <[EMAIL PROTECTED]> > Subject: Re: Undelete rows with .MYD-File? > > Hi, > > If it is a busry server you cannot copy MYD & FRM file * MYI files to > another data ditrectory. > Try to take a dump or try using snapshot your datadirectory. > If it is a less MB database you can user as: > In mysql prompt. > flush tables with read locks > dont exit you mysql terminal > Open an another terminal tar -cvzf you mysql old datadirectory and then > after doing so > give in 1st prompt flush tables. > Then Untar your tar files to your new data-direcotry. > > This might help you out. > > [EMAIL PROTECTED] wrote: > > > 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 > > > > > > > > > > > > > > > -- > Thanks & Regards, > Dilipkumar > DBA Support -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]