Re: Updating Mysql database from a remote computer

The database is created using a Windows software (Delphi language) which uses Paradox database. A special module is used to prepare some data from this database for internet. The program uses "libmySQL.dll" and would connect directly to server via a dialup line. Instead 'localhost' it would have the server's IP. It then updates the Mysql database with new data. This Mysql database is then used only for reading and PHP scripts on homepage take care of that. I am just wondering if anyone has ever done this and are there any problems (firewalls...)? Thanks, Marko. ""Beau Lebens"" <b.lebens@smec.curtin.edu.au> je napisal v sporocilo news:EHECLLALKPOMODOAIKCLGEFJCAAA.b.lebens@smec.curtin.edu.au ... > if the computer where the writable copy of the database is stored is > permanently connected to the other one, then you could just create a new > user for that database using mysqls security features which only has access > to read information, no change or delete. > > and yes you can connect using an ip, to any database which allows external > connections (firewalls etc notwithstanding) > > // -----Original Message----- > // From: Marko Lesnik [mailto:gradbiro@siol.net] > // Sent: Monday, 30 April 2001 10:40 PM > // To: php-db@lists.php.net > // Subject: [PHP-DB] Updating Mysql database from a remote computer > // > // > // The database will be created on a local computer and it only > // needs to be > // transferred to the server (it's a read-only database when it's > // on the net). > // The problem is that the database itself isn't located in > // directory, where we > // could access it with Ftp client and simply owerwrite it with the new > // version. > // Is it possible to connect via a IP number instead > // 'localhost' like this: > // mysql_connect("100.10.20.30","username","password") > // and then update record by record. It should be slower but our > // main interest > // is to get the data to server. Are there any free servers where > // this can be > // tested? > // > // Thanks, > // Marko. > // > // > // > // -- > // PHP Database Mailing List (http://www.php.net/) > // To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > // For additional commands, e-mail: php-db-help@lists.php.net > // To contact the list administrators, e-mail: php-list-admin@lists.php.net > // > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >