Deonet Backup Solutions 5.2.7.0 manual Backup/Restore MySQL Server, Requirements

Better Edge Backup v5.2

User Guide

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.1Requirements

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.2Overview

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

Copyright © 2008, Better Edge Technology, Inc. All Rights Reserved. Page 103 of 121 (September 16, 2008)