/build/static/layout/Breadcrumb_cap_w.png

How do I setup a test KBOX MySQL DB to try my insert into queries on

Hello,

I write queries in MySQL, usually just select statements but this time I need to write an 'insert into' query to set up a custom field in the Machine table. I want to test my 'insert into' statement before I use it on our live database and I was wondering how I would go about getting our backup database file and creating a test database that I can mess around with without breaking anything.

I think this might be a MySQL question more than a KACE question but I thought I'd try here anyways to see if anyone else has done something similar and has some advice or a link to some instructions.

 

Cheers,

jobla


0 Comments   [ + ] Show comments

Answers (1)

Posted by: nshah 10 years ago
Red Belt
1

You might want to check this out. We have a test queue in our helpdesk that we use to test out our statements and updates...etc so that the main helpdesk doesn't get messed with until we are 100% it will work. If the test queue gets messged up we simply delete it. 

If you are on 5.4.76847 you can duplicate your queue.

 

http://www.kace.com/support/resources/kb/article/creating-testing-and-troubleshooting-helpdesk-ticket-rules

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