Dynamic IP Issue
Usually, this does not cause a problem.
Occasionally, though, the ip will change while heidisql is just part-way through exporting posts.
Since, my forum is, relatively large, busy, and, so, slow to export, there is usually no way for me to catch onto the problem until after hours have passed and I get tired of waiting for heidisql to finish.
So, to save me from needlessly waiting, how about making heidisql occasionally try re-submitting my ip to the server? If the server rejects the ip, then heidisql can display a warning sign and alert me to the fact that exporting has stopped.
I don't get the problem exactly - in my understanding, your computer will be offline for some seconds while your provider forces you to get a new IP address. Then, HeidiSQL will of course have killed any running connection, but then reconnect when needed.
When it happens, heidisql appears to just hang and this creates the false image that it is just waiting for info, from the server.
So, I'm wondering if there is a way to alert the user, during export, that heidisql has stopped.
2. When the ip changes and Heidisql is started up, for the first time, a SQL Error (1130) message appears.
My server will not allow a computer to connect if that computer is without the proper ip.
So, when my ip changes from what the server has on record, then my Heidisql is prevented from accessing the server and exporting further from it; my server does not recognize Heidisql's reconnect attempts if Heidisql is coming from a computer that has a new ip. Yet, unlike the initial start up case, above, there is no error message - just a hanging Heidisql.
Hence, my request for a warning, from Heidisql.
I wish that http://www.dyndns.com/ would just spell out what you said in a straight-forward manner, though, because I haven't got a lot of time to read all the stuff, at their website.
But, just based on my initial investigation, http://www.dyndns.com/ does not sound like something that would work, for my situation.
Thanks, however, for the suggestion!
Please login to leave a reply, or register at first.