Commands by shadyvb

Commands by shadyvb (3)

sorted by

Export MySQL tables that begin with a string
This is sample output - yours may be different.
1

sudo mysql -sNe 'show tables like "PREFIX_%"' DBNAME | xargs sudo mysqldump DBNAME > /tmp/dump.sql

shadyvb · 2015-05-05 23:40:15 17
Cherry-pick range of commits, starting from the tip of 'master', into 'preview' branch

Creating feature-branches off master, and trying to merge them in an integration branch (preview), sometimes causes conflicts because the feature-branch might hold changes from 'master' that aren't on preview yet. So this ensures only the commits added to the feature-branch are moved to integration (preview). Note: This assumes you're currently on the feature-branch. Adjust 'master/preview' branch names to suit your environment.
This is sample output - yours may be different.
-2

git rev-list --reverse --topo-order master... | while read rev; do git checkout preview; git cherry-pick $rev || break; done

shadyvb · 2015-04-23 14:28:06 11
git discard unstaged changes
This is sample output - yours may be different.
0

git stash save --keep-index

shadyvb · 2014-09-03 09:07:35 8

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 CSV to JSON

Replace 'csv_file.csv' with your filename.

Synchronize both your system clock and hardware clock and calculate/adjust time drift

Do not run this command if you already have ntpd running! This needs to run as root, for example with sudo: $ sudo ntpdate pool.ntp.org && sudo hwclock --systohc && sudo hwclock --adjust This command will fetch accurate time from NTP servers and synchronize your system clock, then it will use the system clock to synchronize your hardware clock, and will calculate the time drift.

sort lines by length

Exit mc with 2 keystrokes

For those who like to hit instead of typing "exit" to leave the shell and find it annoying that it doesn't work in Midnight Commander, just press to switch to the subshell and now you can leave with

list block devices

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

Batch convert PNG to JPEG

Convert all PNG images in directory to JPEG using ImageMagick, and delete the old PNG images.

dd with progress bar and statistics to gzipped image

Install pip with Proxy

Installs pip packages defining a proxy

Use mtr to create a text file report

The report mode of mtr produces a text formated result of the mtr run using the number of ping cycles stated by the command. This text file could then be attached to an email with ease. I use this also without the ">" portion when writing email from within mutt using VI from the command mode with ":r !mtr --report --report-cycles 10 www.google.com" to actually input the same output in the body of an email.

Benchmark SQL Query

Benchmark a SQL query against MySQL Server. The example runs the query 10 times, and you get the average runtime in the output. To ensure that the query does not get cached, use `RESET QUERY CACHE;` on top in the query file.

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 shadyvb