automated db reset question

Posted on 2011-05-08
Last Modified: 2012-06-21
Hi there,

I recently completed my first web application using PHP and MySQL.  It basically allows users to update scores and other information using a database.  I'd like to add it to my porfolio but seeing as anyone would be able to change values in that case, i'd like the database values to be reset periodically.  I'd say, every 20 minutes to an hour or so.  What's the best way to accomplish this task?

Ideally, I would only want it reset if values had changed but if that's too complicated, a clean wipe every so often would suffice.

I'm running Linux shared hosting with GoDaddy as far as server specs.

Any advice would be much appreciated.
Question by:duder78
    LVL 23

    Accepted Solution

    - you can use mysql events feature to create the sql statement for the resetting task and schedule it to run periodically:

    Author Closing Comment

    Exactly what I'm looking for, thanks!

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Read about achieving the basic levels of HRIS security in the workplace.
    Join Greg Farro and Ethan Banks from Packet Pushers ( and Greg Ross from Paessler ( for a discussion about smart network …
    Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now