I m having a php mysql database based demo site.
I have the backup sql file in database_file.sql.gz format.
All i want is to run a cron job so that all data from all tables in abc database get reset to original one.
Or drop all tables from database and after that re insert all tables and data from above backup file.
Any simple php code i can use.. please guide