How can I archive data in Securonix.

asked 17 Apr '14, 14:41

Praful's gravatar image

Praful ♦♦
1264925
accept rate: 5%

edited 17 Apr '14, 14:41


1) Create new database "securonixwarm" a) create database securonixwarm b) mysqldump -uroot -ppass -d securonix | mysql -u root -ppass -Dsecuronixwarm 2) Edit securonix_home/conf/application-context.xml, make sure you have the following tag a) <archiving enabled="true" archivenumdays="80" enablejobcleanup="true" enableerrorlogcleanup="true"/> b) archiveNumDays notifies the number of days prior to today. In this case, anything 80 days before today will be archived. 3) Edit securonix_home/conf/hibernate/hibernate.cfg.archive.xml a) Make changes to MySQL settings. Provide JDBC URL,username and pass. a) Do not use datasource. 4) If you changed application-context.xml, restart the application 5) Run the archival job a) UI> Configure> Task > run archival Job

link

answered 17 Apr '14, 14:41

Praful's gravatar image

Praful ♦♦
1264925
accept rate: 5%

I install Securonix RTI 4.6 and DB('securonix') on my local without any error. UI is up.

My local DB username is root and password is password.

I run 'create database securonixwarm' query so it create empty db without any tables on my local instance

Then I tried following mysqldump query as you mention in forum but it is not work on workbench.

mysqldump -uroot -ppassword -d securonix | mysql -u root -ppassword -Dsecuronixwarm

link

answered 28 Feb '15, 01:55

sunil's gravatar image

sunil
151
accept rate: 0%

you dont run mysqldump from the workbench , rather the command line ...

link

answered 28 Feb '15, 09:13

mnair's gravatar image

mnair
711410
accept rate: 9%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×2
×1
×1

Asked: 17 Apr '14, 14:41

Seen: 1,687 times

Last updated: 28 Feb '15, 09:13

Related questions