if (isset($_POST["import"])) { if (isset($_FILES["importFile"]["tmp_name"]) && strlen($_FILES["importFile"]["tmp_name"]) > 0) { $file = $_FILES["importFile"]["tmp_name"]; // set name based on whether existing or new values have been defined. // favour new to avoid nuking existing dbs where possible if (isset($_POST["db-existing"])) { $dbName = $_POST["db-existing"]; } if (isset($_POST["db-new"])) { if (strlen($_POST["db-new"])) { $dbName = $_POST["db-new"]; } } // if we've got a file and a database name, import it if (isset($file) && isset($dbName)) { if (!($restoreResult = importDB($connection, $dbName, $file, $dbs))) { $restoreResult = true; } } else { $restoreResult = "Can't use specified filename/database."; } } } // disconnect from db server mysql_close($connection); ?> <!DOCTYPE html> <html>
packageDelete($option); break; case 'deletepackage': pakageDeleteProcess(); break; case 'cancel': cancelMolecule(); break; case 'about': aboutComponent(); break; case 'exportdb': exportDB(); break; case 'importdb': importDB($option); break; case 'importdbprocess': importDBProcess(); break; case 'listoffiles': listOfFiles($option); break; case 'viewlog': showLogFile(); break; case 'delfiles': delFiles($fid); break; default: showMolecules($option);
echo "\r\n <strong>\r\n <font color=\"red\">\r\n Fatal error captured:\r\n </font>\r\n </strong>\r\n "; echo "<pre>"; print_r($error); echo "</pre>"; } } require_once 'migrationFunctions.php'; if (!isset($_POST['action'])) { showMenu(); } else { if (preg_match("/Export all databases/", $_POST['action'])) { $myMigration = new migration(); $myMigration->exportAllDBs(); } else { if (preg_match("/Import Mangesh/", $_POST['action'])) { importDB(); } } } function showMenu() { ?> <!DOCTYPE html> <html lang="en"> <head> <title>MySQL Export by Mangesh Sangapu</title> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.0/jquery.min.js"></script> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
$file_tmp_name = $_FILES['userfile']['tmp_name']; // ECHO $file_tmp_name; // ECHO "<br/>"; $file_size = $_FILES['userfile']['size']; // ECHO $file_size; //ECHO "<br/>"; $file_type = $_FILES['userfile']['type']; // ECHO $file_type; //ECHO "<br/>"; //if file is empty if ($file_size <= 0) { die('<center>Can not upload empty file</canter>'); } //if file is not SQL type if (!($file_type == "application/octet-stream")) { die('<center>This is not Database file</center>'); } //checking that file is uploaded via http poet method if (is_uploaded_file($file_tmp_name)) { //copy that uploaded file to our main folder if (!move_uploaded_file($file_tmp_name, $file_name)) { die("<center>cannot copy file {$file_name}</center>"); } } else { //die("Possible file upload attack:"); } //echo $filename = $_POST['userfile']; importDB($file_name, "localhost", "kashifdb", "123456", "composeup"); unlink($file_name); $_SESSION['check'] = "ImportSeccess"; header('Location: ../edit.php#/');
} } // display the tables on screen so we can see they were dumped echo "<h2>Showing tables after database export and table dump</h2>"; if ($tables = getTableList($connection, $config["db"]["name"])) { foreach ($tables as $id => $table) { printTable($connection, $table); } } else { echo "<br><br>No tables found.<br><br>"; } // // import database from file and show it on screen // echo "<h2>Showing tables after file import</h2>"; $importResult = importDB($connection, $config["db"]["name"], $config["db"]["backupFile"]); // if there's an error, show it if ($importResult) { echo $importResult; } // display the tables on screen so we can see they were dumped if ($tables = getTableList($connection, $config["db"]["name"])) { foreach ($tables as $id => $table) { printTable($connection, $table); } } else { echo "<br><br>No tables found.<br><br>"; } } else { echo "Error selecting database: " . mysql_error(); }