[eluser]louis w[/eluser]
But running into problems... Is it escaping the raw sql?
A Database Error Occurred
Error Number: 1064
Code:
$this->load->dbutil();
// Get copy of data in local table
$backup_config = array(
'tables' => array('config')
, 'format' => 'txt'
);
$backup_data =& $this->dbutil->backup($backup_config);
// Connect to remote database
$remote_db = $this->load->database('web_db', TRUE);
$remote_result = $remote_db->query($backup_data);
I could select the data as a result object and iterate through it to run insert query for each row, but I am hoping to streamline it into one query. Maybe not possible.