Welcome Guest, Not a member yet? Register   Sign In
Database Backup With Bulk Insert Query
#1

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.
Reply




Theme © iAndrew 2016 - Forum software by © MyBB