PHP database backup script_PHP tutorial

php database backup script

php database backup script

The code is as follows:

// Backup database

　$host = "localhost";

　$user = "root"; //Database account

　$password = ""; //Database password

　$dbname = "mysql"; //Database name

// The account number, password, and name here are all passed from the page

　if (!mysql_connect($host, $user, $password)) // Connect to mysql database

　{

echo 'Database connection failed, please check and try again';

exit;

　}

　if (!mysql_select_db($dbname)) // Whether the database exists

　{

echo 'Database does not exist:' . $dbname . ', please check and try again';

exit;

　}

mysql_query("set names 'utf8'");

　$mysql = "set charset utf8; ";

　$q1 = mysql_query("show tables");

while ($t = mysql_fetch_array($q1))

　{

　$table = $t[0];

　$q2 = mysql_query("show create table `$table`");

　$sql = mysql_fetch_array($q2);

　$mysql .= $sql['Create Table'] . "; ";

　$q3 = mysql_query("select * from `$table`");

while ($data = mysql_fetch_assoc($q3))

　{

　$keys = array_keys($data);

$keys = array_map('addslashes', $keys);

$keys = join('',`', $keys);

　$keys = "`" . $keys . "`";

　$vals = array_values($data);

$vals = array_map('addslashes', $vals);

$vals = join("','", $vals);

　$vals = "'" . $vals . "'";

　$mysql .= "insert into `$table`($keys) values($vals); ";

　}

　}

　$filename = $dbname . date('Ymjgi') . ".sql"; //Storage path, stored in the outermost layer of the project by default

　$fp = fopen($filename, 'w');

fputs($fp, $mysql);

　fclose($fp);

echo "Data backup successful";

　?>