Как загрузить БД из phpmyadmin в папку сайта?

<?php
// параметры базы данных
define("MHOST", "localhost");
define("MUSER", "имя пользователя базы данных");
define("MPASS", "пароль пользователя базы данных");
define("MDBNM", "имя базы данных mysql");
// файл экспорта
$backupfile = dirname(__FILE__) . '/data/export.sql';
// кодировка структуры
$serverCs = "utf8";
// кодировка данных
$dannyeCs = "utf8";
// пишем в строку
$out = "";
// сохранять структуру и данные
$data = 1;
// комментарии
$comment = '';
// исключяя таблицы
$except_tables = array();
// исключяя содержимое таблиц
$except_tables_data = array('user');
 
ignore_user_abort(true);
chdir(dirname(__FILE__).'');
error_reporting(E_ALL);
ini_set('display_errors', 1);
set_time_limit(3600);
ini_set('max_execution_time',3600);
// соединяемся с БД
$mysqli = new mysqli(MHOST, MUSER, MPASS, MDBNM);
if ($mysqli->connect_errno) {
    die('Connect Error: ' . $mysqli->connect_errno);
}
unlink($backupfile);
// форматируем
$CONF['date'] = '%d.%m.%Y %H:%M Uhr';
// лимиты
$mem_limit = 10;
$max_size = 500000 * $mem_limit;
// имена переменных и констант
$time = time();
 
 
// начало
// create comment
$out.= "# MySQL дамп базы данных\n";
$out.= "# backup date and time: " . strftime($CONF['date'], $time) . "\n";
$out.= "# built by mysql_backup 0.1\n";
// write users comment
if ($comment)
    {
    $out.= "# comment:\n";
    $comment = preg_replace("'\n'", "\n# ", "# " . $comment);
    foreach(explode("\n", $comment) as $line) $out.= $line . "\n";
    $out.= "\n";
    }
 
$mysqli->set_charset($serverCs);
$out.= "set names " . $serverCs . ";\n\n";
$out.= "### Текущий набор символов: ".$mysqli->character_set_name() . " ###\n";
 
// get tables and views
$all_tables = $all_views = array();
$res = $mysqli->query("show table status");
while ($row = $res->fetch_array())
    {
    if (sizeof($row['Engine']) == 0)
        {
        $all_views[] = $row;
        }
      else
        {
        $all_tables[] = $row;
        }
    }
// get table structures
$all_tables_new = array();
foreach($all_tables as $key => $table)
    {
    if (!in_array($table['Name'], $except_tables))
        {
        $res1 = $mysqli->query("SHOW CREATE TABLE `" . $table['Name'] . "`");
        $tmp = $res1->fetch_array();
        $table_sql[$table['Name']] = $tmp["Create Table"];
        $all_tables_new[$key] = $table;
        }
    }
$all_tables = $all_tables_new;
unset($all_tables_new);
// find foreign keys
$fks = array();
if (isset($table_sql))
    {
    foreach($table_sql as $tablenme => $table)
        {
        $tmp_table = $table;
        // save all tables, needed for creating this table in $fks
        while (($ref_pos = strpos($tmp_table, " REFERENCES ")) > 0)
            {
            $tmp_table = substr($tmp_table, $ref_pos + 12);
            $ref_pos = strpos($tmp_table, "(");
            // cut of '`' at the begining and end of fk-name
            $fks[$tablenme][] = trim(str_replace('`', '', substr($tmp_table, 0, $ref_pos)));
            }
        }
    }
