Results 1 to 2 of 2

Thread: Need assaitance in backing up my database

  1. #1
    GWsugar is offline Member
    Join Date
    Jul 2006
    Posts
    9

    Default Need assaitance in backing up my database

    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.

  2. #2
    mycrmspacegunnar is offline Sugar Community Member
    Join Date
    Sep 2006
    Posts
    105

    Default Re: Need assaitance in backing up my database

    Quote Originally Posted by 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.

    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
    Gunnar von Boehn
    myCRMspace

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •