Misc

Create dump of database

$ mysqldump --password=xxx --add-drop-table --no-create-db --no-data --result-file=janus.sql jach_db janus__attribute janus__blockedEntity janus__entity janus__hasEntity janus__metadata janus__tokens janus__user janus__userData janus__subscription janus__message janus__disableConsent

Compress and uncompress files

Compress

$ tar cvzf dm01.tar.gz DM01/*

Uncompress

$ tar xvzf dm01.tar.gz

Forgotten root password to MySQL

> UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';

> FLUSH PRIVILEGES;