Differences

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

--- nethserver-automysqlbackup [2015/05/21 20:12]
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. At least 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 huge options except the mail 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
-  yum install http://mirror.de-labrusse.fr/NethServer/6/noarch/nethserver-stephdl-1.0.0-1.ns6.noarch.rpm
-then you can install my module
-  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===
-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===
-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