Originally Posted by sunfighter
It's known as a backup and a restore. You can use phpMyAdmin and the tabs on the top of the page. Backup the DB when it is new. Save the generated php for the restore and you should be good to go.
Sorry if I didn't make it clear, but I want to restore the database automatically at a certain time of day
, without any user interaction.