Re: Darwinports Apache2/PHP5 & Tiger Mysql??

I'd presume Nat is referring to the location of the MySQL database files.

In a MacPorts MySQL4 install, the default location is
/opt/local/var/db/mysql/

But you can change this by altering the datadir line in my.cnf
/opt/local/etc/mysql4/my.cnf
(the location of my.cnf can vary of course, but this is where I've got mine)

[mysqld]
pid-file        = /opt/local/var/run/mysqld/mysqld.pid
socket          = /opt/local/var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /opt/local
datadir         = /opt/local/var/db/mysql
lower_case_table_names=2

(Similar things apply if MySQL5 is used)

So if Nat has previous MySQL databases created by a MySQL other than 
one made with MacPorts, then he either needs to change the datadir 
used by his MacPorts MySQL, or move those database files to the 
datadir he's currently using.

Does Tiger come with MySQL built-in, or did Nat install a binary 
downloaded from mysql.com?

Mark

--

At 21:08 +0200 29/8/06, Ryan Schmidt wrote:
>On Aug 29, 2006, at 19:12, Nat wrote:
>
>>After using Tiger's built-in Apache, PHP & Mysql for some time, 
>>I've installed Apache2 & PHP5 with Darwinports.  I'm hoping that I 
>>can use them to access the built-in  Mysql databases I've  already 
>>been working with .  But I can't figure out how to see them.  Can 
>>anyone help?
>
>What do you mean "built-in"? What are they built into?
>
>What do you mean "how to see" the MySQL databases? How did you see 
>them before?
>
>You can of course use the MacPorts php5+apache2+mysql5 port to 
>access any MySQL database, regardless if it's being served from a 
>MacPorts-compiled MySQL server or any other, on the same machine as 
>Apache2 or on any other machine, assuming the MySQL server is 
>configured to allow you such access.
>
>What exactly isn't working for you? Are you getting an error 
>message? When you do what? Please tell us exactly what you do, what 
>you expect the result to be, and what actually happens.
>
>_______________________________________________
>Darwinports mailing list
>[email protected]
>http://www.opendarwin.org/mailman/listinfo/darwinports