Database backup

[xperience]

Is anyone else unable to use the built-in database backup because their db is too large? Our is around 250mb which apparantely is far too large for WHMCS to backup due to memory and execution limits being exceeded.

 

Anyone use another solution (automated rather than manual!)

[hightekhosting]

If you are using a cPanel/Plesk server for your WHMCS install, why not just use the automated backup feature within the server to backup your entire account/site?

 

Of course, you will need root/admin access for this.

[xperience]

sorry - forgot to say - we're looking for off-server backups by FTP!

[hightekhosting]

sorry - forgot to say - we're looking for off-server backups by FTP!

 

Windows or Linux?

 

Linux you could just write/build a cron to do a MySQL dump on a daily basis and then copy it to an offsite FTP server somewhere.

 

Windows you could effectively do the same.

[robb3369]

Here is a script we run daily via cron from the home directory of the account that WHMCS is running under:

 

#!/bin/sh
DAYNUM="$(date +"%u")"
mysqldump -h localhost -u DB_USER -pDB_PASSWORD DB_NAME --add-drop-table --insert-ignore | gzip -9 > /home/SITENAME/whmcs_backup_day_$DAYNUM.sql.gz

 

How I have the last 7 days worth of backups of just the WHMCS database:

whmcs_backup_day_1.sql.gz
whmcs_backup_day_2.sql.gz
whmcs_backup_day_3.sql.gz
whmcs_backup_day_4.sql.gz
whmcs_backup_day_5.sql.gz
whmcs_backup_day_6.sql.gz
whmcs_backup_day_7.sql.gz

 

You can easily add an ftp or rsync command (to the end of the script) to copy your backup file to another server...