Deonet Backup Solutions 5.2.7.0 manual How to backup MySQL server on Linux command line mode

Better Edge Backup v5.2

User Guide

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:

i.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)

v.Setup all [Backup Set] -> [Database Backup Setting]

Settings	Descriptions
MySQL Username (e.g	A MySQL user account that has backup access to the
root)	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 TCP/IP port used to access the MySQL Server (default:

Port3306)

Path to MySQL backup utility (mysqldump)

Temporary Spooling Directory

Enable Delete Temp. File

Full path to where mysqldump can be found (e.g. /usr/bin/mysqldump)

A temporary directory to be used to store all MySQL database dump files before they are uploaded to the backup server

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

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