All commands

All commands (14,187)

sorted by

check mysql capacity to handle traffic
This is sample output - yours may be different.
-2

mysqlslap --query=/root/select_query_cp.sql --concurrency=10 --iterations=5 --create-schema=cvts1

shantanuo · 2020-02-15 10:40:39 85
show the difference
This is sample output - yours may be different.
2

diff file1 file2 --side-by-side --suppress-common-lines

shantanuo · 2020-02-15 10:38:44 156
Change values from 0 to 100
This is sample output - yours may be different.
0

awk '{if ($3 =="LAN" && $5 == "0.00" ) print $1, $2, "LAN", "288", "100.00"; else print $1 ,$2, $3, $4, $5 }' sla-avail-2013-Feb > sla-avail-2013-Feb_final

shantanuo · 2020-02-15 10:37:44 76
Extract queries from mysql general log

queries related to table 'Invoice_template' Show Sample Output
This is sample output - yours may be different.
0

grep -Eo '( *[^ ]* *){4}Invoice_Template( *[^ ]* *){4}' /mysql-bin-log/mysql-gen.log | head -10000 | sort -u

shantanuo · 2020-02-14 08:18:58 125
Slow Down Command Output

( Or ls -lat|lolcat -a if you like it in technicolor - apt install lolcat if needed )
This is sample output - yours may be different.
2

ls -alt|awk '{if (system("sleep .5 && exit 2") != 2) exit; print}'

knoppix5 · 2020-02-13 02:59:48 166
rsync should continue even if connection lost

Manage partial uploads using append option.
This is sample output - yours may be different.
2

rsync --archive --recursive --compress --partial --progress --append root@123.123.123.123:/backup/somefile.txt.bz2 /home/ubuntu/

shantanuo · 2020-02-11 13:48:22 123
rsync using pem file

Especially useful while syncing to Amazon EC2 instance. avz stands for archive verbose compress
This is sample output - yours may be different.
0

rsync -e 'ssh -i /root/my.pem' -avz /mysql/db/data_summary.* ec2-1-2-4-9.compute-1.amazonaws.com:/mysql/test/

shantanuo · 2020-02-11 13:45:32 114
stream a youtube video with mpv where $1 is the youtube link.

opens a new session with video stream
This is sample output - yours may be different.
3

setsid mpv --input-ipc-server=/tmp/mpvsoc$(date +%s) -quiet "$1" >/dev/null 2>&1

n0a110w · 2020-02-10 12:35:11 87
check mysql server performance
This is sample output - yours may be different.
0

mysqlslap --query=/home/ec2-user/insert.txt --concurrency=123 --iterations=1 --create-schema=test

shantanuo · 2020-02-09 09:52:28 181
backup all data in compressed format

error out to a different file every day if it is part of a cron entry. The backup file will overwrite older version.
This is sample output - yours may be different.
0

mysqldump --routines --all-databases | gzip > /home/mydata.sql.gz 2> /home/mydata.date '+\%b\%d'.err

shantanuo · 2020-02-09 07:46:42 107
Check if the same table name exist across different databases

Useful command for MySQL Show Sample Output
This is sample output - yours may be different.
```
Count of databases for e.g. 3
```
0

find . -name "withdrownblocks.frm" | sort -u | awk -F'/' '{print $3}' | wc -l

shantanuo · 2020-02-09 07:22:42 86
Find a file and then copy to tmp folder

Select only the files with given name and copy them to /tmp/ folder.
This is sample output - yours may be different.
-1

for file in `ls | grep -i 'mumbai|pune|delhi'` ; do cp $file /tmp/ ; done

shantanuo · 2020-02-09 06:56:45 102
Find non-standard files in mysql data directory

These files should be removed to keep the size of data directory under control. If you exclude the known important file types like frm and MYD then what-ever is left can be either moved or deleted.
This is sample output - yours may be different.
1

find . -type f -not -name "*.frm" -not -name "*.MYI" -not -name "*.MYD" -not -name "*.TRG" -not -name "*.TRN" -not -name "db.opt"

shantanuo · 2020-02-09 06:45:50 77
Compare mysql db schema from two different servers
This is sample output - yours may be different.
0

diff <(mysqldump -hsystem db_name --no-data --routines) <(mysqldump -hsystem2 db_name --no-data --routines) --side-by-side --suppress-common-lines --width=690 | more

