[rt-users] restarting rt 1.0.7 after reboot

[Doug Weir]

On Tue, 1 May 2001, del wrote:

> what are the MySQL command to display the contents of a RT database...?
> 
> perhaps my RT database is corrupted although it does not appear so...
> 
> I have tried::
> mysql> show tables

Don't forget the ';' after each command (ie: not 'show tables' but
'show tables;'

(as root)

mysql -p rt

(enter root's mysql password when prompted)

show tables;  (in mysql)

select * from users; (will show all users created in RT etc...).

Hope thats enlightening.

weirD 

------------------------------------------------------------------------
Douglas Weir                      dweir at theochem.uwaterloo.ca
Chemical Physics Dept.            Earth-Science & Chemistry 330A
University Of Waterloo                (519) 888-4567 x6110 
------------------------------------------------------------------------
ANTI-SPAM Policy:  Only mail addressed "To:" dweir (this excludes all of
'undisclosed recipients'/Cc/Bcc/etc) and certain pre-authorised mailing
lists will survive the spam filtering process.