[Vtigercrm-developers] migration of large database...

Richard Hills - Technologywise richard at tw.co.nz
Wed Nov 19 21:53:00 GMT 2014


Yes!

I have been using Alan's workaround script in order to be able to get 
our system to upgrade to 6.0.0 as a step in our attempts to move to 
6.1.0 however we are yet to see a 6.1.0 migration complete and I would 
not be surprised if this is the cause (it was the cause of us not being 
able to update to 6.0.0 earlier..). Our crmentity table is around 3m 
entries and our server is unfortunately not as nice sounding as Alan's.

Hoping that some time can be spent on this by the vtiger team.

Thanks

On 19/11/14 12:07, VTE wrote:
> Agreed, large data sets can be complicated. We had a migration with 500k
> comments and it didnt go well. What we did is - truncated modcomments tables
> and removed entries from crmentity, the migration went smoothly and after
> that we just re-inserted mod comments from backup db into upgraded and
> updated the label.
>
>
>
> -----
> VT Experts
> Email: Support at VTExperts.com
> Web:  http://www.VTExperts.com
> Skype: VTExperts
> Phone: +1 (818) 495-5557
>
>
>
> --
> View this message in context: http://vtiger-crm.2324883.n4.nabble.com/Vtigercrm-developers-migration-of-large-database-tp14458p14463.html
> Sent from the vtigercrm-developers mailing list archive at Nabble.com.
> _______________________________________________
> http://www.vtiger.com/

-- 

Richard Hills
TechnologyWise Ltd, Tauranga, NZ
richard at tw.co.nz
www.technologywise.co.nz
ph: +64 (0)7 571 1060
fax: +64 (0)7 571 1061



More information about the vtigercrm-developers mailing list