codeigniter 備份目前網站資料庫

因為一些因素必須要撰寫公司網站資料庫備份的排程
所以筆記一下以做為以後方便查找:

在controller:

<?php
class Mybackup extends MY_Controller {

 public function index(){
  $this->load->dbutil();
  // Backup your entire database and assign it to a variable
  $backup =& $this->dbutil->backup(); 
  // Load the file helper and write the file to your server
  $this->load->helper('file');

  if (!write_file('./mybackup.zip', $backup)){
     echo 'Unable to write the file';
  } else{
   echo 'File written!';
  }
   
 }


} 
 

網站目錄(預設根目錄)可取得..mybackup.zip這個檔案囉