All commands from the last month sorted by votes

All commands (18)

sorted by

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 0
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 2
rsync should continue even if connection lost

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

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 0
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.
1

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

knoppix5 · 2020-02-13 02:59:48 1
show the difference
This is sample output - yours may be different.
1

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

shantanuo · 2020-02-15 10:38:44 0
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 3
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 1
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 0
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.
0

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 0
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 0
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 0
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 2
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.
0

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

n0a110w · 2020-02-10 12:35:11 0
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 0
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 0
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 0
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 6
check mysql capacity to handle traffic
This is sample output - yours may be different.
-1

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

shantanuo · 2020-02-15 10:40:39 0

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

Network Discover in a one liner

climagic's New Year's Countdown clock

This is the 140 character long new year's countdown timer that was posted to the climagic account on twitter and identi.ca. There are saner ways of doing this of course, but probably none of those would fit. Uses the figlet command, but of course you can replace figlet with just echo if you want.

list block devices

Shows all block devices in a tree with descruptions of what they are.

put all lines in comment where de word DEBUG is found

Find the package that installed a command

convert pdf into multiple png files

syntax for resolution is: (see "man gs" for further informations) -rnumber -rnumber1xnumber2

Two command output

Summarize established connections after netstat output. Using tee and /dev/stderr you can send one command output to terminal before executing wc so you can summarize at the bottom of the output.

Show whats going on restoring files from a spectrum protect backup

spectrum protect's dsmc command shows file names and total amount of restore. This command shows which files are actually open and their siz in GB and highlights the change to the previous output

Execute a command on multiple hosts in parallel

Ssh to host1, host2, and host3, executing on each host and saving the output in {host}.log. I don't have the 'parallel' command installed, otherwise it sounds interesting and less cryptic.

Show one line summaries of all DEB packages installed on Ubuntu based on pattern search

I sometimes want to know what packages are installed on my Ubuntu system. I still haven't figured out how to use aptitude effectively, so this is the next best thing. This allows finding by name. The grep '^ii' limits the display to only installed packages. If this is not specified, then it includes listing of non-installed packages as well.

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 (18) 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 (18)

sorted by