One line script to backup database./usr/bin/my

One line script to backup database.

/usr/bin/mysqldump databaseName --single-transaction=TRUE --result-file=/media/mint/9cb180f1-02d1-4fdd-8bb5-2e7728497288/backup/db-`date +%Y-%m-%d`.sql --user=databaseUser --host=myhost.com --port=3306 --password=databasePassword

Created 5y | May 27, 2020, 2:04:53 PM


Login to add comment

Other posts in this group

Download youtube video and extract audio into mp3
./yt-dlp_linux $URL -x --audio-format mp3
Mar 4, 2023, 7:01:10 PM | Quick commands
Quick convert from hex to dec

echo $((16#FF))

16 - numerical system FF - number in specified numerical system

Nov 19, 2022, 1:38:47 PM | Quick commands
Last 10 files based on last changes

find -ctime -2 -name "*.php" -not -path "./vendor/*" -not -path "./var/*" -not -path "./migrations/*" -printf "%T@ %Tc %p\n" | head -10

Nov 19, 2022, 1:31:26 PM | Quick commands
Windows - how to run program with input from file on command line

cmd.exe /c ".\main.exe < .\text.txt"

Nov 1, 2020, 8:57:35 PM | Quick commands
Faster way to delete large number of files on linux

rsync -a --delete empty/ x

Aug 20, 2020, 2:30:21 PM | Quick commands
Start chrome with insecure (self signed) certificates

chrome.exe --ignore-certificate-errors --unsafely-treat-insecure-origin-as-secure=https://www.devdomain.com/

Aug 17, 2020, 8:24:33 AM | Quick commands
Sort folders by their sizes

du -sBM * | sort -n

Jul 20, 2020, 6:23:43 PM | Quick commands