Backup

[pinto77]

How to take backup of the sugarcrm?
The integrated backup option is taking database backup?
if not, then what of type files it is takeing the backup?
How to take the backup of mysql database?

[paikmoses]

Hi pinto77,

I would prefer to take Sugar back-up manually. It's not that hard to take the back-up of MySQL as well. Please have a look at this: http://sugarcrm.openapp.org/?p=141

It will help you take the back-up of Mysql.

To populate the dump, check this out: http://sugarcrm.openapp.org/?p=142

Hope this helps.

Regards,

[stevec]

Hi,

There should be an FAQ on this..

The sugar backup is for the files. You can use this or alternatively just backup the files in the web root.

For the database, there are quite a few options. You can use the backup options in tools like phpmyadmin (ad hoc) and navicat (ad hoc and scheduled). MySQL also have an administrator tool that can do ad hoc and scheduled backups.

http://www.phpmyadmin.net/home_page/index.php
http://www.navicat.com/
http://www.mysql.com/products/tools/administrator/

For enterprise you can also get mysql database plugins for the backup bigboys (arcserv/brightstor and backupexec etc)

Alternatively, you can be old-school' and use the basic mysql command line tools:

http://dev.mysql.com/doc/refman/5.0/en/backup.html

Or you can be really 'L33t' and do the above, schedule it with 'cron' and then 'rsync' the backup and the webroot files to another server for proper offline backup and redundant availability. Alternatively, set up a slave server and rync over the binary logs - and periodically, halt this database and do a cold backup.

.