Results 1 to 4 of 4

Thread: Backup Sugar 4.2.0b and Importing into 4.5?

  1. #1
    ErikLindquist is offline Sugar Community Member
    Join Date
    Aug 2006
    Posts
    44

    Default Backup Sugar 4.2.0b and Importing into 4.5?

    I was wondering if it was possible to backup the following elements of Sugar 4.2.0b and import them into Sugar 4.5b
    • Accounts
    • Contacts
    • Opportunities
    • Projects


    I am running both versions of Sugar on
    • Bitrocks stack
    • MySQL
    • Apache


    Can I do a MySql dump and then import or are their new links between Accounts, Contacts, Opportunities and Projects that might be broken or left invalid?


    Thanks,

    Erik

  2. #2
    Markku's Avatar
    Markku is offline Sugar Community Member
    Join Date
    Nov 2004
    Location
    Helsinki
    Posts
    910

    Default Re: Backup Sugar 4.2.0b and Importing into 4.5?

    Most likely that would not work.

    Database structure is different between 4.2.0 and 4.50 plus there are dependencies between other tables.

    You probably could compare db structure between these two versions and apply 4.5 changes manually to your existing 4.2.0 database, Just curious, why not to use upgrade wizard?

    Best,

    - Markku

  3. #3
    ErikLindquist is offline Sugar Community Member
    Join Date
    Aug 2006
    Posts
    44

    Default Re: Backup Sugar 4.2.0b and Importing into 4.5?

    Thanks Markku,

    I created a separate 4.5 instance because I was having too many issues with 4.2.0b and also something broke when I installed the Objectives Module.

    So I figured I would start fresh, fortunately we are only in a limited production use of 4.2, so even if people have to re-enter into 4.5 it won't be a major show stopper.

    Perhaps export and import of Accounts, Contacts, Opportunities, and Projects will work?

    Erik

  4. #4
    kpit's Avatar
    kpit is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Dec 2005
    Location
    Memphis, TN
    Posts
    996

    Default Re: Backup Sugar 4.2.0b and Importing into 4.5?

    you could use the export functionality in SugarCRM?

    That might be a safer way to do it. Or use the SQL upgrade scripts in the patch file. then export the file with mysql dump.

    But a small warning about moving the whole database. your troubles can follow you.
    Cheers,

    Max W. Blackmer, Jr.

    Blog
    Phone: +1 (901) 672-2694



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
  •