All commands (14,001)
-
You can get an approximate idea of how long your data export might take. Show Sample Output
0mysqldump --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 -aicfnF0find -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
0DEL /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
0ps -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; -
2bc -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.tar0pax -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
-
queries related to table 'Invoice_template' Show Sample Output
0grep -Eo '( *[^ ]* *){4}Invoice_Template( *[^ ]* *){4}' /mysql-bin-log/mysql-gen.log | head -10000 | sort -u -
( Or
ls -lat|lolcat -aif you like it in technicolor - apt install lolcat if needed )2ls -alt|awk '{if (system("sleep .5 && exit 2") != 2) exit; print}' -
Manage partial uploads using append option.
1rsync --archive --recursive --compress --partial --progress --append root@123.123.123.123:/backup/somefile.txt.bz2 /home/ubuntu/ -
Especially useful while syncing to Amazon EC2 instance. avz stands for archive verbose compress
0rsync -e 'ssh -i /root/my.pem' -avz /mysql/db/data_summary.* ec2-1-2-4-9.compute-1.amazonaws.com:/mysql/test/ -
opens a new session with video stream
2setsid mpv --input-ipc-server=/tmp/mpvsoc$(date +%s) -quiet "$1" >/dev/null 2>&1 - 1 2 3 > 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)
