[Vtigercrm-developers] Database schema

[Hamono, Chris (DPC)]

Hi

We have just had an issue with Migration. I am not sure if the issue is the same as yours but this might help

Backup your database, if using phpmyadmin make sure you  select to drop tables before recreating

Once backed up and checked for consistency drop your database
Then recreate the database with the collation set to utf8 general ci

CREATE SCHEMA `new_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;

Once created then import your data.

I have had weird issues caused by collation mismatches which caused table to fail to be created. The above sets the default collation. When I did this I was able to reimport y database and everything (to date) started working again.

Good luck

Chris


From: vtigercrm-developers-bounces at lists.vtigercrm.com [mailto:vtigercrm-developers-bounces at lists.vtigercrm.com] On Behalf Of Stacey Johnson
Sent: Monday, 9 February 2015 1:02 AM
To: vtigercrm-developers at lists.vtigercrm.com
Subject: Re: [Vtigercrm-developers] Database schema

I have similar situation - something is wrong after migrations and I would like to refresh schema.
Can you gents share your the best way to do it?

Stacey

On Thu, Feb 5, 2015 at 11:45 PM, Alan Lord <alanslists at gmail.com<mailto:alanslists at gmail.com>> wrote:
On 05/02/15 16:34, Phasaphon Kwanrutai wrote:
Hi, please help :-)
I need to update database schema to suit to v 6.2. i believe migration
wasn't successful 100% and to make it working I would like to update all
default fields and relations. I am very far from expertise in mysql
therefore I would like to ask you to help me in this case. Possibly some
script or command line tool?
OK, hope you can help somehow.

There are no real schema changes between 6.1.0 and 6.2.0, only some very minor edits. Look in modules/Migration/schema/610_620.php for what was changed.

Al


_______________________________________________
http://www.vtiger.com/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150210/ae709be2/attachment.html>