Secure method of backuping database?

[crspyjohn]

Could anyone help me figure out a way to securely backup a WHMCS database on a shared server? The automated one is unsecure and stops working after 20mbs~

[WHMCS Chris]

Hello,

 

Are you using cPanel? If so, it has a backup utility built into it.

 

Alternatively, you could just create a cronjob to do that.

mysql -u$username -p$pass $db > /path/to/desiredbackupfolder/whmcs_db.`date "+%Y%m%d"`.sql

[bear]

Adding a pass into a cron is not a good idea. That shows up in various places, including any cron email generated.

Get yourself a backup script (or turn the command above into one), stick it where no one can reach it externally, and cron that instead.

 

As for it being secure on a shared server? Risky in general, and only as secure as the server and all accounts on it.

[WHMCS Chris]

Adding a pass into a cron is not a good idea. That shows up in various places, including any cron email generated.

 

Disabling cron emails is simple, and only ones with access to the users crontab is the user, and root.

 

If you didn't want to have a password in a cronjob, grab it from the configuration.php file.

 

mysql -u$username -p`grep db_password /path/to/whmcs/configuration.php|awk -F"'" '{print $2}'` db_name > /path/to/desiredbackupfolder/whmcs_db.`date "+%Y%m%d"`.sql

[bear]

This should fix it.

 

http://docs.cpanel.net/twiki/bin/view/AllDocumentation/CpanelDocs/CronJobs

 

Note: If you do not wish to receive an email notifying you of a specific cron job, add the following line to the command: >/dev/null 2>&1