<div dir="ltr">That's the correct utility for dropping a MySQL database, but not the correct command line arguments. A quick Google search for "mysql drop database" should help you achieve this:<div><br></div><div><a href="http://www.wikihow.com/Delete-a-MySQL-Database">http://www.wikihow.com/Delete-a-MySQL-Database</a><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On 10 December 2014 at 23:36, Renato Gentil <span dir="ltr"><<a href="mailto:renatorodrigo_87@hotmail.com" target="_blank">renatorodrigo_87@hotmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><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"><br></font><font style="font-size:10pt" face="Comic Sans MS">Renato Gentil</font> <br><br><br><div><hr>Date: Wed, 10 Dec 2014 23:20:30 +1100<span class=""><br>Subject: Re: [rt-users] Default Configuration RT<br></span>From: <a href="mailto:alex@peters.net" target="_blank">alex@peters.net</a><br>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><div><div class="h5"><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><br><div>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 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></div> </div></div>
</blockquote></div><br></div>