MySQL backup function and recovery function ideas

Backup

<?PHP$conn=mysql_connect("localhost", "root", "root") or die("Database connection Failed"); mysql_select_db("Test",$conn) or die(Mysql_error()); mysql_query("Set Names UTF8"); $tabledump= ""; $query=mysql_query("Show Tables",$conn);  while($row=Mysql_fetch_array($query)){        $data[] =$row; }    foreach($data  as $key=$value) {        $tabledump. = "DROP TABLE IF EXISTS '$value[0] '; \ n '; $query 1=mysql_query("SHOW CREATE TABLE"$value[0] ' ",$conn);  while($row 1=Mysql_fetch_array($query 1)){            $data 1[] =$row 1; }        foreach($data 1  as $key 1=$value 1) {            $tabledump.=$value 1[1]. "; \ N\n "; }    }    file_put_contents("Dump.sql",$tabledump);?>

Recovery

<? PHP     $conn=mysql_connect die ("Database connection Failed");     mysql_select_db ("Test",$conndie (mysql_error());     mysql_query ("Set names UTF8");     $sql file_get_contents ("Dump.sql");     mysql_query ($sql,$conn);? >

MySQL backup function and recovery function ideas