A set of basic questions about mysql

2012-08-04 Thread Rodolfo Aramayo
Dear Ryan,

MacPorts has nine mysql5-related ports:

mysql5 @5.1.63 (databases)
mysql5-devel @5.5.2-m2 (databases)

mysql5-server @5.1.63 (databases)
mysql5-server-devel @5.5.2-m2 (databases)

mysql51 @5.1.63 (databases)
mysql51-server @5.1.63 (databases)

mysql55 @5.5.25 (databases)
mysql55-server @5.5.25 (databases)
and
ocaml-mysql @1.0.4 (databases, devel, ml)

I understand the difference between mysql5 @5.1.63 and mysql5-devel @5.5.2-m2
What is the difference between mysql5 @5.1.63  and mysql5-server @5.1.63?
I am also am not sure I understand the difference between mysql5
@5.1.63, mysql51 @5.1.63 and mysql55 @5.5.25 ?
When does one uses mysql5 versus mysql5-server?

Thanks and keep up the good work

--R
___
macports-users mailing list
macports-users@lists.macosforge.org
http://lists.macosforge.org/mailman/listinfo/macports-users


Re: A set of basic questions about mysql

2012-08-04 Thread Clemens Lang
On Sat, Aug 04, 2012 at 03:32:30PM -0500, Rodolfo Aramayo wrote:
 mysql5 @5.1.63 (databases)
 mysql5-devel @5.5.2-m2 (databases)
 
 mysql5-server @5.1.63 (databases)
 mysql5-server-devel @5.5.2-m2 (databases)

Those were before somebody created versioned ports (i.e. the other
four). They are probably older and don't work with the port select
mechanism.

 mysql51 @5.1.63 (databases)
 mysql51-server @5.1.63 (databases)
 
 mysql55 @5.5.25 (databases)
 mysql55-server @5.5.25 (databases)
 and
 ocaml-mysql @1.0.4 (databases, devel, ml)

ocaml-mysql provides MySQL bindings for the OCaml language.

 I understand the difference between mysql5 @5.1.63 and mysql5-devel @5.5.2-m2
 What is the difference between mysql5 @5.1.63  and mysql5-server @5.1.63?

The non-server ports install all binaries required by mysql. The -server
ports install a startup item (i.e., a launchd plist) and create a few
directories only needed when running the mysql server.

HTH,
-- 
Clemens Lang

___
macports-users mailing list
macports-users@lists.macosforge.org
http://lists.macosforge.org/mailman/listinfo/macports-users


Re: A set of basic questions about mysql

2012-08-04 Thread Rodolfo Aramayo
Thanks Clemens
But when one does want to run a mysql server versus a non-server?
And why do other MacPorts ports are installing MySQL ports that do not
work with the port select mechanism? Why use those ports at all?
Thanks

--R

On Sat, Aug 4, 2012 at 3:37 PM, Clemens Lang c...@macports.org wrote:
 On Sat, Aug 04, 2012 at 03:32:30PM -0500, Rodolfo Aramayo wrote:
 mysql5 @5.1.63 (databases)
 mysql5-devel @5.5.2-m2 (databases)

 mysql5-server @5.1.63 (databases)
 mysql5-server-devel @5.5.2-m2 (databases)

 Those were before somebody created versioned ports (i.e. the other
 four). They are probably older and don't work with the port select
 mechanism.

 mysql51 @5.1.63 (databases)
 mysql51-server @5.1.63 (databases)

 mysql55 @5.5.25 (databases)
 mysql55-server @5.5.25 (databases)
 and
 ocaml-mysql @1.0.4 (databases, devel, ml)

 ocaml-mysql provides MySQL bindings for the OCaml language.

 I understand the difference between mysql5 @5.1.63 and mysql5-devel @5.5.2-m2
 What is the difference between mysql5 @5.1.63  and mysql5-server @5.1.63?

 The non-server ports install all binaries required by mysql. The -server
 ports install a startup item (i.e., a launchd plist) and create a few
 directories only needed when running the mysql server.

 HTH,
 --
 Clemens Lang

___
macports-users mailing list
macports-users@lists.macosforge.org
http://lists.macosforge.org/mailman/listinfo/macports-users


Re: A set of basic questions about mysql

2012-08-04 Thread Clemens Lang
On Sat, Aug 04, 2012 at 03:49:42PM -0500, Rodolfo Aramayo wrote:
 But when one does want to run a mysql server versus a non-server?

Suppose you only need, e.g., mysqldump or libmysql. Those are in the
mysql port, but to use those you don't need to install mysql-server
(because the server you use them for might be remote).

-- 
Clemens Lang

___
macports-users mailing list
macports-users@lists.macosforge.org
http://lists.macosforge.org/mailman/listinfo/macports-users


Re: A set of basic questions about mysql

2012-08-04 Thread Brandon Allbery
On Sat, Aug 4, 2012 at 4:49 PM, Rodolfo Aramayo raram...@gmail.com wrote:

 But when one does want to run a mysql server versus a non-server?


Many programs want the MySQL client libraries but don't actually require a
running server on the local machine (or even at all for common usages), so
you would install without the server part.  Alternately you might be
running a web application where the database is on another machine
(possibly along with memcached or similar) to distribute the load or for
failover purposes.


 And why do other MacPorts ports are installing MySQL ports that do not
 work with the port select mechanism? Why use those ports at all?


Because the port select mechanism is still relatively new, and it takes
time for things to be migrated to use it.  And in the meantime people need
to be able to get work done.

-- 
brandon s allbery  allber...@gmail.com
wandering unix systems administrator (available) (412) 475-9364 vm/sms
___
macports-users mailing list
macports-users@lists.macosforge.org
http://lists.macosforge.org/mailman/listinfo/macports-users