CodeIgniter Framework - สำรองฐานข้อมูล

สามารถเขียนใน Controller ได้ดังนี้

class Backup extends CI_Controller {

  public function __construct() {
    parent::__construct();
    $this->load->helper('url');
    $this->load->helper('file');
    $this->load->helper('download');
    $this->load->library('zip');
  }

  public function index(){
    $this->load->view('welcome');
  }

  public function database_backup(){
    $this->load->dbutil();
    $db_format=array('format'=>'zip','filename'=>'my_db_backup.sql');
    $backup=& $this->dbutil->backup($db_format);
    $dbname='backup-on-'.date('Y-m-d').'.zip';
    $save='assets/db_backup/'.$dbname;
    write_file($save,$backup);
    force_download($dbname,$backup);
  }
}