[GRLUG] mysql 'purge'

[Joseph McLaughlin]

I might write a simple php program to do it!!!

 
There is still a bug in the program must use RAID!


________________________________
From: L. V. Lammert <lvl at omnitec.net>
To: Grand Rapids LUG <grlug at grlug.org>
Sent: Tuesday, August 16, 2011 3:10 PM
Subject: [GRLUG] mysql 'purge'

Question - is anyone aware of a simple way to purge records from a mysql
[by aging a timestamp] in a cron job? Writing a program is too
complicated, ..

> I could write SQL code to delete records over, say, seven days, .. BUT

> The more complicated part is that each of those records includes a
filename that also must be deleted. My first thought would be to do a
select and dump to a temporary file, then run xargs [?] on that file to
delete the system files, but wanted to check if I missed something.

    Lee

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

_______________________________________________
grlug mailing list
grlug at grlug.org
http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug
-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shinobu.grlug.org/pipermail/grlug/attachments/20110816/fa3d2726/attachment.html>