Braindump:
SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB"?FROM information_schema.TABLES GROUP BY table_schema ;
Tag: braindump
How to delete Redmine users
I’ve recently transfered all my project planning, development, bug ticketing and repositories to the awesome Redmine project tracking software. From now on all of my development work will live on tracking.42dev.eu
To facilitate bug reports and feature planning for my latest WordPress Plugin I’ve activated user registrations in Redmine, so people can post messages on the Forums. Now I wanted to have some sort of mechanism to delete unwanted users from the Redmine database. Since the software has no such option on the webinterface I searched for an alternative and found one on the Redmine forums.
Go to you Redmine install directory and enter the following (substitute USER_ID with the desired value):
>> script/console >> u = User.find(USER_ID) >> u.destroy
Make sure, that the user you are deleting doesn’t have any activity on the site yet, otherwise problems could arise, if the user already posted messages etc.