Commands by ShlomiNoach

Commands by ShlomiNoach (6)

sorted by

MySQL: normalize parameter names on my.cnf configuration file

Multi-word parameters in my.cnf can be written with either hyphens or underscores. innodb_file_per_table is the same as innodb-file-per-table, as well as innodb_file-per_table. The script normalizes the parameter names to using underscores only, keeping from changing values (e.g. ?mysql-bin? parameter value should not change).
This is sample output - yours may be different.
0

cat my.sandbox.cnf | awk -F "=" 'NF < 2 {print} sub("=", "=~placeholder~=") {print}' | awk -F "=~placeholder~=" 'NF < 2 {gsub("-", "_", $0); print} NF==2 {gsub("-", "_", $1); print $1 "=" $2}'

ShlomiNoach · 2011-07-06 09:35:55 4
MySQL: Strip a my.cnf file from comments, remove blank lines, normalize spaces:

"normalize" a my.cnf file.
This is sample output - yours may be different.
0

cat my.cnf | sed '/^#/d' | sed '/^$/d' | sed -e 's/[ \t]\+//g'

ShlomiNoach · 2011-07-06 09:34:27 43
MySQL: Slice out a specific table from a specific database (assumes existence of the USE statement) from output of mysqldump

Only filter the statements to create and deploy a specifc table from a specific database (`departments`.`employees` in the example)
This is sample output - yours may be different.
0

mysqldump | sed -n "/^USE \`employees\`/,/^USE \`/p" | sed -n "/^-- Table structure for table \`departments\`/,/^-- Table structure for table/p"

ShlomiNoach · 2011-07-06 09:27:46 4
MySQL: Slice out a specific table from the output of mysqldump

Only filters the statement related to a specific table ('departments', in the example), from the output of mysqldump
This is sample output - yours may be different.
1

sed -n "/^-- Table structure for table \`departments\`/,/^-- Table structure for table/p"

ShlomiNoach · 2011-07-06 09:24:42 4
MySQL: Slice out a specific database (assumes existence of the USE statement) from mysqldump output

The 'USE' statement only appears in mysqldump's output if multiple databases are exported, or --databases is specified. This command filters only those statements relating to a specific database ('employees' in the example).
This is sample output - yours may be different.
0

sed -n "/^USE \`employees\`/,/^USE \`/p"

ShlomiNoach · 2011-07-06 09:22:55 4
mysql: Convert MyISAM tables to InnoDB via mysqldump

Textually convert the storage engine of MyISAM tables to InnoDB. This solution requires dumping of the database, transforming, and importing onto another server.
This is sample output - yours may be different.
0

mysqldump | sed -e 's/^) ENGINE=MyISAM/) ENGINE=InnoDB/'

ShlomiNoach · 2011-07-06 09:19:36 4

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

Sets shell timeout

Useful in root's .profile - will auto-logout after TMOUT seconds of inactivity. Close after `seconds` inactive. export TMOUT=seconds (unefunge)

Reduce PDF size

Decrypt exported android wallet keys for import into desktop client (LTC,FTC,BTC)

Connect-back shell using Bash built-ins

Connect-back shell using Bash built-ins. Useful in a web app penetration test, if it's the case of a locked down environment, without the need for file uploads or a writable directory. -- /dev/tcp and /dev/udb redirects must be enabled at compile time in Bash. Most Linux distros enable this feature by default but at least Debian is known to disable it. -- http://labs.neohapsis.com/2008/04/17/connect-back-shell-literally/

list files recursively by size

Watch movies in your terminal

requires mplayer

Check if you work on a virtual/physical machine in Linux

Command used to know if we are working on a virtual or physical machine. This command will use the dmidecode utility to retrieve hardware information of your computer via the BIOS. Run this command as root or with sudo.

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"

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"

monitor my process group tree

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 shlominoach