[prev in list] [next in list] [prev in thread] [next in thread] 

List:       vtigercrm-developers
Subject:    Re: [Vtigercrm-developers] Number of tables
From:       "Mickie M" <mickie () vtiger ! com>
Date:       2007-12-19 16:53:12
Message-ID: 7a45853c0712190841v72b58746lc4dc78dd8d5f5ab7 () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Dear Clement,

In a fresh 5.0.4 installation there will be 311 tables where as 60+ tables
are seqence tables.
But in the migrated database there may not be that much tables.

So by executing the query show tables like '%_seq'; you can find out how
many sequence tables are available in both databases. Also we can find out
how many tables are missing (by executing the query show tables;) where as
mostly sequence tables will be lesser in the migrated database.

By looking into the logs/vtigercrm.log or logs/migration.log we can find out
where the migration has been stopped due to time out. Also you can find out
the queries in the files which are available under
modules/Migration/DBChanges directory.

Kindly get back to us for further informations.
Thanks & Regards
Mickie

On 12/14/07, clement chazarra <chazarra.clement@gmail.com> wrote:
>
> Hello everybody,
>
> I am trying to get 5.0.4 on my centos server, but had some issues about
> the max_execution_time.. I 'd like to know if I got the good number of
> tables to verify if everything has gone well(the migration screen stay on
> "Please wait").
> How many tables should I get after miration from 4.2.3?
>
>
> Regards,
> Clem
>
> _______________________________________________
> Reach hundreds of potential candidates - http://jobs.vtiger.com
>

[Attachment #5 (text/html)]

Dear Clement,<br><br>In a fresh 5.0.4 installation there will be 311 tables where as \
60+ tables are seqence tables. <br>But in the migrated database there may not be that \
much tables. <br><br>So by executing the query <span style="font-weight: bold;"> show \
tables like &#39;%_seq&#39;;</span> you can find out how many sequence tables are \
available in both databases. Also we can find out how many tables are missing (by \
executing the query <span style="font-weight: bold;"> show tables;</span>) where as \
mostly sequence tables will be lesser in the migrated database.<br><br>By looking \
into the logs/vtigercrm.log or logs/migration.log we can find out where the migration \
has been stopped due to time out. Also you can find out the queries in the files \
which are available under modules/Migration/DBChanges directory. <br><br>Kindly get \
back to us for further informations.<br>Thanks &amp; \
Regards<br>Mickie<br><br><div><span class="gmail_quote">On 12/14/07, <b \
class="gmail_sendername">clement chazarra</b> &lt;<a \
href="mailto:chazarra.clement@gmail.com"> chazarra.clement@gmail.com</a>&gt; \
wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, \
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hello everybody,<br><br>I \
am trying to get 5.0.4  on my centos server, but had some issues about the \
max_execution_time.. I &#39;d like to know if I got the good number of tables to \
verify if everything has gone well(the migration screen stay on &quot;Please \
wait&quot;).  <br>How many tables should I get after miration from \
4.2.3?<br><br><br>Regards,<br>Clem<br> \
<br>_______________________________________________<br>Reach hundreds of potential \
candidates - <a onclick="return top.js.OpenExtLink(window,event,this)" \
href="http://jobs.vtiger.com" target="_blank">http://jobs.vtiger.com </a> \
<br></blockquote></div><br>



_______________________________________________
Reach hundreds of potential candidates - http://jobs.vtiger.com 

[prev in list] [next in list] [prev in thread] [next in thread]