KACE Product Support Question

Kace Database

04/06/2018 1697 views
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.
    • I don't understand. Can you provide more detail? I want to duplicate the entire database

All Answers

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)
Answered 04/06/2018 by: Nico_K
Red Belt

  • There's not a way we can duplicate the database?
    • 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.
    • 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.

Don't be a Stranger!

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

Sign up! or login


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