CLI – List of all MySQL command

List of all MySQL commands:
Note that all text commands must be first on line and end with ‘;’

?         (\?) Synonym for `help'.
clear     (\c) Clear the current input statement.
connect   (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter.
edit      (\e) Edit command with $EDITOR.
ego       (\G) Send command to mysql server, display result vertically.
exit      (\q) Exit mysql. Same as quit.
go        (\g) Send command to mysql server.
help      (\h) Display this help.
nopager   (\n) Disable pager, print to stdout.
notee     (\t) Don't write into outfile.
pager     (\P) Set PAGER [to_pager]. Print the query results via PAGER.
print     (\p) Print current command.
prompt    (\R) Change your mysql prompt.
quit      (\q) Quit mysql.
rehash    (\#) Rebuild completion hash.
source    (\.) Execute an SQL script file. Takes a file name as an argument.
status    (\s) Get status information from the server.
system    (\!) Execute a system shell command.
tee       (\T) Set outfile [to_outfile]. Append everything into given outfile.
use       (\u) Use another database. Takes database name as argument.
charset   (\C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets.
warnings  (\W) Show warnings after every statement.
nowarning (\w) Don't show warnings after every statement.
CLI – List of all MySQL command

CLI essential Linux commands

Find file name 
find / -type f -name RRDs.pm

Find folder name
find / -type d -name ‘folder name’

Find text
find /into/this/dir -name ‘*.php’ -print0 | xargs -r -0 grep -l texttofind

Sort file size in reverse order
ls -lSr

Show last rows of file
tail -f filename

Display active process
ps -w | grep spamd

info processor architecture
cat /proc/cpuinfo | grep model

Zip compress
zip -rv file.zip folder_to_zip
unzip -v filename.zip

To extract all members of letters.zip into the current directory only:
unzip -j letters

To test letters.zip, printing only a summary message indicating whether the archive is OK or not:
unzip -tq letters

To test all zipfiles in the current directory, printing only the summaries:
unzip -tq \*.zip

CLI essential Linux commands