Trying to use a php file to truncate a table in mySQL database every minute but I cant figure it out.

Anyone have experience with dreamhost

This post was edited by TrialErorr on Mar 31 2016 05:40pm

why not just do it in mysql?

trust me i tried this
it gives me a error saying i need SUPER access

the only way i think it works with my hosting is Cron JOBS
iv literally spent hours trying to figure this out


this isnt hw btw, this is just something im doing on my own

This post was edited by TrialErorr on Mar 31 2016 06:42pm

what have you already tried?

http://stackoverflow.com/questions/4901335/cronjob-every-minute

You have access to cron tab but you can not set user with enough privileges in mysql?

Crontab script also require user with proper privileges in mysql.
System root != mysql root

its all good i got it to work
but now i have a different problem that im trying to figure out