From: Karen Abgarian Date: January 27 2012 11:31am Subject: Re: Script for cleaning data on a regular basis List-Archive: http://lists.mysql.com/mysql/226684 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable The original problem is traditionally resolved by partitioning the = tables by historical range and creating a database job/event to drop = older partitions and add the new ones. Depending on the environment, = some might prefer shell scripts to do essentially the same. =20 On Jan 27, 2012, at 3:08 AM, Johan De Meersman wrote: > ----- Original Message ----- >> From: "Hal=E1sz S=E1ndor" >>=20 >> Therefore, it well may be easier to do it all in PHP, since therewith >=20 > I agree with the assessment, but I take issue with this whole "do it = in PHP/Python/language-of-the-month". >=20 > Why would I want to install PHP, Python or whatever on a database = server? The art of Bash programming is far from dead, and it behooves = any decent administrator to have at least some basic knowledge. Bash is = literally on almost every system you're likely to run MySQL on, and it's = capabilities probably far exceed what you think it can do. >=20 >=20 > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel >=20 > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql >=20