problems running mysql_install_db5

[David Gentry]

Bradley,

Concerning this command and output:

$ /opt/local/lib/mysql5/bin/my_print_defaults client mysql mysqld
--port=3306
--socket=__PREFIX/var/run/mysqld/mysqld.sock
--skip-innodb
--user=mysql
--pid-file=__PREFIX/var/run/mysqld/mysqld.pid
--socket=__PREFIX/var/run/mysqld/mysqld.sock
--port=3306
--log=__PREFIX/var/log/mysql/mysql.log
--basedir=/usr/local/mysql-5.5.6-rc-osx10.6-x86_64
--datadir=/usr/local/mysql-5.5.6-rc-osx10.6-x86_64/data
--language=__PREFIX/share/mysql/english
--skip-locking
--set-variable=key_buffer=16M
--set-variable=max_allowed_packet=1M
--set-variable=thread_stack=128K
--enable-named-pipe
--connect_timeout=3

You wrote:

> Did you replace the actual "prefix" with "__PREFIX" or is that the  
> unaltered output?
> "__PREFIX" is wrong. These paths should have the same prefix as your  
> MacPorts install.
> Example:
> __PREFIX/var/run/mysqld/mysqld.sock
> should be
> /opt/local/var/run/mysqld/mysqld.sock

That is unaltered output.

Concerning this command and output:

$ ls -la /etc/my.cnf/etc/mysql/my.cnf/opt/local/etc/mysql5/my.cnf ~/.my.cnf
ls: /Users/davidgentry/.my.cnf: No such file or directory
ls: /etc/my.cnf/etc/mysql/my.cnf/opt/local/etc/mysql5/my.cnf: Not a directory

You wrote:

> There are spaces missing after each my.cnf. Try this:
> $ /opt/local/lib/mysql5/bin/my_print_defaults | grep my.cnf | xargs ls  
> -l

Sorry I missed the spaces.

$ /opt/local/lib/mysql5/bin/my_print_defaults | grep my.cnf |xargs ls -l
ls: /etc/mysql/my.cnf: No such file or directory
ls: /opt/local/etc/mysql5/my.cnf: No such file or directory
ls: ~/.my.cnf: No such file or directory
-rw-rw-r--  1 davidgentry  admin  1616 Dec 16 21:38 /etc/my.cnf

I am extremely encouraged by your optimism.  I don't want to proceed with the clean-up until I report the above to you.

Please let me know what I should do now.  Is it OK to proceed with the clean-up?

David








-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-users/attachments/20110318/0a6a791b/attachment.html>