/var/lib/mysql is the standard loation for the data_file_path, the data directory. change it in my.cnf.
var/log is the default location for log files, also changeable in the config file. Walter OlinData: Professional services for MySQL Support * Consulting * Administration http://www.olindata.com On Wed, Feb 11, 2009 at 5:35 PM, csego...@gmail.com <csego...@gmail.com> wrote: > I am trying to install mysql in a non-standard directory - specifically > /app/mysql > > Subsequently, I ran the following configure command: > > ./configure --prefix=/app/mysql --with-plugins=innobase,myisam > > There were no problems with the compile, but mysql failed to start. > Furthermore, the following output was produced in the nohup.out file > > -bash-3.2$ cat nohup.out > 090211 09:40:35 mysqld_safe Logging to '/var/log/mysqld.log'. > mkdir: cannot create directory `/var/lib/mysql': Permission denied > chown: cannot access `/var/lib/mysql': No such file or directory > chmod: cannot access `/var/lib/mysql': No such file or directory > 090211 09:40:35 mysqld_safe Starting mysqld daemon with databases from > /var/lib/mysql > /app/mysql/bin/mysqld_safe: line 96: /var/log/mysqld.log: Permission denied > /app/mysql/bin/mysqld_safe: line 133: /var/log/mysqld.log: Permission denied > 090211 09:40:35 mysqld_safe mysqld from pid file > /var/run/mysqld/mysqld.pid ended > /app/mysql/bin/mysqld_safe: line 96: /var/log/mysqld.log: Permission denied > > For some reason, the mysql install is looking to /var even though I > specificied /app/mysql in the compile. > > How do I fix this? > > Thanks! > Colin > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org