Database backup and restoration in MYSQL

Question

I would like to listen your opinion about a situation. There is a function that is able to REMOVE all data from an specific date ?

I mean ... We are developing a demo script website, where users can join and test our system.

We need a database reset every 3 hours ... Delete all new data and back all changes to a default point. Better do that with php or mysql has an internal function that handle this.

Answer 1

You can do it in MySQL, using Event Scheduler. Event Scheduler is similar to the idea of the Unix CronTab

More details on MySQL Site - http://dev.mysql.com/doc/refman/5.6/en/events-overview.html

Answer 2

mysqldump -u username -ppassword database > dump.sql
mysql -u username -ppassword database < dump.sql

Answer 3

are you talking about removing whole data from the tables or just specific data inserted at some time? you can do this different ways..

First way:
1) add a field indicating current time of insertion (for example: insert_date)
2) DELETE FROM table WHERE insert_date I mean ... We are developing a demo script website, where users can join