Better edge backup v5.2 – Deonet Backup Solutions 5.2.7.0 User Manual

Page 107

Better Edge Backup v5.2

User Guide

Page 107 of 121

(September 16, 2008)

15.4 How to backup MySQL server on Linux (command line mode)

If you want to setup Better Edge Backup to backup MySQL server running on Linux using command line mode,
please do the followings:

Create a backup account on OBS

ii.

Logon to the web interface of OBS using the backup account created in the previous step (doesn’t
matter if it is not from the Linux server running the MySQL server to be backed up)

iii.

Create a new backup set by pressing the [Backup Set] -> [Add] button

iv.

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

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

vi.

Setup the [Backup Set] -> [Backup Source] setting

Add an “MySQL” entry to the [Backup Source] if you want to backup all databases under this
MySQL Server

Add two entries, “MySQL/database1” and “MySQL/database2”, to the [Backup Source] if you
want to backup both “database1” and “database2” under this MySQL Server

(Please use “\” instead of “/” if the MySQL server to be backed up is running on Windows
instead of Linux)

vii.

Setup the [Backup Set] -> [Backup Schedule] by pressing the [Add] link next the the “Backup
Schedule” sub-title

viii.

Install Better Edge Backup onto the Linux server running MySQL server (Please refer to the [

2.1

Installation of Better Edge Backup

] section for details. The command line mode installation

instructions are available on the web interface)

ix.

Completed

If you have started up the Better Edge Backup backup scheduler in the previous step, selected
databases will be backed up automatically at scheduled time