on 08-24-2010 8:43 AM
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
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 ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.