From: Michael Dykman Date: September 25 2009 8:04pm Subject: Re: Correct way to start new .MYD & .MYI files List-Archive: http://lists.mysql.com/mysql/218828 Message-Id: <814b9a820909251304h3af6024dje79c5cce8891bd92@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Alas, none that I am aware of, but if you can successfully run 'SHOW CREATE TABLE `ApplicationLog`' before you drop the table, it will give you the DDL you need to recreate that table *exactly*. - michael On Fri, Sep 25, 2009 at 3:47 PM, Jones, Keven wrote: > I don't want to lose the table structure just wish to get rid of the old = data in the .MYD and .MYI files. > > If I drop the table I will need to recreate the table with the existing s= tructure. > > So is there a way to just clear out the ApplicationLog.MYD and Applicatio= nLog.MYI files? > > Thx again > > -----Original Message----- > From: Michael Dykman [mailto:mdykman@stripped] > 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 associated with those tables = is *LOST*, it's pretty simple. > > First try, the nice way. > > USE ; > DROP TABLE ApplicationLog; > > If this fails, complains about curruption, whatever, go to the next step = safely: > > shutdown mysql (os-specific), then go ahead and delete those files. > Startup will happen normally and those tables will be gone. > > Caution: you *might* be running an application that is expecting to use t= hose tables... =A0now that they are gone, that application might begin to f= ail. =A0Be prepared to create a new empty table with that name > having the same structure,... =A0 if you really don't want the data but > are only doing it to make your app happy, consider the black-hole databas= e engine. > > =A0- michael dykman > > > > On Fri, Sep 25, 2009 at 3:33 PM, Jones, Keven wrote= : >> Hello, >> >> I am new to MySQL.I have a disk space issue and I have found that 3 file= s are the cause. >> >> The files are ApplicationLog.MYD and ApplicationLog.MYI >> >> >> I would like to purge these files and basically get rid of the data >> that is in them. What is the proper Way to accomplish this? Does >> anyone have a procedure to follow that will allow me to archive these fi= les and Then start new ones so I can get my disk space back? >> >> Thanks in advance. >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql To unsubscribe: >> http://lists.mysql.com/mysql?unsub=3Dmdykman@stripped >> >> > > > > -- > =A0- michael dykman > =A0- mdykman@stripped > > Don't worry about people stealing your ideas. If they're any good, you'll= have to ram them down their throats! > > =A0 Howard Aiken > --=20 - michael dykman - mdykman@stripped Don=92t worry about people stealing your ideas. If they=92re any good, you=92ll have to ram them down their throats! Howard Aiken