CodeIgniter Forums
$this->load->dbutil() problem - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forum-23.html)
+--- Thread: $this->load->dbutil() problem (/thread-52748.html)



$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?