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;
}
Beispiel #3
0
                            $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)
{