Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | Next revisionBoth sides next revision |
| servers:nginx:wordpress [2021/06/14 11:42] – Fedora Sean Rhone | servers:nginx:wordpress [2021/06/14 12:00] – [Database] Sean Rhone |
|---|
| |
| === Service === | === Service === |
| | |
| | * :!: On 2021/06/04, ''mysqldump'' required ''--column-statistics=0'' ([[https://serverfault.com/questions/912162/mysqldump-throws-unknown-table-column-statistics-in-information-schema-1109|suggested here]]) to workaround an error |
| | * :!: Unsure why only WordPress's database needed this |
| |
| mkdir -p ~/'backups' && sudo -u 'mysql' mkdir -p '/var/lib/mysql/tmp' && sudo -e '/etc/systemd/system/blog-db.service' && sudo sed -i 's/'CHANGEME'/'$USER'/g' '/etc/systemd/system/blog-db.service' | mkdir -p ~/'backups' && sudo -u 'mysql' mkdir -p '/var/lib/mysql/tmp' && sudo -e '/etc/systemd/system/blog-db.service' && sudo sed -i 's/'CHANGEME'/'$USER'/g' '/etc/systemd/system/blog-db.service' |
| Type=oneshot | Type=oneshot |
| WorkingDirectory=/var/lib/mysql/tmp | WorkingDirectory=/var/lib/mysql/tmp |
| ExecStartPre='/usr/bin/mysqldump' --defaults-extra-file='/var/lib/mysql/auth/wordpress' --single-transaction 'wordpress' -r '/var/lib/mysql/tmp/wordpress.sql' | ExecStartPre='/usr/bin/mysqldump' --defaults-extra-file='/var/lib/mysql/auth/wordpress' --single-transaction --column-statistics='0' 'wordpress' -r '/var/lib/mysql/tmp/wordpress.sql' |
| ExecStart='/usr/bin/gzip' -f '/var/lib/mysql/tmp/wordpress.sql' | ExecStart='/usr/bin/gzip' -f '/var/lib/mysql/tmp/wordpress.sql' |
| ExecStart='/usr/bin/bash' -c '"/usr/bin/mv" "/var/lib/mysql/tmp/wordpress.sql.gz" "/home/CHANGEME/backups/wordpress-database-auto-"$$(date +%%Y-%%m-%%d)".sql.gz"' | ExecStart='/usr/bin/bash' -c '"/usr/bin/mv" "/var/lib/mysql/tmp/wordpress.sql.gz" "/home/CHANGEME/backups/wordpress-database-auto-"$$(date +%%Y-%%m-%%d)".sql.gz"' |
