List:General Discussion« Previous MessageNext Message »
From:Karen Abgarian Date:January 27 2012 11:31am
Subject:Re: Script for cleaning data on a regular basis
View as plain text  
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.
 


On Jan 27, 2012, at 3:08 AM, Johan De Meersman wrote:

> ----- Original Message -----
>> From: "Halász Sándor" <hsv@stripped>
>> 
>> Therefore, it well may be easier to do it all in PHP, since therewith
> 
> I agree with the assessment, but I take issue with this whole "do it in
> PHP/Python/language-of-the-month".
> 
> 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.
> 
> 
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
> 

Thread
Script for cleaning data on a regular basisa bv26 Jan
  • Re: Script for cleaning data on a regular basishsv26 Jan
    • Re: Script for cleaning data on a regular basisJohan De Meersman27 Jan
      • Re: Script for cleaning data on a regular basisKaren Abgarian27 Jan
    • Re: Script for cleaning data on a regular basiswalter harms27 Jan