Creating database backup is very easy but I need to create db backup with bulk insert sql query. It reduces created backup file. Anyone knows about solution?
I have used following code and creates db backup successfully but I need to have SQL file with bulk insert sql query.
$this->load->dbutil();
$prefs = array(
'format' => 'zip',
'filename' => 'my_db_backup.sql'
);
$backup =& $this->dbutil->backup($prefs);
$db_name = 'backup-on-'.date('Y-m-d').'.zip';
$save = 'assets/db_backup/'.$db_name;
write_file($save, $backup);
force_download($db_name, $backup);
Thanks in advance.