shantanuo · 2020-02-09 02:37:05 81
Dump top 10 ports tcp/udp from nmap

To be used with other port scanners and or for help with iptables --dport 1000:2000 style expansion Show Sample Output
This is sample output - yours may be different.
```
7,9,13,21-23,25-26,37,53,79-81,88,106,110-111,113,119,135,139,143-144,179,199,389,427,443-445,465,513-515,543-544,548,554,587,631,646,873,990,993,995,1025-1029,1110,1433,1720,1723,1755,1900,2000-2001,2049,2121,2717,3000,3128,3306,3389,3986,4899,5000,5009,5051,5060,5101,5190,5357,5432,5631,5666,5800,5900,6000-6001,6646,7070,8000,8008-8009,8080-8081,8443,8888,9100,9999-10000,32768,49152-49157
```
0

nmap -oA derp --top-ports 10 localhost>/dev/null;grep 'services\=' derp.xml | sed -r 's/.*services\=\"(.*)(\"\/>)/\1/g'

operat0r · 2020-02-06 12:59:24 94
list current processes writing to hard drive
This is sample output - yours may be different.
1

lsof | grep -e "[[:digit:]]\+w"

aysadk · 2020-01-27 23:10:38 174
Massive change of file extension (bash)

Using bash parameters expansion
This is sample output - yours may be different.
4

for file in *.txt; do mv "${file%.txt}{.txt,.xml}"; done

rgawenda · 2020-01-23 08:54:34 129
SFTP upload through HTTPS proxy

Overwrites remote file without asking! Uses HTTPS proxy that supports CONNECT. Actually uses SSH and not SFTP to upload the file.
This is sample output - yours may be different.
0

cat myFile.json | ssh root@remoteSftpServer -o "ProxyCommand=nc.openbsd -X connect -x proxyhost:proxyport %h %p" 'cat > myFile.json'

casueps · 2020-01-22 11:00:20 107
Boooted as EFI/UEFI or BIOS
This is sample output - yours may be different.
1

[[ -d "/sys/firmware/efi" ]] && echo "UEFI" || echo "BIOS"

wuseman1 · 2020-01-17 09:39:29 95
Print hugepage consumption of each process

The sample output is from an Android Device Show Sample Output
This is sample output - yours may be different.
```
/vendor/bin/hw/qcrild-c2 smaps:AnonHugePages:      2048 kB

/vendor/bin/imsdatadaemon smaps:AnonHugePages:      4096 kB

/vendor/bin/imsdatadaemon smaps:AnonHugePages:      2048 kB
```
0

