Best way to purge a table

2009-11-09 Thread Jones, Keven
Hi, I need to get rid of all data in one table of my database. The table just has old Data that I no longer need. What is the best way to accomplish this? If I simply drop the table what can I do prior to dropping the table to ensure I can recreate the table right after I drop it? I still need t

Correct way to start new .MYD & .MYI files

2009-09-25 Thread Jones, Keven
Hello, 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 h