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.