Automatically backing up your MongoDB

Follow

Omer

December 19, 2017 19:32

Sisense uses MongoDB for storing your Sisense web environment information.

This information includes how dashboard and widgets are configured, your system's users and groups, and many other configurations. Since the web environment can regularly change, and may need to be restored, it's useful to keep regular backups of this data.

I've published a Knowledge Base article, "Automatically Backup Sisense Web Data", that shows how to use a program that will perform daily backups of this data: Please note, that this article is relevant for versions 6.7 and above.

Feel free to comment below with any questions you may have. 

That's it! Happy back-uping! 

4

• 

  David Hertzberg December 28, 2017 16:35

  Thanks ! I am installing it right now !

  Quick question though : for the backup script, do you have to use the WriteUser or you could use a ReadUser ?

  Best,

  David.

  0

  Comment actions Permalink
• 

  Sam Ovenshine January 04, 2018 18:27

  Hi David,

  Just tested the MongoDump utility with the ReadUser, and it did run successfully.

  Thanks,
  Sam

  0

  Comment actions Permalink
• 

  Conor Hennessy January 16, 2018 10:27

  Hi,

  The first cmd in both scripts do not work (switching to C drive): C:\ 

  If you change it to C: it works as it should. You would not notice this if your script is run from C drive but if you try run from another drive the script fails.

  Conor

  0

  Comment actions Permalink
• 

  Omer January 16, 2018 10:31

  Hi Conor,

  Thanks for bringing this to our attention.

  I tried to reproduce this issue but couldn't, could you please provide me with steps in order to do so?

   

  Thanks,

  0

  Comment actions Permalink
• 

  Conor Hennessy January 16, 2018 11:02

  I have script on D drive, when i run it from there it failed to switch to C drive with cmd: "C:\" and so cannot run.

  This is the output:

  
  D:\Scripts>c:\
  'c:\' is not recognized as an internal or external command,
  operable program or batch file.

  D:\Scripts>cd C:\Program Files\Sisense\Infra\MongoDB

  D:\Scripts>mongodump --host localhost:27018 --db prismConfig --out C:\SisenseWeb
  Backups\MongoBackup --authenticationDatabase admin -u x -p x
  'mongodump' is not recognized as an internal or external command,
  operable program or batch file.

  D:\Scripts>mongodump --host localhost:27018 --db prismWebDB --out C:\SisenseWebB
  ackups\MongoBackup --authenticationDatabase admin -u x -p x
  'mongodump' is not recognized as an internal or external command,
  operable program or batch file.

  D:\Scripts>pause
  Press any key to continue . . .

   

  0

  Comment actions Permalink
• 

  Andrew Block January 16, 2018 17:27

  This is great nice work Omer!

  1

  Comment actions Permalink
• 

  Sam Ovenshine January 18, 2018 18:52

  Hi Conor,

  Thanks for the feedback. I've updated the scripts to fix this issue.

  Thanks,
  Sam

  0

  Comment actions Permalink
• 

  Thomas Warner October 25, 2018 14:01

  Is it necessary to run 'MongoBackup.bat' or is copying (or backing up) the directories in this post good enough? https://documentation.sisense.com/latest/getting-started/backing_up_sisense.htm

  ------

  1. In Windows Services, stop the Sisense.Repository and Sisense.Discovery services.
  2. Open the directory: 
     %ProgramData%\Sisense\PrismWeb\Repository\DB
  3. Copy the data to your backup location maintaining the same file structure.
  4. Open the directory:
     %ProgramData%\Sisense\Infra\Discovery
  5. Copy the data to your backup location maintaining the same file structure.
  6. (Optional) Back up your custom plugins by copying the directory:
     C:\Program Files\Sisense\PrismWeb\plugins

  0

  Comment actions Permalink

Please sign in to leave a comment.