Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

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: 96 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
03:49, 23 Jun 2016

Tags

Classifications

Public