From: Johan De Meersman Date: October 28 2011 7:08am Subject: Re: Disk space ending with multiple tables List-Archive: http://lists.mysql.com/mysql/226191 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message ----- > From: "a bv" > > I have a phpsyslog-ng box with different tables and disk usage is I assume that means you have a syslog service that logs to a MySQL database? > growing so fast nearly no space left. How must i move the old > files? Is it ok to move just like an ordinary file or do something on > mysql? Heh, no, that's not a good idea :-) Does the syslog software not clean up it's tables? If it doesn't, you'll have to set up a job that performs delete statements on the appropriate tables; but I really urge you to check the phpsyslog-ng documentation first. Any software that writes to a database should really have a mechanism for cleaning up after itself, too. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel