cancel
Showing results for 
Search instead for 
Did you mean: 

how to backup explorer blade edition mysql database

former_member633852
Participant
0 Kudos

Dear experts,

We've installed explorer blade edition 2.0 on suse linux, i want to backup online filesystem and online db backup,

how can i backup online mysql db ?

I've found following SAP notes ;

1202202 - How to create MySQL database backups or .dmp files for BusinessObjects Enterprise XI Release 2

1203308 - How to restore a MySQL Database backup of the CMS Repository

sap note 1202202 has following information ;

To create a MySQL backup or .dmp file on Linux:

Repeat steps 1 and 2 as above.

Open a shell connected to the computer containing MySQL and the CMS database. Type the following:

mysqldump databasename > back_up_cms.sql -u root -p

Enter the correct root password when prompted.

Verify the back_up_cms.sql was created successfully.

How can i learn what is my database name ?

What are your recommendations about backup explorer cmc mysql database backup on linux,

Best Regards

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member633852
Participant
0 Kudos

Hello Again,

As per nore 1202202 - How to create MySQL database backups or .dmp files for BusinessObjects Enterprise XI Release 2

2. Create the backup:

./mysqldump --socket=<path to bobje>/bobje/mysql/mysql.sock -u <username> -p BOE115 > <dump file>

I've execute following command and it works ;

/home/boeadm/boexi/bobje/mysql/bin/mysqldump --socket=/home/boeadm/boexi/bobje/mysql/mysql.sock -u root -p BOE120 > /backup/back_up_cms.sql

BOE120 is mysql schema name, is this command enough for cms database full recovery ?