• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 371
  • Last Modified:

automated db reset question

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.
0
duder78
Asked:
duder78
1 Solution
 
OP_ZaharinCommented:
- you can use mysql events feature to create the sql statement for the resetting task and schedule it to run periodically:

http://dev.mysql.com/doc/refman/5.1/en/events.html
http://dev.mysql.com/tech-resources/articles/mysql-events.html
0
 
duder78Author Commented:
Exactly what I'm looking for, thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now