How to empty Table in MySQL database Daily with cronjobs Rumi, September 3, 2013 you can create a php script. truncatetable.php Example: <? $db_host = "localhost"; $db_user = "username"; $db_pass = "password"; $db_name = "databasename"; $connect = @mysql_connect($db_host,$db_user,$db_pass); @mysql_select_db($db_name); // Empty table $query = "TRUNCATE TABLE TableName01"; mysql_query($query); ?> Then setup the cronjob Scripts