Commands by skygreg

Commands by skygreg (7)

sorted by

MySQL dump restore with progress bar and ETA

Display a progress bar while restoring a MySQL dump. Show Sample Output
This is sample output - yours may be different.
```
 132MB 0:08:00 [ 260kB/s] [>                                 ]  1% ETA 12:48:0923                           
```
4

pv bigdump.sql.gz | gunzip | mysql

skygreg · 2010-06-11 14:26:13 0
Find and delete thunderbird's msf files to make your profile work quickly again.
This is sample output - yours may be different.
0

find ~/.thunderbird/*.default/ -name *.msf -delete

skygreg · 2010-06-08 13:34:16 0
Remove today's Debian installed packages

Adapted using your usefull comments !
This is sample output - yours may be different.
8

grep -e `date +%Y-%m-%d` /var/log/dpkg.log | awk '/install / {print $4}' | uniq | xargs apt-get -y remove

skygreg · 2010-01-12 09:42:22 0
Parallel mysql dump restore

this command works with one gziped file per table, and restore 4 tables in parallel. Show Sample Output
This is sample output - yours may be different.
```
see mytop output
```
3

find -print0 | xargs -0 -n 1 -P 4 -I {} sh -c "zcat '{}' | mysql nix"

skygreg · 2009-08-25 15:05:55 2
SSH monitor
This is sample output - yours may be different.
0

ssh [email protected] 'tail --max-unchanged-stats=10 -n0 -F /var/log/auth.log ' | grep Accepted | while read l ; do kdialog --title "SSH monitor" --passivepopup "$l" 3; done

skygreg · 2009-07-10 14:25:35 3
Remove today's installed packages
This is sample output - yours may be different.
4

grep "install " /var/log/dpkg.log | awk '{print $4}' | xargs apt-get -y remove --purge

skygreg · 2009-04-06 13:06:04 3
doing some floating point math
This is sample output - yours may be different.
2

echo "8000000/(20*6*86400)" | bc -l

skygreg · 2009-02-19 17:05:20 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

Display HTTP-header using curl

Kill google chrome process

Search for packages, ranked by popularity

This will take the packages matching a given `apt-cache search` query (a collection of AND'd words or regexps) and tell you how popular they are. This is particularly nice for those times you have to figure out which solution to use for e.g. a PDF reader or a VNC client. Substitute "ubuntu.com" for "debian.org" if you want this to use Ubuntu's data instead. Everything else will work perfectly.

RTFM function

Sometimes you don't have man pages only '-h' or '--help'.

Prepend a text to a file.

The original command is great, but I often want to prepend to every line.

Find and copy scattered mp3 files into one directory

This command copies all filenames in the current dir and subdirs that end in .mp3 regardless of case (also matches .MP3 .mP3 and .Mp3) It copies all the files to the "mp3" folder in your home directory. If you want to see the files that are beeing copied, replace "cp {}" with "cp -v {}"

Monitor RAID IO Usage

Shows the IO of the raid sync

print lib path of perl

Show the power of the home row on the Dvorak Keyboard layout

Quick and dirty command that counts how many words can be typed just using the home row on the Dvorak Simplified Keyboard layout from a dictionary file, in this case /usr/share/dict/words. According to the regular expression supplied, each word must contain all the keys on the Dvorak home row, and no other characters. For comparison, I've shown how many words are installed in my dictionary, how many can be typed with just the Dvorak home row and how many can be typed with just the QWERTY home row in the sample output. Nearly 10 times the amount. If you want to see the words, remove the -c switch, and each word will be printed out.

Delete the specified line

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)
» commands by skygreg