[rt-users] Default Configuration RT

[Alex Peters]

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:

http://www.wikihow.com/Delete-a-MySQL-Database

On 10 December 2014 at 23:36, Renato Gentil <renatorodrigo_87 at hotmail.com>
wrote:

> Alex,
>
> I'm trying to drop but I'm getting the error attached.
> I'm using the following command:
>
> mysqladmin -u root -p XXXX drop
>
> but then I got the error attached and I also tried:
>
> mysqladmin -u root -p drop
> password: XXXX
>
> another error attached.
>
> Thanks,
>
>
> Renato Gentil
>
>
> ------------------------------
> Date: Wed, 10 Dec 2014 23:20:30 +1100
> Subject: Re: [rt-users] Default Configuration RT
> From: alex at peters.net
> To: renatorodrigo_87 at hotmail.com; rt-users at lists.bestpractical.com
>
>
> Hi Renato,
>
> 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:
>
> $ cd <RT_ROOT_DIRECTORY>
> $ sbin/rt-setup-database --action drop,create,schema,acl,coredata,insert
> --dba <RT_DB_USERNAME> --prompt-for-dba-password
>
> 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).
>
> Please let us know how you go (using "Reply All").
>
> On 10 December 2014 at 23:02, Renato Gentil <renatorodrigo_87 at hotmail.com>
> wrote:
>
> Hi Alex,
>
> 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.
>
> Can you help me with that ?
>
> thanks,
>
>
>
> Renato Gentil
>
>
> ------------------------------
> From: alex at peters.net
> Date: Wed, 10 Dec 2014 01:12:06 +0000
> Subject: Re: [rt-users] Default Configuration RT
> To: renatorodrigo_87 at hotmail.com; rt-users at lists.bestpractical.com
>
> You could drop the database and set it up again, or also completely
> uninstall and reinstall RT.
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20141211/57992996/attachment.htm>