RE: [PHP-DB] Updating Mysql database from a remote computer

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 //