Right you are. I don't know why I thought he had corrupted tables to
start with but that was the assumption I was under. A simple TRUNCATE
is the easiest way to deal with this..
On Fri, Sep 25, 2009 at 4:16 PM, Eugene Mah <eugenem@stripped> wrote:
> Eugene Mah, M.Sc., DABR
> Medical Physicist/Misplaced Canuck maheug@stripped
> Department of Radiology
> Medical University of South Carolina "For I am a Bear of Very Little
> Charleston, South Carolina Brain, and long
> words Bother
> http://www.netcom.com/~eugenem/ me." Winnie the
> PGP KeyID = 0x1F9779FD, 0x319393F4
> PGP keys available on request ICQ 3113529
> On 09/25/2009 04:04 PM, Michael Dykman wrote:
>> 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<Keven.Jones@stripped>
>>> 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
>>> So is there a way to just clear out the ApplicationLog.MYD and
>>> ApplicationLog.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.
>>> DROP TABLE ApplicationLog;
>>> If this fails, complains about curruption, whatever, go to the next step
>>> 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
>>> those tables... now that they are gone, that application might begin
>>> fail. Be prepared to create a new empty table with that name
>>> having the same structure,... if you really don't want the data but
>>> are only doing it to make your app happy, consider the black-hole
>>> database engine.
>>> - michael dykman
>>> On Fri, Sep 25, 2009 at 3:33 PM, Jones, Keven<Keven.Jones@stripped>
>>>> I am new to MySQL.I have a disk space issue and I have found that 3
>>>> files 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
>>>> files 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=1
- michael dykman
Don’t worry about people stealing your ideas. If they’re any good,
you’ll have to ram them down their throats!