// order $all_tables and check for ring constraints
$all_tables_copy = $all_tables;
// orders the tables in $tables according to the constraints in $fks
// $fks musst be filled like this: $fks[tablename][0]=needed_table1; $fks[tablename][1]=needed_table2; ...
function order_sql_tables($tables, $fks)
    {
    // do not order if no contraints exist
    if (!count($fks)) return $tables;
    // order
    $new_tables = array();
    $existing = array();
    $modified = TRUE;
    while (count($tables) && $modified == TRUE)
        {
        $modified = FALSE;
        foreach($tables as $key => $row)
            {
            // delete from $tables and add to $new_tables
            // does table has fk?
            if (isset($fks[$row['Name']]))
                {
                // find required tables
                foreach($fks[$row['Name']] as $needed)
                    {
                    // go to next table if not all needed tables exist in $existing
                    // in order to find all tables first, which do have no constraints or constraints which can already be resolved
                    if (!in_array($needed, $existing))
                        {
                        continue2;
                        }
                    }
                }
            // if all required tables are already in the new-tables-list:
            // delete from $tables and add to $new_tables
            $existing[] = $row['Name'];
            $new_tables[] = $row;
            prev($tables);
            unset($tables[$key]);
            $modified = TRUE;
            }
        }
    if (count($tables))
        {
        // probably there are 'circles' in the constraints, because of that no proper backups can be created
        // This will be fixed sometime later through using 'alter table' commands to add the constraints after generating the tables.
        // Until now I just add the lasting tables to $new_tables, return them and print a warning
        foreach($tables as $row) $new_tables[] = $row;
        return false;
        }
    return $new_tables;
    }
$all_tables = order_sql_tables($all_tables, $fks);
$ring_constraints = false;
// ring constraints found
if ($all_tables === false)
    {
    $ring_constraints = true;
    $all_tables = $all_tables_copy;
    $out.= "\n# ring constraints workaround\n";
    $out.= "SET FOREIGN_KEY_CHECKS=0;\n";
    $out.= "SET AUTOCOMMIT=0;\n";
    $out.= "START TRANSACTION;\n";
    }
unset($all_tables_copy);
$out.= "\n### drop all tables first ###\n";
foreach(array_reverse($all_tables) as $row)
    {
    $out.= "\nDROP TABLE IF EXISTS `" . $row['Name'] . "`;";
    }
$out.= "\n";
 
foreach($all_tables as $row)
    {
    $tablename = $row['Name'];
    $auto_incr[$tablename] = $row['Auto_increment'];
    $out.= "\n\n";
    // export tables
        $out.= "### structure of table `" . $tablename . "` ###\n\n";
        $out.= $table_sql[$tablename];
        // add auto_increment value
        if ($auto_incr[$tablename])
            {
            $out.= " AUTO_INCREMENT=" . $auto_incr[$tablename];
            }
        $out.= ";";     
    $out.= "\n\n\n";
    // if saving is successful, then empty $out, else set error flag
    if (strlen($out) > $max_size)
        {
        if ($out = file_put_contents($backupfile, $out, FILE_APPEND)) $out = "";
          else die('writing file');
        }
    }
 
$mysqli->close();
 
// соединяемся с БД
$mysqli = new mysqli(MHOST, MUSER, MPASS, MDBNM);
if ($mysqli->connect_errno) {
    die('Connect Error: ' . $mysqli->connect_errno);
}
 
$mysqli->set_charset($dannyeCs);
$out.= "set names " . $dannyeCs . ";\n\n";
$out.= "### Текущий набор символов: ".$mysqli->character_set_name() . " ###\n";
 
if ($data)
foreach($all_tables as $row) if (!in_array($row['Name'],$except_tables_data))
    {
    $tablename = $row['Name'];
    $auto_incr[$tablename] = $row['Auto_increment'];
    $out.= "\n\n";
    // export data
    $out.= "### data of table `" . $tablename . "` ###\n\n";
    // check if field types are NULL or NOT NULL
    $res3 = $mysqli->query("show columns from `" . $tablename . "`");
    $res2 = $mysqli->query("select * from `" . $tablename . "`");
    if (!$res2)
        {
        die('MySQL error: ' . $mysqli->error);
        }
    $number_of_rows = $res2->num_rows;
    if ($number_of_rows > 0)
        {
        for ($j = 0; $j < $number_of_rows; $j++)
            {
            $out.= "insert into `" . $tablename . "` values (";
            $row2 = $res2->fetch_row();
            // run through each field
            for ($k = 0; $k < $nf = $res2->field_count; $k++)
                {
                // identify null values and save them as null instead of ''
                if (is_null($row2[$k])) $out.= "null";
                  else $out.= "'" . $mysqli->real_escape_string($row2[$k]) . "'";
                if ($k < ($nf - 1)) $out.= ", ";
                }
            $out.= ");\n";
            // if saving is successful, then empty $out, else set error flag
            if (strlen($out) > $max_size)
                {
                if ($out = file_put_contents($backupfile, $out, FILE_APPEND)) $out = "";
                  else die('writing file');
                }
            }
        }
      else
        {
        $out.= "-- table is empty\n"; // no data
        }
    // if saving is successful, then empty $out, else set error flag
    if (strlen($out) > $max_size)
        {
        if ($out = file_put_contents($backupfile, $out, FILE_APPEND)) $out = "";
          else die('writing file');
        }
    }
