AW: PHP Tunnel
sooo... habe es gefunden, getestet und es funzt...
hier die Erklärung aus MySQL-Front:
What is a PHP tunnel and how does it work?
Some ISPs permit access to the MySQL database only from the Web server due to reasons of security. This means MySQL-Front cannot access the database normally (error: Access denied).
This problem can be circumvented with the use of so-called PHP tunnel.
Install the PHP script phpMySQL.php (included with the program) on the Web server. Then, from within the session, select the connection type "PHP tunnel" and specify the respective URL of the PHP script.
MySQL-Front converts the database query into an HTTP request and sends this request to the PHP script on the Web server. (The script can access the database since it is, same as the other scripts, located on the Web server.) The PHP script then converts the reply of the database and sends it as the HTTP result back to MySQL-Front.
Unfortunately, this is somewhat awkward and also significantly slower than any direct access. However, this makes it possible to access the database even if the provider does not permit access any other way.
Since PHP doesn't support to use resources in sessions each single database request opens a new database process and close them after receiving the single response. Because of this by using the PHP Tunnel the database is not be able to remember any session settings like variables, rollback or something like this.
By using the the PHP tunnel the requests will be handled by PHP. PHP has not been designed to handle database connections to a client application (MySQL-Front.exe). Because of this there are limited timeout settings. Since the most ISP uses the default "Safe Mode" of PHP the phpMySQL.php script can't change the timeout setttings.
Maybe the Web server (f. e. Apache) has set a timeout too.
In both cases the PHP tunnel can't handle big database requests.
For normal working there are no problems. But for exporting / transfering big tables maybe the tunnel doesn't work. The bug message "lost connection" shows this problem.
trotzdem danke dir!!
Es gibt drei Möglichkeiten, eine Firma zu ruinieren: mit Frauen, das ist das Angenehmste; mit Spielen, das ist das Schnellste; mit Computern, das ist das Sicherste. Oswald Dreyer-Eimbcke