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
Answers (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.
