[Dxspider-support] MySQL Help

[IZ8MBW Fabio]

Hi,I also tried to set the MySQL DB by enable it in the local/DXVars.pm, I was able to use it.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....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.At moment I'm not more using this way.
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.
As starts see here: IZ8MBW Website - IZ8MBW-6 DX Cluster Spots
|   |
|   |  |   |   |   |   |   |
| IZ8MBW Website - IZ8MBW-6 DX Cluster SpotsIZ8MBW-6 DX Cluster Web Interface |
|  |
| Visualizza su www.iz8mbw.net | Anteprima per Yahoo |
|  |
|   |


The real-time spot page (the web page take the Spots from my MySQL Database) are automatically update.
 
73Fabio, IZ8MBWwww.iz8mbw.net

 
      Da: Keith Le Boutillier <KeithL at lebs.org.uk>
 A: "dxspider-support at dxcluster.org" <dxspider-support at dxcluster.org> 
 Inviato: Domenica 11 Gennaio 2015 10:47
 Oggetto: [Dxspider-support] MySQL Help
   
 <!--#yiv3029668314 _filtered #yiv3029668314 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv3029668314 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}#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;}#yiv3029668314 div.yiv3029668314WordSection1 {}-->   HI     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. I Have set the parameters at the end of the Dvars file but nothing is going into the SQL table.    Has anybody got this to work and if so how.    I am a novice at this so some help and maybe a sample file if possible.    Many thanks    73 Keith GU6EFB sysop GB7DXG-1    
_______________________________________________
Dxspider-support mailing list
Dxspider-support at dxcluster.org
http://mailman.tobit.co.uk/mailman/listinfo/dxspider-support


   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.tobit.co.uk/pipermail/dxspider-support/attachments/20150120/3ece83d7/attachment.html>