How to schedule automatic backup?

[rogersugarsugar]

4.5.1e

The subject line says it all, I think. I can do a manual backup, but I see no way to actually schedule one. I could create an external cron job, but I see no information on what the manual backup actually does, so I can duplicate it.

(And, regarding the manual backup, I can only backup to the /tmp directory. Anywhere else, including a directory with exactly the same permissions as /tmp, with full 777 along the path, and SugarCRM complains:

Backup directory does not exist, and could not be created.
Backup directory exists, but is not writable.
)

Thanks.

[ptemplin7]

Create the cron job. Sugar backup is basically useless as it does NOT backup the database, a critical component.

In the cron job use gzip or whatever to zip the entire crm folder in one file and put it somewhere. (I use a backup folder on the webserver /var/www/html/backup) In the crontab also use mysqldump to backup the database. (Use anohter tool if using a DB other than the default mysql.)

Alternately you can use myphpadmin to do this as well.

Here are some syntax for the mysqldump.

$ mysqldump --opt -u [uname] -p[pass] [dbname] > [backupfile.sql]
where:
[uname] Your database username
[pass] The password for your database (note there is no space between -p and the password)
[dbname] The name of your database
[backupfile.sql] The filename for your database backup
[--opt] The mysqldump option
For example, to backup a database named 'Tutorials' with the username 'root' and with no password to a file tut_backup.sql, you should accomplish this command:$ mysqldump -u root -p Tutorials > tut_backup.sql

OR If your mysql database is very big, you might want to compress the output of mysqldump. Just use the mysql backup command below and pipe the output to gzip, then you will get the output as gzip file.
$ mysqldump -u [uname] -p[pass] [dbname] | gzip -9 > [backupfile.sql.gz]

Hope this helps,
Paris

[AlexKh]

Hello, rogersugarsugar!

After you created the archive file, you may also take a tool like Apatar to schedule an automated backup. For instance, you can configure it to back up your files at FTP server, or WebDAV, or Buzzsaw, or Amazon S3 web hosting, or whatever.

Hope this would help.

---
Alex Khizhnyak
Apatar Evangelist

[rogersugarsugar]

My solution was to make it part of the nightly backup, run through cron.

Just shut down the database and put all of sugarcrm into a save set, including the database.

I keep 7 days of online backups of all data on the system, with copies on a separate drive, and burn a copy to DVD periodically, for offsite storage.

[nyaconis]

do this:
> crontab -e

edit the following:
[savedirectory] - change to where your user has write access
[usernmae] - your mysql username with dump rights.
[password] - the password to the username
[databasename] - the db name in the mysql database list.

* * * * * cd /sites/sugarce; php -f cron.php > /dev/null 2>&1
01 00 * * * mysqldump --opt -u[username] -p[password] [databasename] > [savedirectory]/sugarce_backup_current.sql;mv [savedirectory]sugarce_backup_current.sql [savedirectory]/$(date +%m%d%Ysugarce_backup.sql);gzip -f [savedirectory]/$(date +%m%d%Ysugarce_backup.sql);
45 00 * * * cp -rf [sugarcrm file path: /sites/sugar] [savedirectory]/sugarce;tar -cf [savedirectory]/sugarce.tar [savedirectory]/sugarce;rm -rf [savedirectory]/sugarce;gzip -f [savedirectory]/sugarce.tar; mv [savedirectory]/sugarce.tar.gz [savedirectory]/$(date +%m%d%Ysugarce_backup.tar.gz);

save this.
restart crond.

here is an example:
* * * * * cd /sites/sugarce; php -f cron.php > /dev/null 2>&1
01 00 * * * mysqldump --opt -umyuser -pmypassword sugarcrm > /bak/db/sugarce/sugarce_backup_current.sql;mv /bak/db/sugarce/sugarce_backup_current.sql /bak/db/sugarce/$(date +%m%d%Ysugarce_backup.sql);gzip -f /bak/db/sugarce/$(date +%m%d%Ysugarce_backup.sql);
45 00 * * * cp -rf /sites/sugarce /bak/apps/sugarce;tar -cf /bak/apps/sugarce.tar /bak/apps/sugarce;rm -rf /bak/apps/sugarce;gzip -f /bak/apps/sugarce.tar; mv /bak/apps/sugarce.tar.gz /bak/apps/$(date +%m%d%Ysugarce_backup.tar.gz);


At midnight every morning, this will build a gziped backup of the sugar database and name it MMDDYYYY_sugarce_backup.sql.zip.
At 12:45 every morning, this will build a tar gzipped copy of your entire sugar application directory and name it MMDDYYYY_sugarce_backup.tar.gz.