Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Storage Manager (STM) > Using dbutil to backup and run maintenance on your MariaDB Database

Using dbutil to backup and run maintenance on your MariaDB Database

Table of contents
No headers
Created by Interspire Import, last modified by MindTouch on Jun 23, 2016

Views: 1,123 Votes: 0 Revisions: 10

Using dbutil to backup and run maintenance on your DB

Note:
Storage Manager versions 5.6 and newer use MariaDB. For previous versions, MySQL is used. For versions prior to 5.6, substitute MySQL for MariaDB in the following instructions.

Storage Manager ships with a script that will make a backup of your database, as well as, run maintenance routines to help keep the database running smoothly.

Note: All STM services will be stopped when this runs. Make sure you have ample space on your hard disk before performing a backup.

Windows Instructions:

Linux Instructions:  

 

 ------------------------------------------------------------------

Windows

Script Location: \bin\dbutil.bat

The default Windows installation directory is C:\Program Files\SolarWinds\Storage Manager Server

Preparation

1. Edit your dbutil.bat file and find the following string: Set BackupStage=C:\temp\mariadb_backup

2. Change the path C:\temp\mariadb_backup to the directory where you would like to backup your Storage Manager database.

Note: It is recommended that you do NOT use a directory within the Storage Manager install directory.

Usage

dbutil.bat [backup|maintenance]

Options

backup: Copy database to backup directory

maintenance: Run database repair/analysis/optimization procedures

default (no options specified): Executes maintenance and backup

Scheduling

To run this using Windows task scheduler.

1. Open Windows Task Scheduler and Create a Basic Task with your desired schedule (Weekly for example).

2. Set the Action as Start a Program.

3. Program/script = \bin\dbutil.bat

4. Set the arguments to "backup" to only do a backup if desired.

-----------------------------------------------------------------------------

Linux

Script Location: /bin/dbutil.sh

Default Linux directory is /opt/Storage_Manager_Server

Preparation

1. Edit your dbutil.sh file and find the following string: export backupStage=/opt/mariadb_backup

2. Change the path /opt/mariadb_backup to the directory where you would like to backup your Storage Manager database.

Note: It is recommended that you do NOT use a directory within the Storage Manger install directory.

Usage

dbutil.sh [backup|maintenance]

Options

backup: Copy database to backup directory

maintenance: Run database repair/analysis/optimization procedures

default (no options specified): Executes maintenance and backup

Scheduling

Create a cron job to run the dbutil.sh on a schedule.

Last modified

Tags

Classifications

Public