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(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';