[Vtigercrm-developers] Database schema

[Stacey Johnson]

Thank you. Will get a try this way.

Stacey

On Tue, Feb 10, 2015 at 10:55 AM, Hamono, Chris (DPC) <
Chris.Hamono at sa.gov.au> wrote:

> 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> 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/
>
>
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150210/7b05c920/attachment.html>