// views
// get all view definitions
$all_views_definitions = array();
foreach($all_views as $row)
    {
    $viewname = $row['Name'];
    if (!in_array($viewname, $except_tables))
        {
        $res4 = $mysqli->query("show create view `" . $viewname . "`");
        if (!$res4)
            {
            die("MySQL error: " . $mysqli->error);
            }
        $row4 = $res4->fetch_array();
        $all_views_definitions[$viewname] = $row4['Create View'];
        }
    }
if (sizeof($all_views_definitions) > 0) $out.= "\n\n### views ###\n\n";
// order $all_views and check for ring constraints
// orders the views in $views according to the constraints in $fks
function order_sql_views($views)
    {
    // order
    $new_views = array();
    $existing = array();
    $modified = TRUE;
    while (count($views) && $modified == TRUE)
        {
        $modified = FALSE;
        foreach($views as $name => $definition)
            {
            // delete from $views and add to $new_views
            // does view refer to another view
            foreach(array_keys($views) as $dependendName)
                {
                if ($name != $dependendName && stripos($definition, '`' . $dependendName . '`') !== false)
                    {
                    continue2;
                    }
                }
            // if all required views are already in the new-views-list:
            // delete from $views and add to $new_views
            $new_views[$name] = $definition;
            prev($views);
            unset($views[$name]);
            $modified = TRUE;
            }
        }
    if (count($views))
        {
        // probably there are 'circles' in the constraints, because of that no proper backups can be created
        // This will be fixed sometime later through using 'alter table' commands to add the constraints after generating the tables.
        // Until now I just add the lasting tables to $new_tables, return them and print a warning
        foreach($views as $name => $definition) $new_views[$name] = $definition;
        return false;
        }
    return $new_views;
    }
$all_views_definitions_copy = $all_views_definitions;
$all_views_definitions = order_sql_views($all_views_definitions);
$ring_constraints = false;
// ring constraints found
if ($all_views_definitions === false)
    {
    $all_views_definitions = $all_views_definitions_copy;
    // if not already written because of tabel ring constraints
    if (!$ring_constraints)
        {
        $out.= "\n# ring constraints workaround\n";
        $out.= "SET FOREIGN_KEY_CHECKS=0;\n";
        $out.= "SET AUTOCOMMIT=0;\n";
        $out.= "START TRANSACTION;\n";
        }
    $ring_constraints = true;
    }
unset($all_views_definitions_copy);
// view drop statements (in reverse order)
if (count($all_views_definitions) > 0)
    {
    $out.= "### drop all views first ###\n\n";
    foreach(array_reverse($all_views_definitions) as $view_name => $view_definition)
        {
        $out.= "DROP VIEW IF EXISTS `" . $view_name . "`;\n";
        }
    $out.= "\n\n";
    }
// view definitions
foreach($all_views_definitions as $view_name => $view_definition)
    {
    $out.= "### create statement of view `" . $view_name . "` ###\n\n";
    $out.= $view_definition;
    $out.= ";\n\n";
    }
// if saving is successful, then empty $out, else set error flag
if (strlen($out) > $max_size)
    {
    if ($out = file_put_contents($backupfile, $out, FILE_APPEND)) $out = "";
      else die('writing file');
    }
// if db contained ring constraints
if ($ring_constraints)
    {
    $out.= "\n\n# ring constraints workaround\n";
    $out.= "SET FOREIGN_KEY_CHECKS=1;\n";
    $out.= "COMMIT;\n";
    }
// save to file
if (!file_put_contents($backupfile, $out, FILE_APPEND)) die('writing file');
if (!file_exists($backupfile)) die ('error checking file, maybe chmod 777 on this dir');
echo 'ok';