The solution we took was to write a global configuration file and share
connection data as need. This way it only needs to be changed in one place.

Furthermore, if you connect as follows:
dbi:mysql:host=db_01;database=<database_name>

and then on your client machine, either via bind or the /etc/hosts file,
point the "db_01" host name to the IP of your database server. I've been
doing this for some time, works very well.

Hope this helps,

-Bart

-----Original Message-----
From: ari davidow [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2001 3:23 PM
To: [EMAIL PROTECTED]
Subject: binding a domain name to a MySQL instance


Is there any way to bind something other than the hostname to a MySQL
instance?

I'm going to be moving a database from one server to another, and would
like the scripts that reference that data to simply talk to
"db.mydomain.com", rather than have to reconfigure things during launch.
Is this possible?

ari
--

Ari Davidow
Applications Administrator, Web Central
Tufts University

617-627-4291
[EMAIL PROTECTED]

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to