All commands

All commands (14,036)

sorted by

Calculate pi to an arbitrary number of decimal places
This is sample output - yours may be different.
3

bc -l <<< "scale=1000; 4*a(1)"

cryptology_codes · 2020-03-11 15:58:21 8
Create POSIX tar archive

tar(1) and cpio(1) are not fully platform agnostic, although their file formats are specified in POSIX.1-2001. As such, GNU tar(1) might not be able to extract a BSD tar(1) archive, and ivce versa. pax(1) is defined in POSIX.1-2001. To extract an archive: pax -rf archive.tar
This is sample output - yours may be different.
2

pax -wf archive.tar /path

atoponce · 2020-03-06 13:56:46 6
Backup with versioning
This is sample output - yours may be different.
0

& 'C:\cwRsync_5.5.0_x86_Free\bin\rsync.exe' --force --ignore-errors --no-perms --chmod=ugo=rwX --checksum --delete --backup --backup-dir="_EVAC/$(Get-Date -Format "yyyy-MM-dd-HH-mm-ss")" --whole-file -a -v "//MyServer/MyFolder" "/cygdrive/c/Backup"

pascalv · 2020-03-06 10:17:42 7
Linux system calls of MySQL process
This is sample output - yours may be different.
0

strace -c -p $(pidof -s mysqld) -f -e trace=all

shantanuo · 2020-02-27 03:35:17 34
mysql status

cron entry to record mysql status every minute
This is sample output - yours may be different.
0

mysqladmin status >> /home/status.txt 2>> /home/status_err.txt

shantanuo · 2020-02-19 10:58:27 14
add a mysql user

username is dba and password is dba123
This is sample output - yours may be different.
0

grant all on *.* to 'dba'@'localhost' identified by 'dba123' with grant option;

shantanuo · 2020-02-19 10:56:07 8
find and remove old compressed backup files

remove all compressed files in /home/ folder not created in the last 10 days
This is sample output - yours may be different.
1

find /home -type f $ -name "*.sql.gz" -o -name "*.tar.gz" -mtime +10 $ -exec rm -rf {} \;

shantanuo · 2020-02-19 10:49:28 12
find and remove old backup files

remove all files in /home/ folder that starts with bk_all_dbProdSlave and not created in the last 2 days
This is sample output - yours may be different.
0

find /home/ -name bk_all_dbProdSlave_\* -mtime +2 -exec rm -f {} \;

shantanuo · 2020-02-19 10:47:34 7
InnoDB related parameters
This is sample output - yours may be different.
0

mysqladmin variables | egrep '(innodb_log_file|innodb_data_file)'

shantanuo · 2020-02-19 10:24:52 8
mysql backup utility
This is sample output - yours may be different.
0

mysqlbackup --port=3306 --protocol=tcp --user=dba --password=dba --with-timestamp --backup-dir=/tmp/toback/ --slave-info backup-and-apply-log --innodb_data_file_path=ibdata1:10M:autoextend --innodb_log_files_in_group=2 --innodb_log_file_size=5242880

shantanuo · 2020-02-19 10:24:15 6
port forwarding

pem file used by AWS servers for additional security
This is sample output - yours may be different.
1

ssh -L8888:localhost:80 -i nov15a.pem [email protected]

shantanuo · 2020-02-19 10:20:18 7
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 6
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 28
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 5
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 3
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 3
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 [email protected]:/backup/somefile.txt.bz2 /home/ubuntu/

shantanuo · 2020-02-11 13:48:22 2
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 3
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 3
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 33
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 4
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 5
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 7
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 3
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 4
< 1 2 3 4 5 > 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 external links in all html files in a directory list

Just a handy way to get all the unique links from inside all the html files inside a directory. Can be handy on scripts etc.

Prints total line count contribution per user for an SVN repository

I'm working in a group project currently and annoyed at the lack of output by my teammates. Wanting hard metrics of how awesome I am and how awesome they aren't, I wrote this command up. It will print a full repository listing of all files, remove the directories which confuse blame, run svn blame on each individual file, and tally the resulting line counts. It seems quite slow, depending on your repository location, because blame must hit the server for each individual file. You can remove the -R on the first part to print out the tallies for just the current directory.

See entire packet payload using tcpdump.

This command will show you the entire payload of a packet. The final "s" increases the snaplength, grabbing the whole packet.

Count opening and closing braces in a string.

This function counts the opening and closing braces in a string. This is useful if you have eg long boolean expressions with many braces and you simply want to check if you didn't forget to close one.

Copy files based on extension with recursive and keeping directory structure

Copy file theo phần mở rộng c? đệ quy v? giữ nguy?n cấu tr?c thư mục Replace "jar" by extension which you need.

Delete all aliases for a network interface on a (Free)BSD system

The example command deletes all aliases for network interface 'em0' assuming that the aliases have netmask of 255.255.255.255 and the master IP has some other netmask (such as 255.255.255.0). See here -> http://my.galagzee.com/2009/07/22/deleting-all-network-interface-aliases/ for more on the rationale of this command.

Installing debian on fedora (chrooted)

tcpdump sniff pop3,imap,smtp and http

sudo for launching gui apps in background

Need package: gksu Note: Launching gui app in background that needs sudo, won't work great with our old friendly style of launching: $ sudo gedit /etc/passwd & because this would put sudo in background ! Using gksudo as demonstrated, would popup a gui sudo window. May be this is a common knowledge, but not knowing this frustrated me during my newbie year.

ls -qaltr # list directory in chronological order, most recent files at end of list

I find it very handy to be able to quickly see the most recently modified/created files in a directory. Note that the "q" option will reveal any files with non-printable characters in their filename.

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,036) 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,036)

sorted by