grep -e AnonHugePages /proc/*/smaps | awk '{ if($2>4) print $0} ' | awk -F "/" '{system("cat /proc/" $3 "/cmdline");printf("\n");print $0; printf("\n");}'

praton · 2020-01-14 07:50:44 98
Print your cpu intel architecture family
This is sample output - yours may be different.
3

cat /sys/devices/cpu/caps/pmu_name

wuseman1 · 2020-01-01 04:57:27 101
Delete all local git branches that have been merged and deleted from remote
This is sample output - yours may be different.
-1

git branch -d $( git branch -vv | grep '\[[^:]\+: gone\]' | awk '{print $1}' | xargs )

gtron · 2019-12-22 15:48:54 92
Poor man's ntpdate
This is sample output - yours may be different.
4

date -s "$(curl -sD - www.example.com | grep '^Date:' | cut -d' ' -f3-6)Z"

casueps · 2019-12-20 10:10:14 134
Listen to a song from youtube with youtube-dl and mpv

Explanation Firstly the function checks if user gave it any input, and notifies the user if they failed to do so. If user has inputed a search string, the function will call upon youtube-dl to find url of the audio of the first matching youtube video and play that with mpv. Call function by wrapping search string in quotes: listen-to-yt "sultans of swing" You have to paste the line in your .zshrc and source .zshrc for it to work. Limitations The dependancies are youtube-dl and mpv. this oneliner is stolen from http://www.bashoneliners.com/oneliners/302/
This is sample output - yours may be different.
1

listen-to-yt() { if [[ -z "$1" ]]; then echo "Enter a search string!"; else mpv "$(youtube-dl --default-search 'ytsearch1:' \"$1\" --get-url | tail -1)"; fi }

emphazer · 2019-12-18 14:22:12 76
get all Google ipv4/6 subnets for a iptables firewall for example (updated version)

google has added 2 more netblocks... Show Sample Output
This is sample output - yours may be different.
```
108.177.8.0/21
108.177.96.0/19
130.211.0.0/22
172.217.0.0/19
172.217.128.0/19
172.217.160.0/20
172.217.192.0/19
172.217.32.0/20
172.253.112.0/20
172.253.56.0/21
173.194.0.0/16
2001:4860:4000::/36
209.85.128.0/17
216.239.32.0/19
216.58.192.0/19
2404:6800:4000::/36
2607:f8b0:4000::/36
2800:3f0:4000::/36
2a00:1450:4000::/36
2c0f:fb50:4000::/36
35.190.247.0/24
35.191.0.0/16
64.233.160.0/19
66.102.0.0/20
66.249.80.0/20
72.14.192.0/18
74.125.0.0/16
```
4

for NETBLOCK in $(echo _netblocks.google.com _netblocks2.google.com _netblocks3.google.com); do nslookup -q=TXT $NETBLOCK ; done | tr " " "\n" | grep ^ip[46]: | cut -d: -f2- | sort

emphazer · 2019-12-16 07:09:12 288
‹ First < 8 9 10 11 12 > Last ›

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again. That way others can gain from your CLI wisdom and you from theirs too. All commands can be commented on, discussed and voted up or down.

Share Your Commands

Check These Out

Find the package that installed a command

Check the status of a network interface

no need for installing mii-tools, all generic tools working under archlinux.

Convert seconds to [DD:][HH:]MM:SS

Converts any number of seconds into days, hours, minutes and seconds. sec2dhms() { declare -i SS="$1" D=$(( SS / 86400 )) H=$(( SS % 86400 / 3600 )) M=$(( SS % 3600 / 60 )) S=$(( SS % 60 )) [ "$D" -gt 0 ] && echo -n "${D}:" [ "$H" -gt 0 ] && printf "%02g:" "$H" printf "%02g:%02g\n" "$M" "$S" }

Stop Flash from tracking everything you do.

Brute force way to block all LSO cookies on a Linux system with the non-free Flash browser plugin. Works just fine for my needs. Enjoy.

Save the list of all available commands in your box to a file

When you press TAB twice in your prompt, bash tells you something like "Display all 4567 possibilities? (y or n)" But when you press "y" you only get the list in the terminal output and, if you want to save it to a file, you have to copy it by hand from the vterm screen. With this utility you save the list to a file or pipe it to another command at will You can use the file saved list to grep for a particular pattern, useful if you are searching for a command but you only remember a few letters

Convert seconds to [DD:][HH:]MM:SS

sort ugly text

Often, when sorting you want the sort to ignore extraneous characters. The b, d, and f tell sort to ignore leading blanks, use 'dictionary order' (ignore punctuation), and ignore (fold) case. Add a "u" if you only want one copy of duplicate lines. This is a great command to use within vim to sort lines of text, using !}sort -bdf

Which processes are listening on a specific port (e.g. port 80)

swap out "80" for your port of interest. Can use port number or named ports e.g. "http"

output length of longest line

If your wc does not have the -L option, you can use awk.

check open ports without netstat or lsof

Stay in the loop…

Follow the Tweets.

Every new command is wrapped in a tweet and posted to Twitter. Following the stream is a great way of staying abreast of the latest commands. For the more discerning, there are Twitter accounts for commands that get a minimum of 3 and 10 votes - that way only the great commands get tweeted.

» http://twitter.com/commandlinefu
» http://twitter.com/commandlinefu3
» http://twitter.com/commandlinefu10

Subscribe to the feeds.

Use your favourite RSS aggregator to stay in touch with the latest commands. There are feeds mirroring the 3 Twitter streams as well as for virtually every other subset (users, tags, functions,…):

Subscribe to the feed for:

» all commands
» commands with 3 up-votes (commandlinefu3)
» commands with 10 up-votes (commandlinefu10)

All commands (14,187) the last day the last week the last month all time sorted by date votes

What's this?

Check These Out

Stay in the loop…

All commands (14,187)

sorted by