/build/static/layout/Breadcrumb_cap_w.png
04/06/2018 511 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

Comments

  • 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

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)
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.