A simple Expression Engine database backup solution using php in templates and Codeigniter database Utilities.
All you have to do is create a EE template and enable php. Add the following code and modify the "SERVER_PATH" variable and viola, visit the url in your browser and download the full database backup.
<?php $this->EE =& get_instance(); // Load the DB utility class $this->EE->load->dbutil(); // Backup your entire database and assign it to a variable $backup =& $this->EE->dbutil->backup(); // Load the file helper and write the file to your server $this->EE->load->helper('file'); write_file('SERVER_PATH/mybackup.gz', $backup); // Load the download helper and send the file to your desktop $this->EE->load->helper('download'); force_download('mybackup.gz', $backup); ?>
You can customize the filename, tables etc. Follow this guide : http://codeigniter.com/user_guide/database/utilities.html#backup
Do remember to password protect the template to prevent unauthorized access.