Back-up of mysql

[Shuchi]

Hi,

Just wantede to know if there is a way of backing up mysql data every couple of weeks????

[juergen]

Give it a try with phpMyBackup, You can find this software @ www.sourceforge.org.

It will email the backups or ftp them, as you like.

Juergen

[stevec]

There is also the standard mysqldump command - see the backup tutorial on the mysql website

[bbowens]

Is that all that is entailed in order to backup the SugarCRM database?

[stevec]

The database, yes. Though you'll also need to back up the actual php files too.

With the standard mysql database backups, be aware that the database has to be locked for the process. That means that SugarCRM will effectively be unavailable during the backup process. If that is not an issue, fine. If it is, there are options to do more infrequesnt full backups and enable and regularly flush the mysql bianry logs and back these up as incremental file backups.

If you really want to limit downtime to an absolute minimum, then you could set up one way replication to a sperate mysql database server and back that up instead.