Ask the Community
Groups
Tip: Running SQL scripts on Traverse - Connect IT Community | Kaseya
<main> <article class="userContent"> <p><strong>QUESTION:</strong></p> <p>How do I run SQL scripts on Traverse?</p> <p>Occasionally, Kaseya Support will ask you to run certain SQL script/s. The script will be provided to you as an attachment on the Support ticket. </p> <p><strong>SOLUTION:</strong></p> <p><strong>NOTE:</strong> <br>Please download and unzip the attachment provided to you on the Support ticket. <br><strong>Please substitute mysql.sql below with the actual name of the script after unzip.</strong><br><strong>Please substitute TRAVERSE_HOME with your Traverse installation directory<br></strong>Should there be an error when running the script, please review the results of output.txt<br>Should there be an error when running the script, please copy and paste the execution results on the ticket</p> <p><strong>For Windows:</strong></p> <ul><li>Open an elevated command prompt (using 'Run as administrator')</li> <li>Navigate to C:\Temp (or the directory of your choosing where the script is unzipped) and run</li> <li> cd C:\Temp</li> <li>TRAVERSE_HOME\bin\dgedb.init.cmd admin dge < mysql.sql > output.txt<br><br></li> </ul><p><strong>For Linux:</strong></p> <ul><li>Navigate to /tmp (or the directory of your choosing where the script is unziped) and run</li> <li> cd /tmp</li> <li>TRAVERSE_HOME/etc/dgedb.init admin dge < mysql.sql > output.txt</li> </ul> </article> </main>