Question Re: CMS Database Backup in Technology Q&A

CMS Database Backup

Former Member — Mon, 17 Jun 2013 06:23:52 GMT

Hello Everyone,

I need to take the CMS Database backup but not able to get how can I do this. After searching allot I found that I have to take the database dump using its client component and also to take the backup of Filestore folder.

But the thing with me is that I have not installed the BO and I don't know which database has been used for CMS, is there a way I can confirm this?

I am able to access the CMC, in Settings I am able to get the Database Name and Username that is "5.0.34-enterprise-nt" & "sa", but which database is used is not mentioned anywhere.

After knowing the database one more thing is that how will I take the dump of it, because there's no database client installed in my machine, do I need to install the database client in my machine to take the dump?

Any help would be appreciated.

Regards,

Tauceef

Re: CMS Database Backup

denis_konovalov — Mon, 17 Jun 2013 11:51:10 GMT

If you do not know which database it is even after seeing its name - then there is nothing we can do to help.

Your DBA needs to get involved and advice you which DB is used and how to make DB backups, as it is a trivial DBA routine.

Re: CMS Database Backup

manikandan_elumalai — Mon, 17 Jun 2013 11:57:51 GMT

Check here

In my case it is SQL Server and the ODBC name created is BOE140

If you have Oracle in your environment you should have Oracle TNS name for your server

Re: CMS Database Backup

Former Member — Mon, 17 Jun 2013 12:11:44 GMT

Hi Denis,

Thanks for the reply.

One more thing I want to share is when I search the database name "5.0.34-enterprise-nt" in google it seems to be MYSQL but I am not confirm.

Let's say If I assume that its in MYSQL only, then please let me know how can I go ahead.

In my machine I don't have MYSQL installed, do I need to install MYSQL to take the dump of CMS?

or if you can suggest any other means of doing this.

Regards,

Tauceef

Re: CMS Database Backup

former_member190781 — Mon, 17 Jun 2013 12:14:40 GMT

Hi Tauceef,

In CMC Settings page you could also see Datasoruce name, with the help of which you can easily findout which database is being used. Otherwise paste the screenshot of CMC Settings page here.

Regards,

Sohel

Re: CMS Database Backup

Former Member — Mon, 17 Jun 2013 12:14:57 GMT

Hi Mani,

In my case, its just the name I shared "5.0.34-enterprise-nt" is written in Database Name.

but as I have stated in my reply to Denis, I am assuming that its in MYSQL, can you please suggest on that.

Regards,

Tauceef

Re: CMS Database Backup

Former Member — Mon, 17 Jun 2013 12:24:00 GMT

Hi Sohel,

Here is the screenshot of CMC Setting.

Regards,

Tauceef

Re: CMS Database Backup

denis_konovalov — Mon, 17 Jun 2013 12:25:20 GMT

For instructions on how to backup/restore MySQL DB you can go here : http://www.mysql.com/

good luck finding where this mysql DB is located.

Re: CMS Database Backup

denis_konovalov — Mon, 17 Jun 2013 12:35:50 GMT

your mySQL DB is located on the same machine as your BOE server.

Re: CMS Database Backup

former_member190781 — Mon, 17 Jun 2013 13:20:10 GMT

Hi Tauceef,

You are using default MySQL database, following KB articles may help you with the backup and restore process.

1202202 - How to create MySQL database backups or .dmp files for BusinessObjects Enterprise XI Release 2 (Although its meant for XI R2 but applicable for 3.1 as well just the database name would be different)

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

Hope this helps.

Regards,

Sohel