John Davidson

Message:

Unable to get the data base 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);

I have tried the above mentioned code. It shows the below mentioned error.

Database error occured. Please contact administrator

Unsupported feature of the database platform you are using.



Filename: C:\xampp\htdocs\innowork-v4\api\system\database\drivers\mysqli\mysqli_utility.php



Line Number: 83

Kindly assist me how to fix it

---

My Answer:
load->dbutil();
$this->load->helper('file');

$backup =& $this->dbutil->backup();

$file_name = 'backup-' . date('Y-m-d-H-i-s') . '.gz';
$file_path = '/path/to/backup/' . $file_name;

write_file($file_path, $backup);

echo 'Database backup created successfully at ' . $file_path;