<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Alex, <div><br></div><div>I'm trying to drop but I'm getting the error attached.</div><div>I'm using the following command:</div><div><br></div><div>mysqladmin -u root -p XXXX drop</div><div><br></div><div>but then I got the error attached and I also tried:</div><div><br></div><div>mysqladmin -u root -p drop</div><div>password: XXXX</div><div><br></div><div>another error attached.</div><div><br></div><div>Thanks,</div><div><br><font style="font-size:10pt;" face="Comic Sans MS" size="2"><br></font><font style="font-size:10pt;" face="Comic Sans MS" size="2">Renato Gentil</font> <br><br><br><div><hr id="stopSpelling">Date: Wed, 10 Dec 2014 23:20:30 +1100<br>Subject: Re: [rt-users] Default Configuration RT<br>From: alex@peters.net<br>To: renatorodrigo_87@hotmail.com; rt-users@lists.bestpractical.com<br><br><div dir="ltr">Hi Renato,<div><br></div><div>What exactly did you try, and what happened? Going into MySQL, dropping the database (or all of its tables) and running the sbin/rt-setup-database script would restore all of your templates and scrips. Specifically, you would probably do this if your MySQL user has the permissions to drop the database:</div><div><br></div><div>$ cd <RT_ROOT_DIRECTORY></div><div>$ sbin/rt-setup-database --action drop,create,schema,acl,coredata,insert --dba <RT_DB_USERNAME> --prompt-for-dba-password</div><div><br></div><div>You can pass "--help" to the rt-setup-database script for further details. Remove "drop,create," from the above line if you'd like to manually remove all of the tables first (using mysql).</div><div><br></div><div>Please let us know how you go (using "Reply All").</div></div><div class="ecxgmail_extra"><br><div class="ecxgmail_quote">On 10 December 2014 at 23:02, Renato Gentil <span dir="ltr"><<a href="mailto:renatorodrigo_87@hotmail.com" target="_blank">renatorodrigo_87@hotmail.com</a>></span> wrote:<br><blockquote class="ecxgmail_quote" style="border-left:1px #ccc solid;padding-left:1ex;">
<div><div dir="ltr">Hi Alex,<div><br></div><div>I tried it but didn't work for me. Basically I'm trying to restore the default templates and scripts because I have deleted some of them and now some of our features have been gone with them.</div><div><br></div><div>Can you help me with that ?</div><div><br></div><div>thanks,</div><div><br><br><font style="font-size:10pt;" face="Comic Sans MS"><br></font><font style="font-size:10pt;" face="Comic Sans MS">Renato Gentil</font> <br><br><br><div><hr>From: <a href="mailto:alex@peters.net" target="_blank">alex@peters.net</a><br>Date: Wed, 10 Dec 2014 01:12:06 +0000<span><br>Subject: Re: [rt-users] Default Configuration RT<br></span>To: <a href="mailto:renatorodrigo_87@hotmail.com" target="_blank">renatorodrigo_87@hotmail.com</a>; <a href="mailto:rt-users@lists.bestpractical.com" target="_blank">rt-users@lists.bestpractical.com</a><span><br><br><p dir="ltr">You could drop the database and set it up again, or also completely uninstall and reinstall RT.</p></span></div></div> </div></div>
</blockquote></div><br></div></div></div> </div></body>
</html>