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.

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