one-liner - openterprise.it

Running SQL query on database inside Docker container running on remote host

Published on 2020-04-15 Author admin

Single line command to run SQL query on database inside Docker container running on remote host: ssh root@tinkerboard -C 'docker exec -i nextcloud-mariadb mysql -u nextcloud -p -e "SELECT * FROM oc_bruteforce_attempts;" nextcloud'

Linux - get external IP address

Published on 2017-11-16 Author admin

Linux - get external IP address: curl ifconfig.co

[Linux] RDP remote desktop connection to Windows server with file transfer enabled

Published on 2017-09-15 Author admin

[Linux] RDP remote desktop connection to Windows server with file transfer enabled: rdesktop -g 1366x700 -r disk:mydisk=/home/$user/$dir/ $IP_ADDRESS

Bulk image resize using ImageMagick

Published on 2017-08-29 Author admin

Bulk image resize using ImageMagick. Install ImageMagick: sudo yum install ImageMagick Change all *.jpg files resolution within 50%: for i in $( ls *.jpg); do convert -resize 50% $i re_$i; done

[one-liner] Remove files older than

Published on 2017-03-29 Author admin

find /path/*.gz -mtime +30 -exec rm {} \;