Re: Correct way to start new .MYD & .MYI files

2009-09-25 Thread Jim Lyons
Run mysqldump on the table ApplicationLog and save that somewhere where there's space, then truncate the table. If you would really like to keep the tables but only have a disk space issue, then there is one thing you can do if you have disk space on another file system. Move the 3 files for Appl

Re: Correct way to start new .MYD & .MYI files

2009-09-25 Thread Michael Dykman
gt;>> structure. >>> >>> So is there a way to just clear out the ApplicationLog.MYD and >>> ApplicationLog.MYI files? >>> >>> Thx again >>> >>> -Original Message- >>> From: Michael Dykman [mailto:mdyk...@gmail.com]

Re: Correct way to start new .MYD & .MYI files

2009-09-25 Thread Eugene Mah
eptember 25, 2009 3:42 PM To: Jones, Keven Subject: Re: Correct way to start new .MYD& .MYI files If you are prepared to accept that any data associated with those tables is *LOST*, it's pretty simple. First try, the nice way. USE; DROP TABLE ApplicationLog; If this fails, complains

Re: Correct way to start new .MYD & .MYI files

2009-09-25 Thread Michael Dykman
> > Thx again > > -Original Message- > From: Michael Dykman [mailto:mdyk...@gmail.com] > Sent: Friday, September 25, 2009 3:42 PM > To: Jones, Keven > Subject: Re: Correct way to start new .MYD & .MYI files > > If you are prepared to accept that any data ass