protected function dumpDb($filename) { $this->log('Dumping databases'); $user = Config::get($this->local, 'user'); $pass = Config::get($this->local, 'pass'); $dumper = new MySQLDump('localhost', $user, $pass); $dbs = $dumper->listDbs(); // $this->log('Databases: %s', implode(', ', $dbs)); $zip = new ZipArchive(); $zip->open($filename, ZIPARCHIVE::CREATE); foreach ($dbs as $db) { if (empty($db)) { continue; } $this->log('Dump db %s', $db); $dump = $dumper->dumpDatabase($db); $ext = '.sql'; if (function_exists('gzencode')) { $dump = gzencode($dump, 9); $ext .= '.gz'; } $zip->addFromString($db . $ext, $dump); } $this->log('Dump Finished'); $this->log('Zipped Files: %s', $zip->numFiles); $zip->close(); }
function syncMySQLData($link, $mdb_name, $live_db) { $dump = new MySQLDump(); $sql = $dump->dumpDatabase($mdb_name, $link); $sql = explode("\n", $sql); if (is_array($sql)) { foreach ($sql as $sqlstring) { $live_db->query($sqlstring); print "."; ob_flush(); flush(); } } return true; }
$data .= $x < $num_fields - 1 ? ", " : false; } $data .= ");\n"; } $data .= "\n"; $dump .= $structure . $data; $dump .= "-- --------------------------------------------------------\n\n"; } return $dump; } } } $dump = new MySQLDump(); ob_start("ob_gzhandler"); error_reporting(0); $s = $dump->dumpDatabase(MYSQL_DB); print $s; } function objects_list($table, $fields, $where, $order, $action_string) { if ($where) { $where .= " WHERE {$where} "; } if ($order) { $order .= " ORDER BY {$order} "; } $res = db_query("SELECT id, {$fields} FROM {$table} {$where} {$order}"); return htmlquery_code($res, $action_string); } function link_button($link, $cap) {