title: Configure MySQL to Periodically Dump all Data
body: <p>I would like to configure MySQL to periodically dump all data to a <code>.sql</code> file so that if something happens to my server and I need to start over, I can use the file to put all of the data back in place. How can I do this? I can take suggestions either involving use of the MySQL Workbench user interface to configure it or using a query.</p>