Database Utility - Backups Not Working with MySQLi

[eluser]Unknown[/eluser]
Probably you would face the same problem than me if you are trying to export BIG tables. Here you are a quick workaround.

Replace this...

Code:

// Grab all the data from the current table
$query = $this->db->query("SELECT * FROM $table");

if ($query->num_rows() == 0)
{
continue;
}

with this...

Code:

// Grab all the data from the current table - in slices of 1000 records
// Workaround for BIG tables
$slice = 0;
$query = $this->db->query("SELECT * FROM $table LIMIT $slice, 1000;");

while ($query->num_rows() !== 0)
{

... and then, replace this...

Code:

$output .= $newline.$newline;
}

with this...

Code:

$output .= $newline.$newline;

$slice = $slice + 1000;
$query = $this->db->query("SELECT * FROM $table LIMIT $slice, 1000;");
}