MYSQL

Login: List databases: Delete database: Make new database: List users: Make new user: Delete user: Gives all rights to user over a certain database (replace database.name with * for all databases): Refreshes privileges, a must after a change: Lists user rights: Exports (dumps) the database: Shows original (exported) database name: Imports dump of some database … Read moreMYSQL

Rsync

Copies files from a source to destination. Syncs directories without copying already existing files and updating modified files. Works over SSH. remote -> local: local -> local: local -> remote: Options/flags: -a equals to use of following options -rlptgoD (basically -a options makes rsync a fully fledged backup tool) –delete  deletes files from the destination … Read moreRsync

Screen

Screen tool is very useful if you need to disconnect from remote server, or you have a shaky connection that tends to drop but the started process on remote server needs to continue. You can reconnect later and any process started in screen session continues while you are disconnected. You are able to resume that … Read moreScreen

Tested on Ubuntu & Pop OS