Need help backing up SugarCRM 5.0 CE.

[rwilkinson]

I recently installed SugarCRM 5.0 CE, and I have been testing with it for a short time. I would like to attempt a backup and restore procedure but I am not sure exactly how to do this. I've tried connecting the mySQL server to do a mysqldump, but it keeps telling me that mySQL is not running on the socket. (I can log into SugarCRM mind you, so I'm certain that mySQL is indeed up and running.) From a bit of troubleshooting, it seems like PHPAdmin will only let me connect from the localhost address (127.0.0.1) and this is a problem, since I am running this on a linux box with no graphical desktop installed and I do all administration via the command line. Can anyone suggest the best procedure to do a backup and restore test in this configuration?


Thank you,

Ross Wilkinson

[eNick]

Via the linux command line...

mysqldump -u %mysqluser% -p%mysqlpassword% --all-databases >%workdir%\backup.sql

or more probably if you've not got paths set up something like (depending on *nix flavour)...

/usr/bin/mysqldump -u %mysqluser% -p%mysqlpassword% --all-databases >%workdir%\backup.sql

You can then stick that in a cron job and automate it, using logrotate to rotate the backups.

We have it in a script that then ftp's the results to a different server in a different country!