How do you make a mysql database automaticly clear on a specific time at a spacific day?
Such as Monday at 00:00.
Thanks.
Printable View
How do you make a mysql database automaticly clear on a specific time at a spacific day?
Such as Monday at 00:00.
Thanks.
Cron Jobs.
Humm, i must of typed that in a dif window.Quote:
Originally Posted by Invent
I know its done by cron jobs, but how do you do that =]
http://www.aota.net/Script_Installat.../cronhelp.php3 :| as posted a min ago..
I was replying before you posted.Quote:
Originally Posted by Jamie.
Humm, Iv never got cron jobs. I gave in on them when they didnt work.
What type of commands would clear a table in a database :s
MySQL:
TRUNCATE TABLE `table_name` ;
What do I do with that exactly?Quote:
Originally Posted by H!
'Cus that'll run automaticaly at 00:00 :rolleyes:Quote:
MySQL:
TRUNCATE TABLE `table_name` ;
Simon, you seam to be good with all this. Can you help me pls...Quote:
Originally Posted by Invent
Ill bribe you with money if you wish?
No, Simon just e-bullies me. :'(
May've got that wrong.PHP Code:$time = date("H:i");
if($time == "00:00"){
$query = mysql_query("TRUNCATE TABLE `table_name` ;");
}
<?php
include "config.php"; // config file
$query = mysql_query("TRUNCATE TABLE `table_name` ;");
?>
go into cPanel.
Go to cron jobs, put the command as:
wget http://www.site.com/myfile.php
Then set the time to everyday at 00:00 of every week of every month of every year.
Humm, how do you do it so it deletes say:Quote:
Originally Posted by Dentafrice,
the data in 00:00 etc..?
you set the cron to run the file at the time you want it delete and also
Simon why are u so up your self?
Just because someone else helped more then you.
:| there is no need to be so rude.Quote:
Originally Posted by Mattx.org
Yeah, just ignore me. ('ere.)
I made it so that it deletes them, but also re adds them at the same time :)
Re-adds the table structure? That's exactly what TRUNCATE does, anyway :P