Cleanup Redmine users

1 min read

Startup MySQL tool

    # mysql -u root -p redmine

Maybe first use below queries with SELECT to see what matches there are,
before running with DELETE.
These will show records with state register from 7 days or older.

    DELETE FROM tokens WHERE action='register' and created_on < now() - INTERVAL 7 DAY;

    DELETE FROM users WHERE status=2 and created_on < now() - INTERVAL 7 DAY;

    DELETE FROM tokens WHERE action='register';
    DELETE FROM users WHERE status=2;

Previous article

Change Color Gamma on Ubuntu

Install xgamma-gui: $ git clone $ cd xgamma-gui Add to Makefile: CONFIG += qt QT += gui $ qmake && make && make install $ ./XgammaGui

Next article

Cubieboard 2

My Cubieboard2 server is running fine for Months now!

Related Articles

Migrate a Redmine site to another server

On current server: # service apache2 stop # cd /opt/redmine/files # scp -r * root@:/opt/redmine/files Make MySQL backup # mysqldump

1 min read