$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'])); }