|
Backup and Restore of MySQL Server - Linux |
|
This articla describes how to use Mozzie Backup to backup your MySQL server and how you can restore MySQL server from the database backup files.
Requirements
- Mozzie Backup should be installed onto the computer running MySQL server
- Data from MySQL server will be backed up to a temporary directory before being sent to the Mozzie Backup Server
- You will require a MySQL account to be used for connecting from localhost
Add two new MySQL accounts for Mozzie Backup 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; These are superuser accounts with full privileges to do anything with a password of some_pass
Overview
Mozzie Backup will backup your MySQL server in the following sequence:
- Run all Pre-Commands of this backup set
- All database(s) (either local or external) selected are backed up to a temporary directory specified in its backup set
- Run all Post-Commands of this backup set
- Upload all backup files from the temporary directory to Mozzie Offsite Backup Server
- Remove temporary files from the temporary directory if [Setting] -> [Temporary Directory for storing backup files] is enabled
How to backup MySQL server on Linux (command line mode)
If you want to setup Mozzie Backup to backup MySQL server running on Linux using command line mode, please do the followings:
- Logon to the web interface of Mozzie Backup Server using the backup account (doesn’t matter if it is not from the Linux server running the MySQL server to be backed up)
- Create a new backup set by pressing the [Backup Set] -> [Add] button
- Select the [Backup Set] -> [Type] -> [MySQL Database Server] radio button and press the [Update] button (which can be found at the bottom of the page)
- Setup all [Backup Set] -> [Database Backup Setting]
|
Settings
|
Descriptions
|
|
MySQL Username (e.g. root)
|
A MySQL user account that has backup access to the databases to be backed up (e.g. root). Please refer to the [Requirements] section for details
|
|
MySQL Password
|
Password of the MySQL user account being used
|
|
Host
|
IP address / Hostname of the MySQL Server, e.g. localhost
|
|
MySQL Connection TCP/IP Port
|
TCP/IP port used to access the MySQL Server (default: 3306)
|
|
Path to MySQL backup utility (mysqldump)
|
Full path to where mysqldump can be found (e.g. /usr/bin/mysqldump)
|
|
Temporary Spooling Directory
|
A temporary directory to be used to store all MySQL database dump files before they are uploaded to the backup server
|
|
Enable Delete Temp. File
|
Whether to delete the temporary MySQL database dump files after they are uploaded to the backup server
|
r
|
