$this->file->write(";\n");
}
} else {
$this->file->write("-- Table contains no data\n");
}
}
public function handleQueryEnded(&$response)
{
}
}
foreach ($ARGS['tables_data'] as $t) {
$file->write("--\n-- Data for table: {$t}\n--\n" . ($ARGS['with_lock'] ? "LOCK TABLES `{$t}` WRITE;\n" : '') . "ALTER TABLE `{$t}` DISABLE KEYS;\n\n");
$w = new QueryResultSQLWriter($LINK, $file, $t, $ARGS['group_inserts']);
$q = new MySQLQuery($LINK, $w);
$q = $q->query("SELECT * FROM `{$db}`.`{$t}`");
if (is_string($q)) {
return $s;
}
$file->write("\nALTER TABLE `{$t}` ENABLE KEYS;\n" . ($ARGS['with_lock'] ? "UNLOCK TABLES;\n" : '') . ($ARGS['with_commit'] ? "COMMIT;" : '') . "\n\n");
}
}
foreach ($ARGS['triggers'] as $t) {
$file->write("--\n-- Structure for trigger: {$t}\n--\n");
if ($ARGS['with_drop_obj']) {
$file->write("DROP TRIGGER IF EXISTS `{$t}`;\n");
}
$q = MySQLQuery::SimpleQuery($LINK, "SHOW CREATE TRIGGER `{$db}`.`{$t}`", TRUE);
$file->write(delimit($q[0][2]));
}
$file->write(getExportFooter($disFKeys));
return array('result' => $file->name);
public function handleResultEnded(&$result)
{
if ($this->group) {
$this->file->write(";\n");
}
$this->file->write("\nALTER TABLE `{$this->target}` ENABLE KEYS;\n");
if ($this->args['with_lock']) {
$this->file->write("UNLOCK TABLES;\n");
}
if ($this->args['with_commit']) {
$this->file->write("COMMIT;\n");
}
$this->file->write(getExportFooter($this->args['no_foreign_keys']));
}
