English (United Kingdom)
Jms Multi Site, formerly joomla multisite.
Create, share multiple joomla sites in few clicks !
Home Weekly Backup Script (All DBs)
Message
  • EU e-Privacy Directive

    This website uses cookies to manage authentication, navigation, and other functions. By using our website, you agree that we can place these types of cookies on your device.

    View e-Privacy Directive Documents

Details for Weekly Backup Script (All DBs)
PropertyValue
NameWeekly Backup Script (All DBs)
Description

Concept

The "weekly backup script (All DBs)" is composed of 2 shell script.
A first one that is called by the cront

A second one that perform the operation.

For the customization, you need to update the "cron" one and potentially the email notification present in the second shell.

This script save the backup in a subdirectory "weekly" followed by a subdirectory with the name of the day.
So that you have maximum 7 subdirectories (one for each day of the week).

Installation

  • Download the "backup_alldbs.zip"
  • Unzip the files into a directory present on your server and that can be called by cron
    We suggest that you create a "backup/cpanel" directory on your server and that you put the script in this directory.

    The result of the backup will be stored in directory like
    backup/weekly/Monday/BackupName.tgz
    backup/weekly/Tuesday/BackupName.tgz
    backup/weekly/Wednesday/BackupName.tgz
    backup/weekly/Thirsday/BackupName.tgz
    backup/weekly/Friday/BackupName.tgz
    backup/weekly/Saturday/BackupName.tgz
    backup/weekly/Sunday/BackupName.tgz
  • With a chmod, change the permission of the file to add the "execute" attribute

Syntax

Most of the parameters are defined in the "backup_alldbs_cron.sh".

This script can do a lot:

  • It is possible to send the backup on 1 or 2 FTP account outside the server
  • It is also possible to encrypt the compressed file when the FTP is sent on server that you do not control.
  • It is possible to send an email notification when the backup is completed.

 

Limitations

  • It is assumed that the DB is located in the "localhost".
    If you want to perform backup from DB that are located on another server, you will have to modify the "mysqldump"
  • The DB backup is performed with NO table locking and also ignore the SQL error that would stop the script.
    If you want to perform a backup with "table locked", remove the "--lock-tables=false" command in the mysqldump
  • We recommand to avoid using special characters in the FTP password.
    If you have special character, perhaps you should change the syntax of the LFTP to autorise that.
    We have considered that a specific FTP user and FTP password would be used to transfert the backup on another server.
  • Avoid using a $ (dollar) character in the DB password.
    The $ is generally used in the shell script to identify variable.

remark:

The FTP transfert use a "lftp" command.

If this LFTP is not installed on your server, you can use a "yum install lftp".

In case where you have an error on Perl library dependencies error, see also the following article that may help you.

https://forums.cpanel.net/f34/missing-dependency-lftp-install-242641.html

See also the other weekly backup script for single website.

 

Filenamebackup_alldbs.zip
Filesize1.76 kB
Filetypezip (Mime Type: application/zip)
Creatoredwin2win
Created On: 01/21/2012 11:37
ViewersEverybody
Maintained byedwin2win
Hits7268 Hits
Last updated on 04/03/2014 17:35
Homepage
CRC Checksum
MD5 Checksum
2Win, Multisite(s) are trademarks of Edwin2Win.
Joomla