/build/static/layout/Breadcrumb_cap_w.png

Kace Database

Does anyone know if there is a way I can copy my Kace database?
I want to copy the entire database to somewhere else and make the copy read-only.
I would also need to be able to run reports from the copied database

1 Comment   [ + ] Show comment
  • in security settings you can enable database access and then pull it off into another DB. - n1md4 6 years ago
    • I don't understand. Can you provide more detail? I want to duplicate the entire database - cjohnson4 6 years ago

Answers (1)

Posted by: Nico_K 6 years ago
Red Belt
3
Go to Settings | Security Settings and you can enable the access to the database from external.
Then connect any DB Reporting tool (like mysqlworkbench) to it and run the reports.
This acess is read only and you always have the current database fields (and since it is read only you will not corrupt it due to this way)

Comments:
  • There's not a way we can duplicate the database? - cjohnson4 6 years ago
    • What is the reason you want to copy the database? If all you want to do is read-only reporting then this method is best. You can't write to the database with the R1 user so you don't have to worry about messing anything up. And you can query the database live rather than having to export every time you want an updated query. - JasonEgg 6 years ago
    • FWIW, once you're connected you should be able to duplicate the database as well (mysqldump should work, though I haven't tested that), but I agree w JasonEgg that this seems like an unnecessary extra step. - EricAtStauer 6 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