Questions & Answers
How helpful is this to you?
Kace K1000 Management Appliance
KACE Product Support
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
[ - ] Hide Comment
2 weeks ago
in security settings you can enable database access and then pull it off into another DB.
2 weeks ago
I don't understand. Can you provide more detail? I want to duplicate the entire database
Answer this question
on this question for clarity
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)
for the full procedure:
Answered 04/06/2018 by:
1 week ago
There's not a way we can duplicate the database?
1 day 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.
1 day ago
last edited 16 hours 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.
Don't be a Stranger!
Sign up today to participate, stay informed, earn points and establish a reputation for yourself!
K1000 User Console Page
Script for purging backups
Incorrect Software Catalog Inventory. Many versions of google chrome
K1000: Script performance issues.
Problems deploying Windows 10 to non Dell systems?
Devart OnWheel Lottery
IT certification gives federal job seekers an edge
K1000 UserVoice Feedback Forum
ITNinja Feedback Forum at UserVoice
KBOX Systems Management Appliances Updated With Solaris Support, New Security Policies and Easier Agent Deployment
Education Market Manages Networks with KACE
KACE(tm) Offers Roadmap to Improved End Point Security
New KBOX Appliances Bring Enterprise-Grade, Cross Platform IT Automation to Mid-Market
New KBOX Systems Deployment Appliances Take the Legwork Out of Provisioning
KACE Launches New Help Desk Module For Upgraded KBOX IT Management Applicance
Managing Dell Servers with the Dell KACE K1000 and Dell Open Manage
Data and Insights that Matter Unveiling the All-New Contact Building App from DataCaptive