All commands (14,045)
-
Removes the annoying filehistory filename default of adding a really long UTC time and date string to every single file. Non recursive so you will have to run this per directory.
0Get-ChildItem -Recurse | Where-Object { $_.Name -match " ?\(\d\d\d\d_\d\d_\d\d \d\d_\d\d_\d\d UTC\)" } | Rename-Item -NewName { $_.Name -replace " ?\(\d\d\d\d_\d\d_\d\d \d\d_\d\d_\d\d UTC\)", ""} -
Useful for Roku which does not support 7.1. Useful resources: - https://trac.ffmpeg.org/wiki/Map - https://trac.ffmpeg.org/wiki/Encode/HighQualityAudio - https://superuser.com/questions/852400/properly-downmix-5-1-to-stereo-using-ffmpeg
0ffmpeg -i in.mkv -map 0 -c copy -c:a:0 aac -ac:a:0 6 out.mkv -
The “predictive capture” feature of Sony's Xperia camera app hides the date stamp deeply inside the filename. This command adds another date stamp at the beginning of the filename. Show Sample Output
0(setopt CSH_NULL_GLOB; cd /path/to/Camera\ Uploads; for i in DSCPDC_000*; do mv -v $i "$(echo $i | perl -lpe 's/(DSCPDC_[0-9]{4}_BURST)([0-9]{4})([0-9]{2})([0-9]{2})/$2-$3-$4 $1$2$3$4/')"; done) -
Sony's Xperia camera app creates files without time-stamped names. Thus, after deleting files on the phone, the same names will be reused. When uploading the photos to a cloud storage, this means that files will be overwritten. Running this command after every sync of uploaded photos with the computer prevents this. Show Sample Output
1(setopt CSH_NULL_GLOB; cd /path/to/Camera\ Uploads; for i in DSC_* MOV_*; do mv -v $i "$(date +%F -d @$(stat -c '%Y' $i)) $i"; done) -
List SAN Domains for a certificate Show Sample Output
0echo | openssl s_client -connect google.com:443 2>&1 | openssl x509 -noout -text | awk -F, -v OFS="\n" '/DNS:/{x=gsub(/ *DNS:/, ""); $1=$1; print $0}' -
You can get an approximate idea of how long your data export might take. Show Sample Output
-1mysqldump --login-path=mypath sbtest sbtest4 | pv --progress --size 200m -t -e -r -a > dump.sql -
Will delete empty directories and sub-directories (hideen too = whose names are starting with dot .). Used 'rm' command instead of 'rmdir' to give the possibility of asking for confirmation before deleting i.e. it is not wise do delete all empty directories in /etc folder. Replace dot in 'find .' with any for other starting directory instead of current. in 'rm -i -R' 'i' stands for ask before delete and 'R' for delete folder recursively or folder itself if it is empty
0find . -type d -empty -exec rm -i -R {} \; -
I can think of using this command after compiling an downloaded source from anywhere as an easy way to find all executable products. We usually issue the
findcommand (without arguments) to list the full paths of all directories and sub-directories and files in the entire current tree. Similar command istree -aicfnF1find -executable -type f -
Run inside Command Prompt (cmd.exe) as admin. Note that you must close explorer.exe first, and even so some files will not be deleted, will say "Access is denied." To definitely delete them enter with another admin user or from other operating system and access the drive. Show Sample Output
1DEL /F /S /Q /A %LocalAppData%\Microsoft\Windows\Explorer\thumbcache_*.db -
Sometimes we install programs, we forget about them, and they stay there wasting RAM. This one-liner try to find them. Show Sample Output
1ps -eo cmd | awk '{print $1}'| sort -u | grep "^/" | xargs dpkg -S 2>/dev/null | awk -F: '{print $1}' | sort -u | xargs apt-mark showmanual -
raw image created by canon digital camera. Install using apt-get install ufraw
0for i in *.CR2; do ufraw-batch $i --out-type=jpeg --output $i.jpg; done; -
3bc -l <<< "scale=1000; 4*a(1)"
-
tar(1) and cpio(1) are not fully platform agnostic, although their file formats are specified in POSIX.1-2001. As such, GNU tar(1) might not be able to extract a BSD tar(1) archive, and ivce versa. pax(1) is defined in POSIX.1-2001. To extract an archive:
pax -rf archive.tar2pax -wf archive.tar /path -
0& 'C:\cwRsync_5.5.0_x86_Free\bin\rsync.exe' --force --ignore-errors --no-perms --chmod=ugo=rwX --checksum --delete --backup --backup-dir="_EVAC/$(Get-Date -Format "yyyy-MM-dd-HH-mm-ss")" --whole-file -a -v "//MyServer/MyFolder" "/cygdrive/c/Backup"
-
0strace -c -p $(pidof -s mysqld) -f -e trace=all
-
cron entry to record mysql status every minute
0mysqladmin status >> /home/status.txt 2>> /home/status_err.txt -
username is dba and password is dba123
0grant all on *.* to 'dba'@'localhost' identified by 'dba123' with grant option; -
remove all compressed files in /home/ folder not created in the last 10 days
1find /home -type f \( -name "*.sql.gz" -o -name "*.tar.gz" -mtime +10 \) -exec rm -rf {} \; -
remove all files in /home/ folder that starts with bk_all_dbProdSlave and not created in the last 2 days
0find /home/ -name bk_all_dbProdSlave_\* -mtime +2 -exec rm -f {} \; -
0mysqladmin variables | egrep '(innodb_log_file|innodb_data_file)'
-
0mysqlbackup --port=3306 --protocol=tcp --user=dba --password=dba --with-timestamp --backup-dir=/tmp/toback/ --slave-info backup-and-apply-log --innodb_data_file_path=ibdata1:10M:autoextend --innodb_log_files_in_group=2 --innodb_log_file_size=5242880
-
pem file used by AWS servers for additional security
1ssh -L8888:localhost:80 -i nov15a.pem ubuntu@123.21.167.60 -
-1mysqlslap --query=/root/select_query_cp.sql --concurrency=10 --iterations=5 --create-schema=cvts1
-
2diff file1 file2 --side-by-side --suppress-common-lines
-
0awk '{if ($3 =="LAN" && $5 == "0.00" ) print $1, $2, "LAN", "288", "100.00"; else print $1 ,$2, $3, $4, $5 }' sla-avail-2013-Feb > sla-avail-2013-Feb_final
- < 1 2 3 4 5 > Last ›
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.
Check These Out
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)