How to do Database Backups with Logrotate - Versionsgeschichte

Matt am 23. Mai 2025 um 11:26 Uhr

2025-05-23T11:26:15Z

@@ Zeile 1: / Zeile 1: @@
-Example for how to create database backups with logrotate.
+Example for how to create database backups with logrotate and also some notes on how to accomplish that
 Create file <code>/etc/logrotate.d/database_backup</code><syntaxhighlight lang="bash">
 # daily backup for 7 days
 /var/backups/mariadb/database_dump.sql {
    rotate 7
    daily
-#  compress
+  compress
    nocopy
    nocreate
+}
 # weekly backup for 4 weeks
-#/var/backups/mariadb/database_dump.sql.7.gz {
+/var/backups/mariadb/database_dump.sql.7.gz {
    weekly
    missingok
@@ Zeile 30: / Zeile 72: @@
 # monthly backup for 12 months
-#/var/backups/mariadb/database_dump.sql.7.gz.4 {
+/var/backups/mariadb/database_dump.sql.7.gz.4 {
    monthly
    missingok
    rotate 12
+}
 https://sautter.com/blog/using-logrotate-to-backup-mysql-and-postgresql-databases/
 https://betterstack.com/community/guides/logging/how-to-manage-log-files-with-logrotate-on-ubuntu-20-04/
 [[Kategorie:Linux]]

Matt am 16. Mai 2025 um 13:29 Uhr

2025-05-16T13:29:23Z

← Nächstältere Version		Version vom 16. Mai 2025, 15:29 Uhr
Zeile 49:		Zeile 49:

	The configuration above is meant to do compression in the future (see commented lines), but I did not test it yet.		The configuration above is meant to do compression in the future (see commented lines), but I did not test it yet.



			Sources:

			https://sautter.com/blog/using-logrotate-to-backup-mysql-and-postgresql-databases/

			https://betterstack.com/community/guides/logging/how-to-manage-log-files-with-logrotate-on-ubuntu-20-04/
	[[Kategorie:Linux]]		[[Kategorie:Linux]]

Matt: Die Seite wurde neu angelegt: „Example for how to create database backups with logrotate. == Example Configuration == The following configuration is still in testing so don't rely on this and take this with a grain of salt. Create file `/etc/logrotate.d/database_backup` # daily backup for 7 days /var/backups/mariadb/database_dump.sql { missingok rotate 7 daily # compress # compresscmd gzip # compressext .gz nocopy nocreate postr…“

2025-04-27T21:19:29Z

Die Seite wurde neu angelegt: „Example for how to create database backups with logrotate. == Example Configuration == The following configuration is still in testing so don't rely on this and take this with a grain of salt. Create file <code>/etc/logrotate.d/database_backup</code><syntaxhighlight lang="bash"> # daily backup for 7 days /var/backups/mariadb/database_dump.sql { missingok rotate 7 daily # compress # compresscmd gzip # compressext .gz nocopy nocreate postr…“

Neue Seite

Example for how to create database backups with logrotate.

== Example Configuration ==
The following configuration is still in testing so don't rely on this and take this with a grain of salt.

Create file <code>/etc/logrotate.d/database_backup</code><syntaxhighlight lang="bash">
# daily backup for 7 days
/var/backups/mariadb/database_dump.sql {
missingok
rotate 7
daily
# compress
# compresscmd gzip
# compressext .gz
nocopy
nocreate
postrotate
/opt/backup-database.sh
endscript
}

# weekly backup for 4 weeks
#/var/backups/mariadb/database_dump.sql.7.gz {
/var/backups/mariadb/database_dump.sql.7 {
weekly
missingok
rotate 4
}

# monthly backup for 12 months
#/var/backups/mariadb/database_dump.sql.7.gz.4 {
/var/backups/mariadb/database_dump.sql.7.4 {
monthly
missingok
rotate 12
}

# yearly backup for 10 years
/var/backups/mariadb/database_dump.sql.7.4.12 {
yearly
missingok
rotate 10
}

</syntaxhighlight>Notes:

The backup-database.sh script creates a database dump with mysqldump, which is not compressed.

The configuration above is meant to do compression in the future (see commented lines), but I did not test it yet.
[[Kategorie:Linux]]