<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none"><!--P{margin-top:0;margin-bottom:0;} #yiv3029668314 _filtered #yiv3029668314
{font-family:Calibri}
_filtered #yiv3029668314
{font-family:Tahoma}
#yiv3029668314 #yiv3029668314 p.yiv3029668314MsoNormal, #yiv3029668314 li.yiv3029668314MsoNormal, #yiv3029668314 div.yiv3029668314MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
#yiv3029668314 a:link, #yiv3029668314 span.yiv3029668314MsoHyperlink
{color:blue;
text-decoration:underline}
#yiv3029668314 a:visited, #yiv3029668314 span.yiv3029668314MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
#yiv3029668314 p.yiv3029668314MsoAcetate, #yiv3029668314 li.yiv3029668314MsoAcetate, #yiv3029668314 div.yiv3029668314MsoAcetate
{margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif"}
#yiv3029668314 span.yiv3029668314EmailStyle17
{font-family:"Calibri","sans-serif";
color:windowtext}
#yiv3029668314 span.yiv3029668314BalloonTextChar
{font-family:"Tahoma","sans-serif"}
#yiv3029668314 .yiv3029668314MsoChpDefault
{font-family:"Calibri","sans-serif"}
_filtered #yiv3029668314
{margin:72.0pt 72.0pt 72.0pt 72.0pt}--></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Can anyone confirm this behavior? I've started and stopped mine several times since adding the SQL connect without it doing this other than the first time.</p>
<p><br>
</p>
<p>I can't stop mine right now to verify.<br>
</p>
<div style="color: rgb(33, 33, 33);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" color="#000000" face="Calibri, sans-serif"><b>From:</b> dxspider-support-bounces@dxcluster.org <dxspider-support-bounces@dxcluster.org> on behalf of IZ8MBW Fabio <iz8mbw@yahoo.it><br>
<b>Sent:</b> Tuesday, January 20, 2015 9:33 AM<br>
<b>To:</b> The DXSpider Support list<br>
<b>Subject:</b> Re: [Dxspider-support] MySQL Help</font>
<div> </div>
</div>
<div>
<div style="color:#000; background-color:#fff; font-family:HelveticaNeue-Light,Helvetica Neue Light,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; font-size:16px">
<div id="yui_3_16_0_1_1421746258139_22986" dir="ltr"><span id="yui_3_16_0_1_1421746258139_23195">Hi,</span></div>
<div id="yui_3_16_0_1_1421746258139_22986" dir="ltr"><span id="yui_3_16_0_1_1421746258139_22990">I also tried to set the MySQL DB by enable it in the local/DXVars.pm, I was able to use it.</span></div>
<div id="yui_3_16_0_1_1421746258139_22986" dir="ltr"><span id="yui_3_16_0_1_1421746258139_23041">The main "problem" is that when the Cluster start the first time it will go to create the "spot" table and then to populate it....</span></div>
<div id="yui_3_16_0_1_1421746258139_22986" dir="ltr"><span id="yui_3_16_0_1_1421746258139_23070">Less then 3 months of running Cluster are equivalent about 680000 rows in the DB.... and if you will go to reboot the Cluster, it will try again to populate the
DB (ignoring the duplicates) with a very high CPU utilization.</span></div>
<div id="yui_3_16_0_1_1421746258139_22986" dir="ltr"><span>At moment I'm not more using this way.</span></div>
<div id="yui_3_16_0_1_1421746258139_22986" dir="ltr"><span><br>
</span></div>
<div id="yui_3_16_0_1_1421746258139_22986" dir="ltr"><span id="yui_3_16_0_1_1421746258139_23138">Me and a my friend are working to a small Java software (that runs on all system, it's needed only the Java Virtual Machine) that will automatically populate a
MySQL DB when a spot come, it works but it's still on development.</span></div>
<div id="yui_3_16_0_1_1421746258139_22986" dir="ltr"><span><br>
</span></div>
<div id="yui_3_16_0_1_1421746258139_22986" dir="ltr"><span id="yui_3_16_0_1_1421746258139_23143">As starts see here: <a href="http://www.iz8mbw.net/dx-cluster/" id="yui_3_16_0_1_1421746258139_23165">IZ8MBW Website - IZ8MBW-6 DX Cluster Spots</a></span></div>
<div id="enhancrCard_0" class="link-enhancr-attachment link-enhancr-element" style="width:450px; font-family:'Georgia','Times','Times New Roman','serif'; margin-top:5px; margin-bottom:5px; background-color:#ffffff">
<table class="link-enhancr-element" id="yui_3_16_0_1_1421746258139_23193" style="width:450px; height:170px; position:relative; display:block" border="0" cellpadding="0" cellspacing="0">
<tbody id="yui_3_16_0_1_1421746258139_23192">
<tr class="link-enhancr-element">
<td class="link-enhancr-element" colspan="8" style="height:1px; background-color:#e5e5e5; font-size:1px; border-collapse:collapse">
<div class="link-enhancr-element" style="height:1px; background-color:#e5e5e5; font-size:1px; line-height:0px">
</div>
</td>
</tr>
<tr class="link-enhancr-element">
<td rowspan="5" class="link-enhancr-element" style="width:1px; background-color:#e5e5e5; font-size:1pt; border-collapse:collapse">
<div class="link-enhancr-element" style="width:1px; background-color:#e5e5e5; font-size:1pt">
</div>
</td>
<td class="link-enhancr-element" rowspan="5" style="vertical-align:middle; width:168px; height:168px; background-color:#000000; border-collapse:collapse">
<div class="link-enhancr-element" style="width:168px" align="center"><a href="http://www.iz8mbw.net/dx-cluster/" class="link-enhancr-card-urlWrapper link-enhancr-element" style="text-decoration:none!important; color:#000000!important"><img alt="image" class="link-enhancr-thumbnail-image link-enhancr-element" style="display: block; margin: auto; -moz-user-select: none;" height="109" width="168" src="http://www.iz8mbw.net/img/qsl_iz8mbw.jpg"></a></div>
</td>
<td rowspan="5" class="link-enhancr-element" style="width:1px; background-color:#e5e5e5; font-size:0pt; border-collapse:collapse">
<div class="link-enhancr-element" style="width:1px; background-color:#e5e5e5; font-size:1pt">
</div>
</td>
<td rowspan="5" class="link-enhancr-element" style="width:14px; background-color:#ffffff; font-size:0pt; border-collapse:collapse">
<div class="link-enhancr-element" style="width:14px; background-color:#ffffff; font-size:14pt">
</div>
</td>
<td colspan="2" class="link-enhancr-element" style="height:6px; background-color:#ffffff; font-size:0pt; border-collapse:collapse">
<div class="link-enhancr-element" style="height:6px; background-color:#ffffff; font-size:6pt">
</div>
</td>
<td rowspan="5" class="link-enhancr-element" style="width:20px; background-color:#ffffff; font-size:0pt; border-collapse:collapse">
<div class="link-enhancr-element" style="width:20px; background-color:#ffffff; font-size:20pt">
</div>
</td>
<td class="link-enhancr-element" rowspan="5" style="width:1px; background-color:#e5e5e5; font-size:1pt; border-collapse:collapse" width="1">
<div class="link-enhancr-element" style="width:1px; background-color:#e5e5e5; font-size:1pt">
</div>
</td>
</tr>
<tr id="yui_3_16_0_1_1421746258139_23191">
<td class="link-enhancr-element" colspan="2" id="yui_3_16_0_1_1421746258139_23190" style="width:100%; vertical-align:middle; font-family:'Georgia','Times','Times New Roman','serif'">
<div class="link-enhancr-text-part link-enhancr-element" id="yui_3_16_0_1_1421746258139_23189" style="line-height:16.5px; background-color:#ffffff; height:135px; width:245px">
<div class="link-enhancr-element" id="yui_3_16_0_1_1421746258139_23188" style="word-wrap:break-word; word-break:break-all">
<span class="link-enhancr-element icon icon-shrink link-enhancr-toggle"></span><span class="link-enhancr-element icon icon-close link-enhancr-delete"></span><a href="http://www.iz8mbw.net/dx-cluster/" class="link-enhancr-card-urlWrapper link-enhancr-element" id="yui_3_16_0_1_1421746258139_23187" style="text-decoration:none!important; color:#000000!important; line-height:100%; font-size:18px; display:block"><span class="link-enhancr-element link-enhancr-card-title" id="yui_3_16_0_1_1421746258139_23186" style="margin:0; font-weight:normal; margin-bottom:3px; font-size:18px; line-height:21px; max-height:43px; color:#000000; overflow:hidden!important; display:inline-block">IZ8MBW
Website - IZ8MBW-6 DX Cluster Spots</span></a>
<div class="link-enhancr-card-description link-enhancr-element" style="font-size:13px; line-height:20px; color:#999999; max-height:81px; font-family:'Georgia','Times','Times New Roman','serif'; overflow:hidden">
IZ8MBW-6 DX Cluster Web Interface</div>
</div>
</div>
</td>
</tr>
<tr>
<td colspan="2" class="link-enhancr-element" style="height:4px; background-color:#ffffff; font-size:0pt; border-collapse:collapse">
<div class="link-enhancr-element" style="height:4px; background-color:#ffffff; font-size:4pt">
</div>
</td>
</tr>
<tr>
<td class="link-enhancr-element" style="vertical-align:middle; font-family:'Arial','Helvetica Neue','Helvetica','sans-serif'">
<div class="link-enhancr-element" style="font-size:0pt"><a href="http://www.iz8mbw.net/dx-cluster/" class="link-enhancr-card-url link-enhancr-element" target="_blank" style="color:black; text-decoration:none!important"><span class="link-enhancr-element link-enhancr-view-on" id="yui_3_16_0_1_1421746258139_23183" style="display:inline-block; line-height:11px; max-width:145px; min-width:85px; overflow:hidden; max-height:13px; word-break:break-all"><span class="link-enhancr-element link-enhancr-mobile-no-resize" style="vertical-align:middle; font-size:9px; line-height:11px; color:#999999">Visualizza
su <span class="link-enhancr-view-on-domain" style="font-weight:bold">www.iz8mbw.net</span></span></span></a></div>
</td>
<td class="link-enhancr-element" style="vertical-align:middle; width:100px; font-family:'Arial','Helvetica Neue','Helvetica','sans-serif'">
<div class="link-enhancr-element link-enhancr-preview-wrapper" style="max-width:100px; min-width:80px; overflow:hidden; text-align:right; line-height:11px; max-height:13px; font-size:0pt">
<span class="link-enhancr-element link-enhancr-preview-by link-enhancr-mobile-no-resize" style="vertical-align:middle; font-size:9px; line-height:11px; color:#999999">Anteprima per Yahoo</span></div>
</td>
</tr>
<tr>
<td colspan="2" class="link-enhancr-element" style="height:9px; background-color:#ffffff; font-size:0pt; border-collapse:collapse">
<div class="link-enhancr-element" style="height:9px; background-color:#ffffff; font-size:9pt">
</div>
</td>
</tr>
<tr class="link-enhancr-element">
<td class="link-enhancr-element" colspan="8" style="height:1px; background-color:#e5e5e5; font-size:1px; border-collapse:collapse">
<div class="link-enhancr-element" style="height:1px; background-color:#e5e5e5; font-size:1px; line-height:0px">
</div>
</td>
</tr>
</tbody>
</table>
</div>
<div id="yui_3_16_0_1_1421746258139_22986" dir="ltr"><span><br>
</span></div>
<div id="yui_3_16_0_1_1421746258139_22986" dir="ltr"><span id="yui_3_16_0_1_1421746258139_23168">The real-time spot page (the web page take the Spots from my MySQL Database) are automatically update.</span></div>
<div id="yui_3_16_0_1_1421746258139_22986" dir="ltr"><span><br>
</span></div>
<div id="yui_3_16_0_1_1421746258139_22986" dir="ltr"> <br>
</div>
<div class="signature" id="yui_3_16_0_1_1421746258139_23009">
<div id="yui_3_16_0_1_1421746258139_23011">73</div>
<div id="yui_3_16_0_1_1421746258139_23034">Fabio, IZ8MBW</div>
<div id="yui_3_16_0_1_1421746258139_23008">www.iz8mbw.net</div>
<div id="yui_3_16_0_1_1421746258139_23032"><br>
</div>
</div>
<br>
<blockquote id="yui_3_16_0_1_1421746258139_22995" style="border-left:2px solid rgb(16,16,255); margin-left:5px; margin-top:5px; padding-left:5px">
<div id="yui_3_16_0_1_1421746258139_22994" style="font-family:HelveticaNeue-Light,Helvetica Neue Light,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; font-size:16px">
<div id="yui_3_16_0_1_1421746258139_22993" style="font-family:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; font-size:16px">
<div dir="ltr" id="yui_3_16_0_1_1421746258139_23004">
<hr size="1">
<font id="yui_3_16_0_1_1421746258139_23006" size="2" face="Arial"><b><span style="font-weight:bold">Da:</span></b> Keith Le Boutillier <KeithL@lebs.org.uk><br>
<b><span style="font-weight:bold">A:</span></b> "dxspider-support@dxcluster.org" <dxspider-support@dxcluster.org>
<br>
<b><span style="font-weight:bold">Inviato:</span></b> Domenica 11 Gennaio 2015 10:47<br>
<b><span style="font-weight:bold">Oggetto:</span></b> [Dxspider-support] MySQL Help<br>
</font></div>
<div class="y_msg_container" id="yui_3_16_0_1_1421746258139_22992"><br>
<div id="yiv3029668314"><style>
<!--
#yiv3029668314 _filtered #yiv3029668314
{font-family:Calibri}
_filtered #yiv3029668314
{font-family:Tahoma}
#yiv3029668314 #yiv3029668314 p.yiv3029668314MsoNormal, #yiv3029668314 li.yiv3029668314MsoNormal, #yiv3029668314 div.yiv3029668314MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
#yiv3029668314 a:link, #yiv3029668314 span.yiv3029668314MsoHyperlink
{color:blue;
text-decoration:underline}
#yiv3029668314 a:visited, #yiv3029668314 span.yiv3029668314MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
#yiv3029668314 p.yiv3029668314MsoAcetate, #yiv3029668314 li.yiv3029668314MsoAcetate, #yiv3029668314 div.yiv3029668314MsoAcetate
{margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif"}
#yiv3029668314 span.yiv3029668314EmailStyle17
{font-family:"Calibri","sans-serif";
color:windowtext}
#yiv3029668314 span.yiv3029668314BalloonTextChar
{font-family:"Tahoma","sans-serif"}
#yiv3029668314 .yiv3029668314MsoChpDefault
{font-family:"Calibri","sans-serif"}
_filtered #yiv3029668314
{margin:72.0pt 72.0pt 72.0pt 72.0pt}
-->
</style>
<div id="yui_3_16_0_1_1421746258139_22999">
<div class="yiv3029668314WordSection1" id="yui_3_16_0_1_1421746258139_22998">
<div class="yiv3029668314MsoNormal"> </div>
<div class="yiv3029668314MsoNormal">HI </div>
<div class="yiv3029668314MsoNormal"> </div>
<div class="yiv3029668314MsoNormal" id="yui_3_16_0_1_1421746258139_23014">I am trying to get spot data into a MySQL database but I am struggling and can’t seem to find much information on this subject.</div>
<div class="yiv3029668314MsoNormal">I Have set the parameters at the end of the Dvars file but nothing is going into the SQL table.</div>
<div class="yiv3029668314MsoNormal"> </div>
<div class="yiv3029668314MsoNormal" id="yui_3_16_0_1_1421746258139_23002">Has anybody got this to work and if so how.</div>
<div class="yiv3029668314MsoNormal"> </div>
<div class="yiv3029668314MsoNormal">I am a novice at this so some help and maybe a sample file if possible.</div>
<div class="yiv3029668314MsoNormal"> </div>
<div class="yiv3029668314MsoNormal" id="yui_3_16_0_1_1421746258139_23028">Many thanks</div>
<div class="yiv3029668314MsoNormal" id="yui_3_16_0_1_1421746258139_22997"> </div>
<div class="yiv3029668314MsoNormal">73 Keith GU6EFB sysop GB7DXG-1 </div>
</div>
<img style="-moz-user-select: none;" height="1" width="1" src="http://mandrillapp.com/track/open.php?u=30171177&id=e0570703686c409a9ef6ec93c9f96f8c"></div>
</div>
<br>
_______________________________________________<br>
Dxspider-support mailing list<br>
<a href="mailto:Dxspider-support@dxcluster.org">Dxspider-support@dxcluster.org</a><br>
<a href="http://mailman.tobit.co.uk/mailman/listinfo/dxspider-support" target="_blank" id="yui_3_16_0_1_1421746258139_23016">http://mailman.tobit.co.uk/mailman/listinfo/dxspider-support</a><br>
<br>
<br>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</body>
</html>