/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Is it possible to get a backup dump of the Kace database

03/21/2017 955 views
How can I take a backup dump of the Kace database?  I would like to be able to import this database backup to some other server so that I can run reports against the external database.
3 Comments   [ + ] Show comments

Comments

  • You can connect to KACE DB using any external mysql client and take backup
    • What command do you use to connect remotely to take backup? I was trying mysqldump with the report account, but it was saying that it does not have access
  • if you aren't sure out to connect, this is a little old but the method hasn't changed.

    https://www.youtube.com/watch?v=LRWbSu_vxQE
  • My question was about getting the backup of the whole database. I know how to remotely connect to the database already, and I am using that method to run remote queries against the Kace database. I was asking about how we can take the database on the Kace appliance and put it on another machine.

All Answers

1
For read-only access (i.e. only running reports), follow the suggestions in the comments. If you want to test SQL that will alter the db, then exporting the db is a good idea (even better is to have a test/dev instance... but I digress). To get a db dump, download the incremental ("incr") backup file in Settings > Control Panel > Backup Settings (this file is huge and contains a bunch of other KACE resources).
Answered 03/22/2017 by: JasonEgg
Red Belt

  • Hi, I tried looking at the backups and I untarred the incremental backup and found what does look like the whole database itself. How do I import this into another computer to use ?
    • Hmmm... I don't know, actually. I'm guessing you can google to find an explanation for expanding a similar db.
1
[insert my usual "I know nothing about Kace" disclaimer] Wouldn't you handle this exactly the same way as any MySQL database?
Answered 03/24/2017 by: VBScab
Red Belt

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