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.




0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity



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.



Answered 05/16/2013 by: nshah
Red Belt

Please log in to comment