YovoAds

    CREATE TABLE IF NOT EXISTS shows_new LIKE shows;
    SELECT * FROM shows WHERE EventTimeStamp >= unix_timestamp(AddDate(Now(),interval -14 day)) and EventTimeStamp<unix_timestamp(Now()) INTO OUTFILE '/var/lib/mysql-files/shows.txt';
    LOAD DATA INFILE '/var/lib/mysql-files/shows.txt' INTO TABLE shows_new;
    ALTER TABLE shows RENAME TO shows_old;
    ALTER TABLE shows_new RENAME TO shows;
    DROP TABLE shows_old;
    
    TRUNCATE TABLE failed;
    
    CREATE TABLE IF NOT EXISTS clicks_new LIKE clicks;
    INSERT INTO clicks_new SELECT * FROM clicks WHERE EventTimeStamp >= unix_timestamp(AddDate(Now(),interval -60 day));
    ALTER TABLE clicks RENAME TO clicks_old;
    ALTER TABLE clicks_new RENAME TO clicks;
    DROP TABLE clicks_old;
    
    CREATE TABLE IF NOT EXISTS redirects_new LIKE redirects;
    INSERT INTO redirects_new SELECT * FROM redirects WHERE EventTimeStamp >= unix_timestamp(AddDate(Now(),interval -30 day));
    ALTER TABLE redirects RENAME TO redirects_old;
    ALTER TABLE redirects_new RENAME TO redirects;
    DROP TABLE redirects_old;

PURGE BINARY LOGS BEFORE '2018-12-01 00:00:00';