pugsley · March 19, 2025 12:06 · May 16, 2016 · May 9, 2016 · May 9, 2016 · May 9, 2016
diff --git a/mysql-backup.md b/mysql-backup.md
@@ -36,7 +36,7 @@ gzip -d [filename].sql.gz
 
 ## Clean up backups
 ```
-ls -tp [dir] | grep -v '/$' | tail -n +8 | xargs -I {} rm -- {}
+cd [dir] && ls -tp | grep -v '/$' | tail -n +8 | xargs -I {} rm -- {}
 ```
 Keep the latest 7 files in `[dir]`.
 

diff --git a/mysql-backup.md b/mysql-backup.md
@@ -44,6 +44,6 @@ Keep the latest 7 files in `[dir]`.
 
 
 
-References:
+References:  
 https://www.everythingcli.org/secure-mysqldump-script-with-encryption-and-compression/
 http://stackoverflow.com/questions/25785/delete-all-but-the-most-recent-x-files-in-bash
diff --git a/mysql-backup.md b/mysql-backup.md
@@ -46,4 +46,4 @@ Keep the latest 7 files in `[dir]`.
 
 References:
 https://www.everythingcli.org/secure-mysqldump-script-with-encryption-and-compression/
-
+http://stackoverflow.com/questions/25785/delete-all-but-the-most-recent-x-files-in-bash
diff --git a/mysql-backup.md b/mysql-backup.md
@@ -34,6 +34,13 @@ gzip -d [filename].sql.gz
 ```
 
 
+## Clean up backups
+```
+ls -tp [dir] | grep -v '/$' | tail -n +8 | xargs -I {} rm -- {}
+```
+Keep the latest 7 files in `[dir]`.
+
+
 
 
 

diff --git a/mysql-backup.md b/mysql-backup.md
@@ -2,7 +2,6 @@ Generate openssl keys:
 ```
 openssl req -x509 -nodes -newkey rsa:2048 -keyout mysqldump-key.priv.pem -out mysqldump-key.pub.pem
 ```
-Enter whatever at the prompts.
 
 Create a mysql default file:
 ```

diff --git a/mysql-backup.md b/mysql-backup.md
@@ -18,7 +18,7 @@ Bash script:
 #!/bin/bash
 
 DATE=`date +%Y-%m-%d-%H-%M-%S`
-ARCHIVE=${DATE}.sql.enc.gz
+ARCHIVE=${DATE}.sql.gz.enc
 MYSQLINFO=~/.mysqldump
 DATABASE=databasename
 PUBLIC_KEY=~/.mysqldump-key.pub.pem
@@ -28,6 +28,15 @@ mysqldump --defaults-extra-file=${MYSQLINFO} ${DATABASE} --single-transaction --
   | openssl smime -encrypt -binary -text -aes256 -out ${ARCHIVE} -outform DER ${PUBLIC_KEY}
 ```
 
+Decrypt & decompress
+```
+openssl smime -decrypt -in [filename].sql.gz.enc -binary -inform DEM -inkey mysqldump-secure.priv.pem -out [filename].sql.gz
+gzip -d [filename].sql.gz
+```
+
+
+
+
 
 References:
 https://www.everythingcli.org/secure-mysqldump-script-with-encryption-and-compression/

diff --git a/mysql-backup.md b/mysql-backup.md
@@ -23,9 +23,6 @@ MYSQLINFO=~/.mysqldump
 DATABASE=databasename
 PUBLIC_KEY=~/.mysqldump-key.pub.pem
 
-echo ${DATE}
-echo ${ARCHIVE}
-
 mysqldump --defaults-extra-file=${MYSQLINFO} ${DATABASE} --single-transaction --routines --events --triggers \
   | gzip -c \
   | openssl smime -encrypt -binary -text -aes256 -out ${ARCHIVE} -outform DER ${PUBLIC_KEY}

diff --git a/mysql-backup.md b/mysql-backup.md
@@ -0,0 +1,37 @@
+Generate openssl keys:
+```
+openssl req -x509 -nodes -newkey rsa:2048 -keyout mysqldump-key.priv.pem -out mysqldump-key.pub.pem
+```
+Enter whatever at the prompts.
+
+Create a mysql default file:
+```
+# ~/.mysqldump
+[mysqldump]
+host = host.here.com
+user = user
+password = "password"
+```
+
+Bash script:
+```
+#!/bin/bash
+
+DATE=`date +%Y-%m-%d-%H-%M-%S`
+ARCHIVE=${DATE}.sql.enc.gz
+MYSQLINFO=~/.mysqldump
+DATABASE=databasename
+PUBLIC_KEY=~/.mysqldump-key.pub.pem
+
+echo ${DATE}
+echo ${ARCHIVE}
+
+mysqldump --defaults-extra-file=${MYSQLINFO} ${DATABASE} --single-transaction --routines --events --triggers \
+  | gzip -c \
+  | openssl smime -encrypt -binary -text -aes256 -out ${ARCHIVE} -outform DER ${PUBLIC_KEY}
+```
+
+
+References:
+https://www.everythingcli.org/secure-mysqldump-script-with-encryption-and-compression/
+
No results found