James, I recommend you use the binary packages on the MySQL site. If anything you're going to have a much more painful time attempting to compile MySQL yourself getting all the options right and linking against the correct things. The MySQL team makes exceptional packages and have done a lot of the hard work for you (which is why they provide binaries).
The location of your config file will be /etc/my.cnf .... you want to change the "datadir" option. As a general rule of thumb with MySQL, use the binaries provided on the website unless you have a good reason not to. HTH, Lachlan -----Original Message----- From: James Weisensee [mailto:[EMAIL PROTECTED] Sent: Tuesday, 10 August 2004 2:27 PM To: mysqllist Subject: MySQL RPM or Source ? Hello, I am installing a LAMP setup. I've installed MySQL on AIX, but that was binary (recommended for AIX by MySQL site) and all I did was gunzip in the directory I wanted MySQL installed in and soft linked the that with '/usr/local/mysql'. I've just installed Apache2 and I am not sure if the order I do PHP and MySQL matters. My question is, should I use the RPM or build from source for MySQL. Am I losing anything by going with RPM as opposed to installing MySQL with ./configure options? It doesn't appear that I have to link to any MySQL source with PHP, just use the --with-mysql switch, so RPM is ok with me, but If I go with RPM, where are the config files to tell MySQL that I want the data to be in a specific directory? If I go with source, are there any configure options that I want to make sure I have? What are your thoughts/experience? Thanks in advance, James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]