Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Database Backups

...

 

//Install Backup Manager

sudo apt-get install backup-manager

sudo apt-get install libnet-amazon-s3-perl 


//Modify Backup manager configuration file

sudo nano /etc/backup-manager.conf


//Locate and change the following properties with you actual S3 credentials

Make the following changes to it

export BM_ARCHIVE_METHOD=”mysql”

export BM_MYSQL_DATABASES=”mifostenant-default

export BM_MYSQL_ADMINLOGIN="root"

export BM_MYSQL_ADMINPASS=”password

export BM_UPLOAD_METHOD=”s3"

export BM_UPLOAD_S3_DESTINATION=”s3bucketname

export BM_UPLOAD_S3_ACCESS_KEY=”s3accesskey

export BM_UPLOAD_S3_SECRET_KEY=”s3secretkey

Note: - Yellow marked fields should be updated with respect to your settings.  


Automating the process can be as simple as adding a cron job for the mysqldump command. 

 Cron Job for backups

Scheduling a cron job for taking periodic backups

...