[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [ic] How to tell IC to use non-local mysql


On Thu, 13 Oct 2005, DB wrote:

I am considering buying a second server to handle the mysql functions
for my IC 5.2 store. How exactly would I tell IC to look on another
server for the mysql database that currently is installed locally?  I
did not see much in the archives as far as specifics - is there a howto?

After you migrate your database to the new server, just change your DSN. That varies by database, but will look something like:

   dbi:mysql:database=yourdbname;host=db.host.name

Your DSN is probably set in catalog.cfg or products/variable.txt.

You'll need to restart Interchange. It's probably a good idea to change your password on the old database or turn off the MySQL server altogether if you can, to make certain you're not accidentally still connecting to it.

Jon

--
Jon Jensen
End Point Corporation
http://www.endpoint.com/
_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.