MT4 Connection to MySQL Server at Webhoster

 

Hello,

i have a MySQL Database at my Wehoster and i want to send Data from my Metatrader to that Mysql Database but because of security issues the Webhoster does not allow access from outside to the Mysql Databse.

I wanted to send in real time my Trades into the Mysql Database, can anybody say me how i can slove this?

 
This is not an mql4 question. Try getting support from host.
 
PlanandTrade:

Hello,

i have a MySQL Database at my Wehoster and i want to send Data from my Metatrader to that Mysql Database but because of security issues the Webhoster does not allow access from outside to the Mysql Databse.

I wanted to send in real time my Trades into the Mysql Database, can anybody say me how i can slove this?

Sorry but you must be misunderstanding . . .  what is the point of any database that can only be accessed by the database ?  talk to your Host again . . .
 
I did think some people here can give me a tip how i can send with another technik or a trick the data to my MySQL Database, because the webhoster does not allow it, to access from outside.
 
PlanandTrade:
I did think some people here can give me a tip how i can send with another technik or a trick the data to my MySQL Database, because the webhoster does not allow it, to access from outside.
Ah I see from outside of the Hosts network/Webserver . . . is your Hosting using cPanel ? 
 
PlanandTrade:
I did think some people here can give me a tip how i can send with another technik or a trick the data to my MySQL Database, because the webhoster does not allow it, to access from outside.
  • With a php script located on the server. Then you have to use a DLL to call your script.
  • Another possibility is to use FTP, to send data on your server and then process it locally with a php script or others available language.
 
RaptorUK:
Ah I see from outside of the Hosts network/Webserver . . . is your Hosting using cPanel ? 


i dont no i am using at moment just a free webspace but my old webhoster did offer somethink like Confixx that is simular think  like cPanel. Why you ask, have you a idea?
 
angevoyageur:
  • With a php script located on the server. Then you have to use a DLL to call your script.
  • Another possibility is to use FTP, to send data on your server and then process it locally with a php script or others available language.

That idea is good, the php script must be call every second to send the data to Mysql database, i dont know what for DLL programm is allowed to use for webhosting,do you know maybe a tutorial where such thinks is explained?
 
PlanandTrade:

That idea is good, the php script must be call every second to send the data to Mysql database, i dont know what for DLL programm is allowed to use for webhosting,do you know maybe a tutorial where such thinks is explained?
The DLL (Windows API) is needed to call your script with http from your MT4 client. There is no native function for that in mql4. Search the site for examples (keyword http).
 
PlanandTrade:

i dont no i am using at moment just a free webspace but my old webhoster did offer somethink like Confixx that is simular think  like cPanel. Why you ask, have you a idea?
The Host can configure cPanel to provide remote MySQL functionality   http://docs.cpanel.net/twiki/bin/view/11_30/CpanelDocs/RemoteMySQL 
 
angevoyageur:
The DLL (Windows API) is needed to call your script with http from your MT4 client. There is no native function for that in mql4. Search the site for examples (keyword http).

thank you for the info, i think that can be u solution for me.


Have somebody also a idea how i can let other people copy my tradeing then, if i let for example 100 customer to read from my webserver every tick they send a new reading request to my server that can coast much power a better way would be to send myself to the customers signals when i have new signals, but how with wich technic can i codeing this at best?

Reason: