Commands by Weboide

Commands by Weboide (3)

sorted by

command line to optimize all table from a mysql database

-o : optimize -p : asks for password -u : user to use for authentication Show Sample Output
This is sample output - yours may be different.
```
mysql.help_keyword                      OK
mysql.help_relation                     OK
mysql.help_topic                        OK
mysql.host                              Table is already up to date
```
0

mysqlcheck -op -u<user> <db>

Weboide · 2010-10-06 00:25:49 4
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. Show Sample Output
This is sample output - yours may be different.
```
4 Jun 09:21:19 ntpdate[10819]: step time server 67.220.194.133 offset 0.613237 sec
```
5

ntpdate pool.ntp.org && hwclock --systohc && hwclock --adjust

Weboide · 2009-06-04 13:35:14 7
Go (cd) directly into a new temp folder

This command create a new temp directory using mktemp (to avoid collisions) and change the current working directory to the created directory. Show Sample Output
This is sample output - yours may be different.
```
/tmp$ cd "$(mktemp -d)"
/tmp/tmp.gZIwreyWQp$
```
8

cd "$(mktemp -d)"

Weboide · 2009-05-20 11:48:12 12

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

List files older than one year, exluding those in the .snapshot directory

Useful when you want to cron a daily deletion task in order to keep files not older than one year. The command excludes .snapshot directory to prevent backup deletion. One can append -delete to this command to delete the files : $ find /path/to/directory -not $ -name .snapshot -prune $ -type f -mtime +365 -delete

List the size (in human readable form) of all sub folders from the current location

Sorted in human readable format.

For finding out if something is listening on a port and if so what the daemon is.

See what's listening on your IPv4 ports on FreeBSD.

SVN Status log to CSV

Note you have also the --xml option ;)

Clear all Windows Event Log entries (cygwin)

Efficiently clear all Windows Event log entries from within a Cygwin terminal. Uses "cygstart" to launch a hidden "PowerShell" session passing a Powershell command to loop through and clear all Windows Event Log entries. Very useful for troubleshooting and debugging. The command should in theory elevate you session if needed. One liner is based on the PowerShell command: $ wevtutil el | foreach { wevtutil cl $_ }

Mortality Countdown

watch the seconds of your life tick away - replace YYYY-mm-dd HH:MM:ss w/ your birthtime.

Copy uncommitted changes from remote git repository

Copy changed files from remote git repository, _including binary ones_, staged and unstaged alike. Note that this command doesn't handle deleted files properly.

cd into another dir to run a one-liner, but implicitly drop back to your $OLD_PWD after

Obviously the example given is necessarily simple, but this command not only saves time on the command line (saves you using "cd -" or, worse, having to type a fully qualified path if your command cd's more than once), but is vital in scripts, where I've found the behaviour of "cd -" to be a little broken at times.

the executable that started the currently running oracle databases and the ORACLE_HOME relative to each

get a list of currently running oracle dbs (identified by the pmon process) show the executable that spawned the process and show the ORACLE_HOME relative to the environment within which the process is running tailored to AIX (sed on linux behaves...differently) suggestions for a better way...please.

Find all dot files and directories

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 weboide