Misc
Create dump of database
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 and uncompress files
Compress
$ tar cvzf dm01.tar.gz DM01/*
Uncompress
$ tar xvzf dm01.tar.gz
Forgotten root password to MySQL
Forgotten root password to MySQL
> UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';
> FLUSH PRIVILEGES;