How to restore MySql SQL Server with Nordic Backup Pro | Secure Cloud Backup Software | Nordic Backup
<!DOCTYPE html><!-- [et_pb_line_break_holder] --><html><!-- [et_pb_line_break_holder] --> <head><!-- [et_pb_line_break_holder] --> <title></title><!-- [et_pb_line_break_holder] --> </head><!-- [et_pb_line_break_holder] --> <body><!-- [et_pb_line_break_holder] --> <table class="body_main_table"><!-- [et_pb_line_break_holder] --> <tr class="body_main_table"><!-- [et_pb_line_break_holder] --> <td class="body_main_table"><!-- [et_pb_line_break_holder] --> <table class="body_headline"><!-- [et_pb_line_break_holder] --> <tr class="body_headline"><!-- [et_pb_line_break_holder] --> <td class="body_headline"><!-- [et_pb_line_break_holder] --> How to restore MySql SQL Server with Nordic Backup Pro<!-- [et_pb_line_break_holder] --> </td><!-- [et_pb_line_break_holder] --> </tr><!-- [et_pb_line_break_holder] --> </table><!-- [et_pb_line_break_holder] --> </td><!-- [et_pb_line_break_holder] --> <td align="center" valign="middle" width="190"></td><!-- [et_pb_line_break_holder] --> </tr><!-- [et_pb_line_break_holder] --> <tr><!-- [et_pb_line_break_holder] --> <td align="left" colspan="2" valign="top" width="100%"><!-- [et_pb_line_break_holder] --> <table class="body_main_table"><!-- [et_pb_line_break_holder] --> <tr><!-- [et_pb_line_break_holder] --> <td class="body_content" colspan="3"><!-- [et_pb_line_break_holder] --> <table border="0" cellpadding="5" cellspacing="5" class="blue" width="100%"><!-- [et_pb_line_break_holder] --> <tr><!-- [et_pb_line_break_holder] --> <td align="right" class="blue" colspan="2" valign="top"><!-- [et_pb_line_break_holder] --> <a href="/how-to-restore-mysql-sql-server-with-nordic-backup-pro.html&print=1" style="text-decoration: none;" target="_new">Print user guide <i class="fa fa-print"></i></a><!-- [et_pb_line_break_holder] --> </td><!-- [et_pb_line_break_holder] --> </tr><!-- [et_pb_line_break_holder] --> <tr><!-- [et_pb_line_break_holder] --> <td colspan="2" height="25"></td><!-- [et_pb_line_break_holder] --> </tr><!-- [et_pb_line_break_holder] --> <tr><!-- [et_pb_line_break_holder] --> <td align="left" valign="top"><!-- [et_pb_line_break_holder] --> To begin a restore of files in Nordic Backup Pro, open NB Pro and click on "Restore".<!-- [et_pb_line_break_holder] --> </td><!-- [et_pb_line_break_holder] --> <td align="left" valign="top" width="300"><!-- [et_pb_line_break_holder] --> <img alt="Open Nordic Backup Pro and click Restore" title="Open Nordic Backup Pro and click Restore" border="0" src="/wp-content/userguides//filerestore55/file_rest_en_pro_0101.png"><!-- [et_pb_line_break_holder] --> </td><!-- [et_pb_line_break_holder] --> </tr><!-- [et_pb_line_break_holder] --> <tr><!-- [et_pb_line_break_holder] --> <td colspan="2" height="25"></td><!-- [et_pb_line_break_holder] --> </tr><!-- [et_pb_line_break_holder] --> <tr><!-- [et_pb_line_break_holder] --> <td align="left" valign="top"><!-- [et_pb_line_break_holder] --> Choose the backup set to restore, if you have multiple backups setup in your account. Select the set to restore and click Next to choose the database.<!-- [et_pb_line_break_holder] --> </td><!-- [et_pb_line_break_holder] --> <td align="left" valign="top" width="300"><!-- [et_pb_line_break_holder] --> <img alt="Select the backup set to restore" title="Select the backup set to restore" border="0" src="/wp-content/userguides//dbbackup55/mysql_rest_en_01.png"><!-- [et_pb_line_break_holder] --> </td><!-- [et_pb_line_break_holder] --> </tr><!-- [et_pb_line_break_holder] --> </table><!-- [et_pb_line_break_holder] --> <p class="guide-break"></p><!-- [et_pb_line_break_holder] --> <table border="0" cellpadding="5" cellspacing="5" class="blue" width="100%"><!-- [et_pb_line_break_holder] --> <tr><!-- [et_pb_line_break_holder] --> <td height="0"></td><!-- [et_pb_line_break_holder] --> </tr><!-- [et_pb_line_break_holder] --> <tr><!-- [et_pb_line_break_holder] --> <td align="left" valign="top"><!-- [et_pb_line_break_holder] --> First, you can select the date which to restore at the top next to "Show files as of Job". By default, your latest backup will be selected. In the left pane, expand down to the name of the database you wish to restore, then check the .SQL file to restore in the right pane.<br><!-- [et_pb_line_break_holder] --> <br><!-- [et_pb_line_break_holder] --> You will also need to specify the location to restore files to by clicking on 'Change'. Once a location has been selected with enough free space to accomodate the restore, click on 'Start Restore'.<!-- [et_pb_line_break_holder] --> </td><!-- [et_pb_line_break_holder] --> <td align="left" valign="top" width="300"><!-- [et_pb_line_break_holder] --> <img alt="Check the database file to restore" title="Check the database file to restore" border="0" src="/wp-content/userguides//dbbackup55/mysql_rest_en_02.png"><!-- [et_pb_line_break_holder] --> </td><!-- [et_pb_line_break_holder] --> </tr><!-- [et_pb_line_break_holder] --> <tr><!-- [et_pb_line_break_holder] --> <td colspan="2" height="25"></td><!-- [et_pb_line_break_holder] --> </tr><!-- [et_pb_line_break_holder] --> <tr><!-- [et_pb_line_break_holder] --> <td align="left" valign="top"><!-- [et_pb_line_break_holder] --> Once the database file has been restored, click on Close.<!-- [et_pb_line_break_holder] --> </td><!-- [et_pb_line_break_holder] --> <td align="left" valign="top" width="300"><!-- [et_pb_line_break_holder] --> <img alt="Click on Close once restore is complete" title="Click on Close once restore is complete" border="0" src="/wp-content/userguides//dbbackup55/sql_rest_en_03.png"><!-- [et_pb_line_break_holder] --> </td><!-- [et_pb_line_break_holder] --> </tr><!-- [et_pb_line_break_holder] --> </table><!-- [et_pb_line_break_holder] --> <p class="guide-break"></p><!-- [et_pb_line_break_holder] --> <table border="0" cellpadding="5" cellspacing="5" class="blue" width="100%"><!-- [et_pb_line_break_holder] --> <tr><!-- [et_pb_line_break_holder] --> <td height="0"></td><!-- [et_pb_line_break_holder] --> </tr><!-- [et_pb_line_break_holder] --> <tr><!-- [et_pb_line_break_holder] --> <td align="left" colspan="2" valign="top"><!-- [et_pb_line_break_holder] --> After the database files have been downloaded, open your MySQL management program or the command line tool. Create the database to be restored as a new database if it does not already exist using this command:<br><!-- [et_pb_line_break_holder] --> <br><!-- [et_pb_line_break_holder] --> mysql> CREATE DATABASE IF NOT EXISTS db_name<br><!-- [et_pb_line_break_holder] --> <br><!-- [et_pb_line_break_holder] --> If using the command line tool, the proper command to restore the database is as follows:<br><!-- [et_pb_line_break_holder] --> <br><!-- [et_pb_line_break_holder] --> mysql -h hostname -u username -p password databasename<br><!-- [et_pb_line_break_holder] --> </td><!-- [et_pb_line_break_holder] --> </tr><!-- [et_pb_line_break_holder] --> <tr><!-- [et_pb_line_break_holder] --> <td align="left" valign="top"><!-- [et_pb_line_break_holder] --> US v1.0<!-- [et_pb_line_break_holder] --> </td><!-- [et_pb_line_break_holder] --> </tr><!-- [et_pb_line_break_holder] --> <tr><!-- [et_pb_line_break_holder] --> <td colspan="2"><!-- [et_pb_line_break_holder] --> <table border="1" cellpadding="5" cellspacing="0" class="blue" width="100%"><!-- [et_pb_line_break_holder] --> <tr><!-- [et_pb_line_break_holder] --> <td align="center" valign="middle"><!-- [et_pb_line_break_holder] --> You have now completed the restore of MySQL Server data in Nordic Backup Pro.<!-- [et_pb_line_break_holder] --> </td><!-- [et_pb_line_break_holder] --> </tr><!-- [et_pb_line_break_holder] --> </table><!-- [et_pb_line_break_holder] --> </td><!-- [et_pb_line_break_holder] --> </tr><!-- [et_pb_line_break_holder] --> </table><!-- [et_pb_line_break_holder] --> </td><!-- [et_pb_line_break_holder] --> </tr><!-- [et_pb_line_break_holder] --> </table><!-- [et_pb_line_break_holder] --> </td><!-- [et_pb_line_break_holder] --> </tr><!-- [et_pb_line_break_holder] --> </table><!-- [et_pb_line_break_holder] --> </body><!-- [et_pb_line_break_holder] --></html>