Better Edge Backup v5.2
User Guide
15.5 How to restore MySQL server
Please follow the instructions below to restore MySQL server from an Offsite Backup Server.
i.Download the database backup files to be restored from the Offsite Backup Server
Please refer to the [5.3 Restoring file] section for information on how to download backup files from Offsite Backup Server.
ii.Restore the database named [db_name] from the database backup file [db_name.sql]:
a.Connect to the MySQL server
(Windows) C:\> mysql
(Linux) [root@server ~]# mysql
b.Create the database to be restored
mysql> CREATE DATABASE IF NOT EXISTS db_name
c.Restore the database backup file back into the MySQL server
mysql> use db_name ; mysql> source db_name.sql ;
If db_name.sql is not located in the current directory, please specify the full path to the db_name.sql file in the command above.
iii.Repeat the same procedure for each database to be restored to the MySQL Server.
iv.Completed
Copyright © 2008, Better Edge Technology, Inc. All Rights Reserved. | Page 108 of 121 | (September 16, 2008) |
