} /* add mysql export */ $structExport = ''; @mkdir('/tmp/'); @mkdir('/tmp/qgdbexport1/'); chmod('/tmp/qgdbexport1/', 0777); foreach (D()->Tables() as $T) { $file = realpath('/tmp/qgdbexport1/') . '/' . $T . '.csv'; @unlink($file); D()->query("SELECT * INTO OUTFILE " . D()->quote($file) . " FROM " . $T); $zip->addFile($file, 'mysql/' . $T); $tmp = D()->row("SHOW CREATE TABLE " . $T); $structExport .= $tmp['Create Table'] . ";\n\n"; } $zip->addFromString('mysql.struct.sql', $structExport); $zip->close(); /* send */ header("Pragma: public"); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Cache-Control: private", false); header("Content-Type: application/force-download"); header("Content-Disposition: attachment; filename=\"export.zip\";"); header("Content-Transfer-Encoding: binary"); while (ob_get_level()) { ob_end_clean(); } readfile($tmpFile); exit; /**/