';
echo '===================================================
';
$time = explode(' ', microtime());
$start_time = $time[1] + $time[0];
//
$fo = @fopen($save_path.$database_name.'.sql', 'a');
if($fo === false){ echo ' , !'; }
//
$link = @mysql_connect('localhost', 'root', 'root') or die(' ,error:'.mysql_error());
//
$ret = mysql_list_tables($database_name); $table_list = array();
while($table = mysql_fetch_assoc($ret)){
$table_list[] = $table['Tables_in_'.$database_name];
echo ''.$table['Tables_in_'.$database_name].'
';
}
foreach($table_list as $table){
// sql
$sql = 'show create table '.$table;
$create_table_ret = mysql_fetch_assoc(mysql_query($sql));
$create_table_sql = 'drop table if exists '.$table.";
";
$create_table_sql .= $create_table_ret['Create Table'].";
";
// sql
$sql = 'select * from '.$table;
$insert_data_ret = mysql_query($sql);
$insert_data_sql = 'insert into '.$table.' values';
while($row = mysql_fetch_assoc($insert_data_ret)){
$insert_data_sql .= '('; foreach($row as $key => $val){
$insert_data_sql .= '"'.mysql_real_escape_string($val, $link).'",';
}
$insert_data_sql = rtrim($insert_data_sql, ',').'),';
}
$insert_data_sql = rtrim($insert_data_sql, ',').";
";
if(!mysql_num_rows($insert_data_ret)){
$create_table_sql .= "
";
}
fwrite($fo, $create_table_sql);
if(mysql_num_rows($insert_data_ret)){
fwrite($fo, $insert_data_sql);
}
$innerHTML = $table."[ !]";
$script = '';
$script .= 'document.getElementById("'.$table.'").innerHTML = "'.$innerHTML.'";'; $script .= '';
echo $script; } fclose($fo);
$time = explode(' ', microtime());
$end_time = $time[1] + $time[0];
echo ' ( '.count($table_list).' ), :', $end_time - $start_time, ' !';
}
dump_database('mysql', './');