<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:12pt"><div><span>I might write a simple php program to do it!!!</span></div><div> </div><div>There is still a bug in the program must use RAID!<br></div><div style="font-family: arial,helvetica,sans-serif; font-size: 12pt;"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><font face="Arial" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> L. V. Lammert <lvl@omnitec.net><br><b><span style="font-weight: bold;">To:</span></b> Grand Rapids LUG <grlug@grlug.org><br><b><span style="font-weight: bold;">Sent:</span></b> Tuesday, August 16, 2011 3:10 PM<br><b><span style="font-weight: bold;">Subject:</span></b> [GRLUG] mysql 'purge'<br></font><br>Question - is anyone aware of a simple way to purge records from a mysql<br>[by aging a timestamp] in a cron job? Writing a program is
too<br>complicated, ..<br><br>> I could write SQL code to delete records over, say, seven days, .. BUT<br><br>> The more complicated part is that each of those records includes a<br>filename that also must be deleted. My first thought would be to do a<br>select and dump to a temporary file, then run xargs [?] on that file to<br>delete the system files, but wanted to check if I missed something.<br><br> Lee<br><br>-- <br>This message has been scanned for viruses and<br>dangerous content by MailScanner, and is<br>believed to be clean.<br><br>_______________________________________________<br>grlug mailing list<br><a ymailto="mailto:grlug@grlug.org" href="mailto:grlug@grlug.org">grlug@grlug.org</a><br><a href="http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug" target="_blank">http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug</a><br><br><br></div></div></div><br />--
<br />This message has been scanned for viruses and
<br />dangerous content by
<a href="http://www.mailscanner.info/"><b>MailScanner</b></a>, and is
<br />believed to be clean.
</body></html>