host ,$jconfig->user, $jconfig->password);$result = mysql_list_tables($jconfig->db); $tables = array();while ($row = mysql_fetch_row($result)) { $tables[] = $row[0];}mysql_select_db($jconfig->db);$sql = '';foreach($tables as $table){ $sql .= backupTable($table);}$r = file_put_contents('tmp/backup_'.date('Y-m-d-H-i-s').'.sql', $sql);if($r){ die('success');}else{ die('lalala');}mysql_close($connect);function backupTable($table){ $sqltxt = "DROP TABLE IF EXISTS $table;\n"; $result = mysql_query("SHOW CREATE TABLE $table"); $row = mysql_fetch_assoc($result); $createsql = $row['Create Table']; $sqltxt .= $createsql.";\n\n"; $result = mysql_query("SELECT * FROM $table"); $rows = array(); while($row = mysql_fetch_assoc($result)){ $fields = array(); foreach($row as $field){ $fields[] = '\''.mysql_escape_string($field).'\''; } $rows[] = '('.implode(',', $fields).')'; } if(!empty($rows)){ $sqltxt .= "INSERT INTO `$table` VALUES".implode(",\n", $rows).";\n"; } $sqltxt .= "\n"; return $sqltxt;}