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 ApplicationLog and create sym links for them. In Unix/Linux, you would use the ln command. I believe Windows has a way of creating symlinks with .sym files, but I'm not 100% sure. On Fri, Sep 25, 2009 at 2:33 PM, Jones, Keven <keven.jo...@ncr.com> wrote: > 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 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=jlyons4...@gmail.com > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
