restore of sugarcrm tables

[xilophene ()]

Hi all,

I'm a newbie, so bear with me if I'm asking stupid questions. I hope not.

I use phpMyAdmin to dump/backup a SugarCRM installation on a SQL file, and it works.
The problem arise at the moment of restore.

This is the procedure I follow to update SugarCRM, a web-based CRM application:

   1) I perform a PMA dump/backup of SugarCRM database on a .sql file,
   2) I delete the old SugarCRM web directory structure,
   3) I drop the database in mysql,
   4) I install the new SugarCRM that also creates the new database + the <admin> user,
   5) I restore from the previously produced .sql file

All tables get their expected content except SugarCRM's <users> table that keeps the <admin> user created at install time.

Editing the .sql file I can see that all users records from the old database are in there, so I assume the backup was performed correctly.

Can you please suggest what changes should I implement in my above procedure to get also the <users> table properly restored, and/or alternatively provide me with the steps needed to extract the relevant lines from the .sql file and import them in the database.

Thanks in advance for your help.

[Gary Smith-20]

> This is the procedure I follow to update SugarCRM, a web-based CRM
> application:
>
>    1) I perform a PMA dump/backup of SugarCRM database on a .sql file,
>    2) I delete the old SugarCRM web directory structure,
>    3) I drop the database in mysql,
>    4) I install the new SugarCRM that also creates the new database +
> the
> <admin> user,
>    5) I restore from the previously produced .sql file
>
> All tables get their expected content except SugarCRM's <users> table
> that
> keeps the <admin> user created at install time.
>
> Editing the .sql file I can see that all users records from the old
> database
> are in there, so I assume the backup was performed correctly.
>
> Can you please suggest what changes should I implement in my above
> procedure
> to get also the <users> table properly restored, and/or alternatively
> provide me with the steps needed to extract the relevant lines from the
> .sql
> file and import them in the database.
>
> Thanks in advance for your help.

I suspect that there are not key violation warnings that you are missing when you are running the restore.  After you re-create the SugarCRM instance, it will pre-populate the data for you.  Your goal is to replace that data.  The SQL backup file is probably full of insert statements.  So, just remember, insert != replace.

Here is something you might want to try.  After the clean SugarCRM, truncate all of the newly created tables then run the restore job.  After all, everything you should need should be inside that backup script.

Hope that helps.



------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Phpmyadmin-users mailing list
Phpmyadmin-users@...
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-users