MySQL database backup in PHP

<?php//Backup Database $host = "localhost"; $user = "root"; Database account $password = ""; Database Password $dbname = "Test"; Database name//The account number, password, and name are all sent from the page if (!mysql_connect ($host, $user, $password))//connection to MySQL database {echo ' database connection failed, please check and try again '    ; Exit;} if (!mysql_select_db ($dbname))//whether the database exists {echo ' does not exist database: '. $dbname.    ', please check and try again '; Exit;} mysql_query ("Set names ' UTF8 '"); $mysql = "Set CharSet utf8;\r\n"; $q 1 = mysql_query ("Show Tables"); while ($t = Mysql_fetch_    Array ($q 1)) {$table = $t [0];    $q 2 = mysql_query ("Show create Table ' $table '");    $sql = Mysql_fetch_array ($q 2); $mysql. = $sql [' Create Table '].    "; \ r \ n";    $q 3 = mysql_query ("select * from ' $table '");        while ($data = Mysql_fetch_assoc ($q 3)) {$keys = Array_keys ($data);        $keys = Array_map (' addslashes ', $keys);        $keys = Implode (', ', ', $keys); $keys = "'". $keys.        "`";        $vals = Array_values ($data);        $vals = Array_map (' addslashes ', $vals);        $vals = Join ("', '", $vals); $vals = "‘" . $vals.        "‘";    $mysql. = "INSERT INTO ' $table ' ($keys) values ($vals); \ r \ n"; }} $filename = $dbname. Date (' Ymjgi '). ". SQL"; Storage path, default to the project outermost $fp = fopen ($filename, ' W '); fwrite ($fp, $mysql); fclose ($FP); echo "Data backup succeeded";?>

　　

MySQL database backup in PHP