All commands

All commands (13,991)

sorted by

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 1
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 0
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 0
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 2
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 1
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 0
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 ubuntu@123.21.167.60

shantanuo · 2020-02-19 10:20:18 0
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
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 1
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
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
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
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
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
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.
1

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

n0a110w · 2020-02-10 12:35:11 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 3
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 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
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
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
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
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
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
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
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
1 2 3 > 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

Join lines

awk version of 7210. Slightly longer, but expanding it to catch blank lines is easier: $ awk 'BEGIN{RS="\0"}{gsub(/\n+/,"");print}' file.txt

Create a mirror of a local folder, on a remote server

Create a exact mirror of the local folder "/root/files", on remote server 'remote_server' using SSH command (listening on port 22) (all files & folders on destination server/folder will be deleted)

read squid logs with human-readable timestamp

Make a zip file with date/time created in the name of the file , zip all sub-directorys

zip -r /tmp/filename-`date +%Y%m%d_%H%M%S`.zip /directory/

Find usb device in realtime

Using this command you can track a moment when usb device was attached.

Simple server which listens on a port and prints out received data

Sometimes you need a simple server which listens on a port and prints out received data. Example: Consider you want to know, which data is posted by a homepage to a remote script without analysing the html code! A simple way to do this is to save the page to your computer, substitude all action="address" with action="localhost:portnumber", run 'ncat -l portnumber' and open the edited page with your browser. If you then submit the form, ncat will print out the http-protocol with all the posted data.

Take aWebcam Picture When the Mouse Moves

This takes a webcam picture every everytime the mouse is moved (waits 10 seconds between checking for movement) and stores the picture wherever you want it. Ideas: Use in conjunction with a dropbox type application to see who is using your computer Use /dev/input/mice if /dev/input/mouse* doesn't work Use the bones of this to make a simple screensaver

create ICO file with more than one image

requires imagemagick. -background transparent is of course optional.

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"

Extract the emoticons regex from a running skype process

Skype has an internal regex which depicts the emoticons it supports. However you cannot simply search the binary file for it. This small 181 character line will do just that, provided skype is running. And of course, only works in linux.

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 (13,991) 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 (13,991)

sorted by