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

2001-04-30 Thread Marko Lesnik

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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




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

2001-04-30 Thread Beau Lebens

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:[EMAIL PROTECTED]]
// Sent: Monday, 30 April 2001 10:40 PM
// To: [EMAIL PROTECTED]
// 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: [EMAIL PROTECTED]
// For additional commands, e-mail: [EMAIL PROTECTED]
// To contact the list administrators, e-mail: [EMAIL PROTECTED]
//


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]