[Vtigercrm-developers] moved to another server

Tony Sandman tonysandman999 at gmail.com
Fri Feb 10 04:03:16 GMT 2017


So... I will describe my findings:


In server1 (from where I moving database) MySQL engine is set to MyISAM but
server2 default engine is InnoDB
If I copy over database from s1 to s2 it truncating tables.

For instance file vtiger_tab.frm from database on server1 is copied to
server2 properly, but table
is not showing in Phpmyadmin on server2 at all. So this is like major
conversion error.

Server1 - MySQL 5.1.65
Server2 - MySQL 5.6.34

What would you do in this situation?

Regards
Tony



On Wed, Feb 8, 2017 at 3:56 PM, Tony Sandman <tonysandman999 at gmail.com>
wrote:

> Thanks guys.
>
>
> Tony
>
> On Tue, Feb 7, 2017 at 4:51 PM, Alan Lord <alanslists at gmail.com> wrote:
>
>> On 07/02/17 09:27, Tony Sandman wrote:
>>
>>> Hi
>>>
>>> Moved all files and databases over from Centos 5 to 7. All stuff working
>>>
>>
>> Depending on the version of vtiger you have make sure you check the
>> sql_modes settings for MySQL. They are much stricter in more recent
>> releases and vtiger might not work properly with things such as
>> STRICT_TRANS_TABLE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ONLY_FULL_GROUP_BY etc...
>>
>>
>>
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20170210/58aadb7f/attachment.html>


More information about the vtigercrm-developers mailing list