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 root@server '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 2
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

Convert (almost) any video file into webm format for online html5 streaming

If you're using the experimental vorbis encoder (homebrew version of libffmpeg)

check open ports without netstat or lsof

Find the package that installed a command

To get the CPU temperature continuously on the desktop

No need for a colon, and one less semicolon too. Also untested.

Find usb device

I often use it to find recently added ou removed device, or using find in /dev, or anything similar. Just run the command, plug the device, and wait to see him and only him

check open ports without netstat or lsof

Another Matrix Style Implementation

Create a backup of the file.

It will create a backup of the filename. The advantage is that if you list the folder the backups will be sorted by date. The command works on any unix in bash.

Dump dvd from a different machine onto this one.

You can use this to directly dump from machine A (with dvd drive) to machine B (without dvd drive) . I used this to copy dvd using my friend's machine to my netbook. Above command is to be issued on machine B. Advantages : 1) No wasting time dumping first to machine A and then copying to Machine B. 2) You dont need to use space on Machine A. In fact, this will work even when Machine A doesnt have enough hdd space to dump the DVD. Use -C ssh option on slow networks (enables compression). you can replace "dd if=/dev/dvd" with any ripping command as long as it spews the iso to stdout.

Big (four-byte) $RANDOM

Sometimes, in a shell script, you need a random number bigger than the range of $RANDOM. This will print a random number made of four hex values extracted from /dev/urandom.

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