Ryan, You suggested that I might have a rogue my.cnf file somewhere. I can find only one my.cnf on my Mac. The Finder says it is a "Plain text" file, and I opened it with TextEdit:
# /etc/mysql/my.cnf: The global mysql configuration file. # This file can be simultaneously placed in three places: # 1. /etc/mysql/my.cnf to set global options. # 2. /var/lib/mysql/my.cnf to set server-specific options. # 3. ~/.my.cnf to set user-specific options. # # One can use all long options that the program supports. # Run the program with --help to get a list of them. # # The following values assume you have at least 32M RAM! [client] #password = my_password port = 3306 socket = __PREFIX/var/run/mysqld/mysqld.sock [safe_mysqld] err-log = __PREFIX/var/log/mysql/mysql.err pid-file = __PREFIX/var/run/mysqld/mysqld.pid socket = __PREFIX/var/run/mysqld/mysqld.sock [mysqld_safe] err-log = __PREFIX/var/log/mysql/mysql.err pid-file = __PREFIX/var/run/mysqld/mysqld.pid socket = __PREFIX/var/run/mysqld/mysqld.sock [mysqld] #skip-networking 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 = __PREFIX datadir = __PREFIX/var/db/mysql tmpdir = /tmp language = __PREFIX/share/mysql/english skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K [mysqldump] quick set-variable = max_allowed_packet=1M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] set-variable = key_buffer=16 The location is /opt/local/var/macports/sources/rsync.macports.org/release/ports/databases/mysql4/files/. How do I determine if it is a rogue file? On March 10, I ran "port contents mysql5," and I sent the results to Bradley with a copy to you. I don't see a my.cnf file in the contents of my mysql5 port. Is that a problem? Thanks in advance for your help. David On Mar 10, 2011, at 12:04 AM, Ryan Schmidt wrote: On Mar 9, 2011, at 12:54, David Gentry wrote: > I did not mean to imply that the MacPorts file, mysqld, is corrupt. Somehow > it is getting corrupted on my system, and I intend to find out how. I did > not know that every system will treat mysqld differently. That is good to > know. However, that information just adds to the mystery. My system is a > bread and butter Mac OS X version 10.6.6. Not *every* system. But it differs based on OS version and processor architecture, at least. So if I send you the mysqld generated on my 64-bit Intel machine running Snow Leopard, that won't work for you if your Snow Leopard machine only has a 32-bit processor. It probably also won't work if you're running Leopard or Tiger, or a PowerPC processor. > The reason I asked for the file contents, such as a text file, is that if I > get the executable file my system might mess it up. mysqld is not a text file. It is a compiled executable program. > I will continue to pursue other avenues to solve the mystery of why my system > corrupts the MacPorts mysqld. As I have more information, I will pass it on > to the email list. It might help someone. I doubt your mysqld is corrupt. Assuming you are following the wiki instructions correctly, and they are not working for you, I believe you have files on your system that are interfering with the normal way of setting up MacPorts MySQL. Perhaps a rogue my.cnf somewhere containing references to the files in /usr/local/mysql* that you already deleted. _______________________________________________ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users