• after a certain time period, restore sql db
    2 replies, posted
enough of the shitty questions already. I know and i'm sorry. Over the past years, i've made numerous backend systems for uni. and this is a question which has bugged me for ages. I've seen on a few personal-portfolio websites, of people who have created scripts/applications and give users the chance to see it in it's full glory.. they can add/update and delete data but it doesn't matter because after a certain period of time -automatically- a the database gets restored.. I'm interested in doing this but, google didn't really bring up much.. dunno if that was down to my lousy google-ing. Do any of you have any idea how to do this? I read cron jobs carry out things automatically but I don't think that's what I'm looking for?
cron job that truncates all tables and inserts fresh data
[QUOTE=turb_;24915446]cron job that truncates all tables and inserts fresh data[/QUOTE] cheers, i knew it would be truncate & insert.. didn't put the two together.. [url]http://community.contractwebdevelopment.com/cron-job-mysql[/url]
Sorry, you need to Log In to post a reply to this thread.