Backup data in Sugar

[nmpaulcp]

I was wondering what the best way to backup a copy of the data in Sugarcrm 4.xx in case of system failure or other problem that would allow me to reinstall Sugarcrm and then reintroduce the data to the MySql DB. I am currently running 4.0 on XAMP. on my Windows 2000 server.
What is everyone else doing for backup?

[atheimer98]

For Windows, create a scheduled task that does a sql dump (creates a yourfile.sql file) every morning or nite. If anything ever happend you would be able to install sugar back to your current version and restore your db using the most recent sql dump file.
In linux, you would create a cron job that does the same thing.

[sugarcare]

does this backups the attachments/notes too? Probably if they store the notes in the DB.

[longreach]

Notes are in the DB - attachments are in cache/upload.

[nmpaulcp]

Thanks for the replies. I know how to schedule tasks but as for setting up the SQL dump, I'm lost .

[sugarcare]

there is a script that comes with mySQL mysqldump (check the actual command) that dumps the entire database to a file. You move this to a CD or tape or external source.

But if attachments are stored external to DB, then you have to write a script to copy them also. MysqlDump only backups the database, not files.

[atheimer98]

Check out the comments on this post there are some great tips for creating a batch file for windows mysql dumps.

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

[nmpaulcp]

Check out the comments on this post there are some great tips for creating a batch file for windows mysql dumps.

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

Thanks but I am still lost. I was hoping I might be able to use the php utility in Xamp and export the sql file. Then Reinstall it to a new installation of Sugar if needed. I guess that would be too easy! Damn I wish I had a bit more knowledge about all these commands, php, and sql related stuff.