+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: $this->load->dbutil() problem (/showthread.php?tid=52748)
$this->load->dbutil() problem - El Forum - 06-25-2012
[eluser]Zeff[/eluser]
Hi guys,
I want to make a backup from 4 mysql tables of a database, but - while expecting 4 tables - I only get two of them...
The code I use for this is:
Code:
// Load the DB utility class
$this->load->dbutil();
$prefs = array(
'tables' => array('abstracts', 'users', 'payments', 'registrations'), // Array of tables to backup.
'ignore' => array(), // List of tables to omit from the backup
'format' => 'txt',
'add_drop' => TRUE,
'add_insert' => TRUE,
'newline' => "\n"
);
// Backup your entire database and echo
echo $this->dbutil->backup($prefs);As a result, I only get two tables. When I manipulate the array and remove the other three, so only one element is left, the sql string is displayed fine. So ther is nothing wrong with the tables.
I get approximately 5560 chars, no more (a size restriction can't be the reason I hope).
Many thanks for your help!
Zeff
$this->load->dbutil() problem - El Forum - 06-28-2012
[eluser]Jason Hamilton-Mascioli[/eluser]
Are you able to replicate the database on another server (localhost) and check if the same issue occurs?