Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $mysqlUserName = "Your Username";
- $mysqlPassword = "Your Password";
- $mysqlHostName = "Your Host";
- $DbName = "Your Database Name here";
- $backup_name = "mybackup.sql";
- $tables = "Your tables";
- $mysqli = new mysqli( $mysqlHostName,$mysqlUserName,$mysqlPassword,$DbName);
- $mysqli->select_db($DbName);
- $mysqli->query("SET NAMES 'utf8'");
- if (file_exists($DbName)) {
- $sqlSource = file_get_contents($backup_name);
- if (!$mysqli->multi_query($sqlSource)) {
- echo 'Error: Import Fail';
- } else {
- echo 'Restore Completed';
- }
- } else {
- echo 'Error: Backup File ('.$backup_name.') Does Not Exists';
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement