On Linux, use a CRON job.
On Windows, use the Task Scheduler.
MySQL comes with a command line tool called "mysqldump". To learn how to use it, bring up a command line interface and type in "mysqldump --help". Or read the documentation on the MySQL web site.
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.