Category Archives: Databases

Check for MySQL databases without existing DirectAdmin users

# Check MySQL databases without existing DA users. # Be careful, check twice before removing a DB. for dbuser in ` \ find /var/lib/mysql \ -mindepth 1 \ -maxdepth 1 \ -type d \ -exec basename ‘{}’ \; \ | cut -d’_’ -f1 \ | sort -u \ | grep -vE “^(da|lost\+found|mysql|performance)\$”`; \ do \ Read the full article…

Migrating Roundcube from MySQL to PostgreSQL

If You think there’s an easy and fully automated way of migrating a Roundcube installation running for years on MySQL – to a PostgreSQL database – forget it. You will probably have to take a few steps before automation could be applied to this process. In this post I’m trying to describe all steps of Read the full article…