Need assaitance in backing up my database

[GWsugar]

Hi,

I am new to Sugar and to Linux and I would like some assistance in backing up my Sugar database and application. I think that I have a handle on backing up the Sugar application but I do not know MYSQL and having a difficult time on backing up the SQL database. The version of Sugar I am running is 4.0.1.E ad I do not know how to determine what version of MYSQL or PHP that I a running. I would appreciate any help anyone can lend me on backing up my database. I need to backup my database because I am planning to do an upgrade and I want to make sure that if anything goes wrong I can revert to my old version.

[mycrmspacegunnar]

Hi,

I am new to Sugar and to Linux and I would like some assistance in backing up my Sugar database and application. I think that I have a handle on backing up the Sugar application but I do not know MYSQL and having a difficult time on backing up the SQL database. The version of Sugar I am running is 4.0.1.E ad I do not know how to determine what version of MYSQL or PHP that I a running. I would appreciate any help anyone can lend me on backing up my database. I need to backup my database because I am planning to do an upgrade and I want to make sure that if anything goes wrong I can revert to my old version.

I assume you are running Sugar on your own Linux server, is this correct?

A very reliable tool for backing up a mysql database is the shell command mysqldump.
You can use it to create an sql dump of any mysql database.

Example:

mysqldump -udatabas_username -p sugarcrm_database > sugarcrm.sql

This command will connect to your local database server as the user "database_username"
and it will create an backup of your database "sugarcrm_database".
The backup will be stored in the file sugarcrm.sql
You will be prompted for the password of your database user.

The config.php in your sugarcrm webfolder will contain the name of your used database user,
his password and the name of the used sugarcrmdatabase.
Please replace these values with your settings.

Cheers
Gunnar