Deonet Backup Solutions 5.2.7.0 - Manual (Page 103)

Better Edge Backup v5.2
User Guide
Copyright © 2008, Better Edge Technology, Inc. All Rights Reserved. Page 103 of 121 (September 16, 2008)
15 Backup/Restore MySQL Server
This chapter will describe in details how to use Better Edge Backup to backup your MySQL server and how you can
restore your MySQL server from the database backup files.
15.1 Requirements
i. Better Edge Backup must be installed onto the computer running MySQL server.
ii. Data from MySQL server will be backed up to a temporary directory before they are sent to Offsite
Backup Server. Please make sure you have sufficient space on your computer to store these data
when you run the backup job.
iii. There must be a MySQL account can be used to connect from localhost.
Add two new MySQL accounts for Backup Manager
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'
-> IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost.localdomain'
-> IDENTIFIED BY 'some_pass';
mysql> FLUSH PRIVILEGES;
They are superuser accounts with full privileges to do anything with a password of some_pass.
15.2 Overview
Better Edge Backup will backup your MySQL server by taking the following steps:
i. Run all Pre-Commands of this backup set
ii. All database(s) (either local or external) selected are backed up to a temporary directory specified
in its backup set
iii. Run all Post-Commands of this backup set
iv. Upload all backup files from the temporary directory to an Offsite Backup Server
v. Remove temporary files from the temporary directory if [Setting] -> [Temporary Directory for
storing backup files] is enabled