Skip to Content
Former Member
Feb 14, 2011 at 05:10 PM

Creating new data source for CMS on MySQL


Hi Team,

We have installed Business Objects XI R2 on Tomcat with CMS database as MySQL.

We took a backup sometime back as a standard process using the telnet command.

mysqldump -u username -p password databasename > http://backupfile.sql

Now, the database seems to be corrupted and we want to restore the backup file by creating a new database.

Coul someone please help me in doing this? I need the steps to be followed to create the new CMS database on the same MySQL server, restoring the database schema using the backup file and to configure the CMS to use the new database.

Thanks in advance.