automysqlbackup(8)

✨ automysqlbackup ✨

okay bestie, welcome to automysqlbackup(8) — she's a little script that backs up ALL your databases on the daily, the weekly, AND the monthly. three whole timeframes. she's booked and busy. 💅

🎀 SYNOPSIS 🎀

automysqlbackup

that's it. that's the whole vibe. you just run her. ✨

💖 DESCRIPTION 💖

so like, this manual page is the quick lil rundown of the automysqlbackup command. it's giving "briefly documents", and honestly? we love that for us.

the configuration? it lives inside the /etc/default/automysqlbackup file. that's her home. that's where you go to tell her what to do. 🏠

🌸 PARAMETERS 🌸

these are the everyday, main-character settings you'll find in that config file. no cap.

• USERNAME=dbuser — the username you use to access the MySQL server, e.g. dbuser. who are you logging in as, bestie?
• PASSWORD="password" — the password to access the MySQL server, e.g. password. (yes the manpage says "Username" here. we're just gonna keep it real and tell you it's the password. 🙈)
• DBHOST=localhost — host name (or IP address) of the MySQL server, e.g. localhost.
• DBNAMES="DB1 DB2 DB3" — the list of DBNAMES for your Daily/Weekly Backup, e.g. "DB1 DB2 DB3". drop 'em all in there, space-separated, slay.
• BACKUPDIR="/backups" — where the backup directory lives, e.g. /backups.
• MAILCONTENT="stdout" — mail setup! what would you like mailed to you? choices are:
  • log : send only the log file
  • files : send the log file and the sql files as attachments (see docs)
  • stdout : will simply output the log to the screen if run manually.
  • quiet : Only send logs if an error occurs to the MAILADDR.
• MAXATTSIZE="4000" — set the maximum allowed email size in k. (4000 = approx 5MB email [see docs]). like, keep it reasonable bestie.
• MAILADDR="user@domain.com" — email address to send mail to? (user@domain.com). where do the receipts go??

👑 ADVANCED OPTIONS 👑

ok now we're in the deep end. this is the highkey stuff. 🦋

• MDBNAMES="mysql $DBNAMES" — list of DBBNAMES for Monthly Backups. (yep, the original really does say DBBNAMES. iconic typo, we keep it. 💀)
• DBEXCLUDE="" — list of DBNAMES to EXCLUDE if DBNAMES are set to all (must be in " quotes). not you, not you, and definitely not you.
• CREATE_DATABASE=yes — include CREATE DATABASE in the backup? yes or no, your call.
• SEPDIR=yes — separate backup directory and file for each DB? (yes or no). keep your girls organized fr fr.
• DOWEEKLY=6 — which day do you want weekly backups at? (1 to 7 where 1 is Monday).
• COMP=gzip — choose compression type. (gzip or bzip2).
• COMMCOMP=no — compress communications between the backup server and the MySQL server?
• LATEST=no — additionally keep a copy of the most recent backup in a separate directory. main character backup gets her own room. 👑
• MAX_ALLOWED_PACKET= — the maximum size of the buffer for client/server communication. e.g. 16MB (maximum i
• SOCKET= — for connections to localhost. sometimes the Unix socket file must be specified. lowkey important.
• #PREBACKUP="/etc/automysqlbackup/mysql-backup-pre" — command to run before backups (uncomment to use). it's commented out, so uncomment it if you want it, bestie.
• #POSTBACKUP="/etc/automysqlbackup/mysql-backup-post" — command run after backups (uncomment to use). same deal.

heads up: those last two are commented out with a # in the config — they do nothing until you uncomment them. 💜

🌈 AUTHOR 🌈

this manual page was written by Jose Luis Tallon <jltallon@adv-solutions.net>. for the Debian GNU/Linux system, but can be used by others. we stan a generous king. 🫶

and that's the whole page, bestie!! 💖 written by wipe_out, dated 6 Sep 2008 — yeah she's vintage, she's a classic, she's still out here backing up your databases. no notes. periodt. ✨🎀🦋