Differences

This shows you the differences between two versions of the page.

--- nethserver-automysqlbackup [2016/09/24 19:05]
stephdl
+++ nethserver-automysqlbackup [2019/06/05 19:48]
@@ Line 1: / Line 1: @@
-==Automysqlbackup==
-[http://sourceforge.net/projects/automysqlbackup/ AutoMySQLBackup] associates with DB configuration will create Daily, Weekly and Monthly backups of your MySQL databases. There is no panel in the server-manager but the configuration is quite simple with few commands listed above, handle by "config setprop automysqlbackup". I'm fairly sure that you do not have to modify a lot of options except the email account where logs and files are sent.
-With this contribs you save your mysql databases in a simple way.
-Other Features include:
-  *Email notification of backups
-  *Databases split and sent by mails
-  *Backup Compression and Encryption
-  *Configurable backup rotation (no db command yet, you have to do it manualy)
-  *Incremental database backups (no db command yet, you have to do it manualy)
-==Installation==
-First you need to install my repository, [[nethserver|see how to do it]]
-then you can install my module (not yet available)
-  yum install nethserver-automysqlbackup --enablerepo=stephdl
-== Panel==
-There is no panel for manage this contrib, you  have to play with db configuration command but normally the options by default could be sufficient.
-==How to launch the backup==
-You can launch manually the database backup by a command line with automysqlbackup in a root terminal.
-  automysqlbackup
-otherwise every night, a cron job start à 4h00 AM to save your databases.
-==DB command option==
-If you want to see the db configuration of automysqlbackup.
-  config show automysqlbackup
-===Backup directory===
-It is the folder where you save you database backup '''(default is /root/backup/db)'''. This is the architecture of your backup folder.
-<WRAP center round tip 60%>
-keep in mind that the /root folder is saved with the backup of your server-manager
-</WRAP>
-  #ls /root/backup/db/
-  daily  fullschema  latest  monthly  status  tmp  weekly
-If you want to save in another place, you have to do the command below.
-  config setprop automysqlbackup Backupdir /path/to/other/folder
-you have to create manually your new backup directory
-  mkdir -p /path/to/other/folder
-===Backup a local directory===
-the possibility is given to you to save a local directory by automysqlbackup. I suppose that you can not use it for large folder but for a web site with its database it could be useful. not activated by default
-  config setprop automysqlbackup Backup_local_files /path/to/folder
-===Encryption===
-If you wish to encrypt your backups using openssl '''(no is default)'''
-  config setprop automysqlbackup Encrypt yes
-you need to set a password '''(default is 01234567899876543210)'''
-  config setprop automysqlbackup Dbencrypt_password your-password
-<WRAP center round important 60%>
-This option may be useful when you want to save  your databases outside of your server by sending them by mails. keep in mind to change the default password
-</WRAP>
-===Decryption===
-To decrypt run :
-  openssl enc -aes-256-cbc -d -in encrypted_file_name(ex: *.enc.gz) -out outputfilename.gz -pass pass:your-password
-example :
-  openssl enc -aes-256-cbc -d -in daily_horde_2013-04-26_01h41m_Friday.sql.gz.enc -out daily_horde_2013-04-26_01h41m_Friday.sql.gz \
-  -pass pass:01234567899876543210
-===Mailcontent===
-<WRAP center round important 60%>
-You need to install the rpm nethserver-mail-server and set a password to the 'admin' user
-</WRAP>
-you can choose your type of mail send to the admin '''(log by default)'''
-  config setprop automysqlbackup Mailcontent **<option>**
-option :
-  * log   : send only log file (default)
-  * files : send log file and sql files as attachments
-  * stdout : will simply output the log to the screen if run manually.
-  * quiet : Only send logs if an error occurs to the MAILADDR.
-<WRAP center round tip 60%>
-Use the "'''files'''" option with the Mailcontent db to save your mysql databases in a mailbox outside of your server, moreover they are saved too in a local folder of your server (by default/root/backup/db)
-</WRAP>
-===Mailto===
-<WRAP center round important 60%>
-You need to install the rpm nethserver-mail-server and set a password to the 'admin' user
-</WRAP>
-you can choose the mail  account where you sent your mails '''(default is the mailbox admin of your server)'''.
-  config setprop automysqlbackup Mailto foo@foo.com
-===Sizemail===
-you can determine the size of mails sent '''(default is 8000 KB)'''.
-  config setprop automysqlbackup Sizemail 8000
-<WRAP center round tip 60%>
-keep in mind that a lot of smtp server reject mail bigger than 10 000 KB or 10MB
-</WRAP>
-==Manual Settings==
-There are many options you can modify in automysqlbackup, so for a personal need you can adjust by hand the files below. make a copy before.
-  cp /etc/automysqlbackup/myserver.conf /etc/automysqlbackup/myserver.conf-old
-  nano /etc/automysqlbackup/myserver.conf
-==RESTORING==
-===restoring a .sql file===
-In a root terminal
-  cd /root/backup/db/
-and choose your backup
-  gunzip file-name.sql.gz
-Next you will need to use the mysql client to restore the DB from the sql file.
-  mysql database < /path/file.sql
-NOTE: Make sure you use < and not > in the above command because you are piping the file.sql to mysql and not the other way around
-If you want to play with another user or a remote mysql server you can use this command line
-  mysql --user=username --pass=password --host=dbserver database < /path/file.sql
-===restoring databases sent by mail attachment===
-The attachments have been split into multiple files, use this command line to combine them :
-  cat mail_attachment_2011-08-13_13h15m_* > mail_attachment_2011-08-13_13h15m.tar.bz2
-and do this to extract the content
-  bunzip2 <mail_attachment_2011-08-13_13h15m.tar.bz2 | pax -rv
-==Known Issues==
-* Warning: Skipping the data of table mysql.event. Specify the --events option explicitly. SOLVED in [[bugzilla:8146]]
-see http://www.linuxbrigade.com/warning-skipping-data-table-mysql-event/#more-135
-see that discussion http://bugs.mysql.com/bug.php?id=68376
-some solutions :
-if we want to backup databases
- mysqldump -uroot --events mysql > /tmp/mysql.sql
-or if we don't want to backup them
- mysqldump -uroot --events --ignore-table=mysql.event mysql > /tmp/mysql.sql
-==Bugs==
-Please raise Issues on [[https://github.com/stephdl/nethserver-automysqlbackup/issues|github]]
-{{tag>module}}

Stephdl Repository

User Tools

Site Tools

Differences

Page Tools