Remote backup

[joris]

Maybe it is alrady available and that I am not aware of it.
My question is if there is a posibility to remotely make a backup of the data collected by Sugarcrm on our server and backing it up to another server where all other backups are collected.

the mysql db is on a linux server.

on the win2003 server i'm using a backup program which can run programs(for example batchfiles) before a backup is processed

[stevec]

Hi,

Have a look at mysql.com and search for mysql backup options. There are details on local, remote, automated etc. You could do something like schedule a job to dump the SQL database to file and remote sync it's holding directory to the backup server. A more complex one is to synchronise the database with another installed on the backup machine and have that backup. This means there is no downtime for the backup

[malcolmh]

If you are using windows server, try the mySQL Administrator tool, or for all platforms try the utility phpmyAdmin.

[stevec]

If you are using windows server, try the mySQL Administrator tool, or for all platforms try the utility phpmyAdmin.

These ar great tools for backups but have the disadvantage that they need user interaction. If the backups are being taken to anotheer backing to be covered by automated daily backups, then it would be best if they were automated to.

[kpit]

These ar great tools for backups but have the disadvantage that they need user interaction. If the backups are being taken to anotheer backing to be covered by automated daily backups, then it would be best if they were automated to.

There are command line tools if you are running on the server that can be scripted in a shell script and timed to run with your cron (unix) or Task Scheduler (windows). for more information on the commands see mysql site http://dev.mysql.com/doc/refman/4.1/en/backup.html

Cheers,
Max