Advertisement
michaelyuen

Untitled

Jun 2nd, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.71 KB | None | 0 0
  1. <?php
  2.     $mysqlUserName      = "Your Username";
  3.     $mysqlPassword      = "Your Password";
  4.     $mysqlHostName      = "Your Host";
  5.     $DbName             = "Your Database Name here";
  6.     $backup_name        = "mybackup.sql";
  7.     $tables             = "Your tables";
  8.        
  9.         $mysqli = new mysqli( $mysqlHostName,$mysqlUserName,$mysqlPassword,$DbName);
  10.         $mysqli->select_db($DbName);
  11.         $mysqli->query("SET NAMES 'utf8'");
  12.  
  13.         if (file_exists($DbName)) {
  14.                 $sqlSource = file_get_contents($backup_name);
  15.                 if (!$mysqli->multi_query($sqlSource)) {
  16.                     echo 'Error: Import Fail';
  17.                 } else {
  18.                     echo 'Restore Completed';
  19.                 }
  20.         } else {
  21.                 echo 'Error: Backup File ('.$backup_name.') Does Not Exists';
  22.         }
  23. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement