Backing Up BusinessObjects MySQL Databases

Ryan Muldowney —  April 29, 2011 — 2 Comments

Both the Edge and Enterprise versions of SAP BusinessObjects come prepackaged with MySQL as a database option, which is a great choice if you don’t have your own existing database to use. This allows BusinessObjects to be quickly installed, without the need to involve the IT staff. However, many clients that choose the MySQL option don’t have experience with the software. Even though MySQL is a full-fledged database solution, out of the box the user is provided with little more than a command line for an administration tool. This can present a big problem, especially when it comes to backing up your BusinessObjects repository and audit databases.

A solid backup plan for these databases is essential. Without its repository, BusinessObjects simply cannot function. Having consistent regular backups of both the databases and the FileStore on disk will allow you to fully restore your environment in case of hardware failure or another disaster.

So how do we backup databases in MySQL? There’s a few approaches, but the simplest is the mysqldump command. This command generates a text file with a series of SQL commands to create and populate the tables in the given database. We can then backup this file along with the FileStore and we’ve got a complete backup of our BusinessObjects environment.

The command itself is pretty straightforward, so let’s just get to it:

mysqldump --user [username] --password [password] [database] > [filename]

We just need to provide the username, password, database name, and filename, and mysqldump does the rest.¬†As I mentioned above, BusinessObjects creates both a repository and audit database during installation. In MySQL these are named boe120 and boe120_audit. We’ll want to backup both of these. I suggest creating a batch file that can then be scheduled using Windows Task Scheduler, so you’ll always have a regular backup.

Here’s an example of what the batch file would look like:

cd C:\backup
"C:\Program Files\Business Objects\MySQL5\bin\mysqldump"
    --user root --password=root boe120 > boe120.dump
"C:\Program Files\Business Objects\MySQL5\bin\mysqldump"
    --user root --password=root boe120_audit > boe120_audit.dump

In this case, your backup files will be created in C:\backup. From here they can be picked up by your regular backup processes and moved to a network location. Don’t forget to also backup the entire contents of the FileStore along with this, located at C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\FileStore by default.

Web Intelligence Best Practices Guide

We put together a Best Practices Guide for Web Intelligence Development that includes over 20 pages of tips and techniques for developing business-ready reports. Plus we'll show you the common functions that have a negative impact on performance, how to create interactive reports, the best ways to standardize look-and-feel, and more!

GET YOUR FREE COPY OF THE GUIDE TODAY!

Powered by ConvertKit

Ryan Muldowney

Posts

2 responses to Backing Up BusinessObjects MySQL Databases

  1. Very helpful…Thanks Ryan for posting it….Never thought the backup of MySQL will be so simple. :-)

  2. When I try to create this dump I get a 1045 error unable to connect to the data base and the issue is it did not prompt for any user name and password for MYSQL database. Can I use any default user name and password for me to connnect to the database and extract the dump.
    Thanks
    Ram

Leave a Reply