Storing the mysql data in a different location

2001-08-30 Thread Philip Daggett
Hello everyone!! I am installing the latest rpm for mysql 3-23.41 on a RedHat 7.1 box and want the datadir to be /data/mysql/data. In my /etc/my.cnf file I have the directive: [mysqld] datadir=/data/mysql/data The installation completes but the daemon won't start. I do the mysql_install_db

Re: Storing the mysql data in a different location

2001-08-30 Thread Gerald Clark
Unfortunately, when you moved the directories, you forgot to make mysql the owner of the new directory. chown -R mysql /data/mysql Philip Daggett wrote: Hello everyone!! I am installing the latest rpm for mysql 3-23.41 on a RedHat 7.1 box and want the datadir to be /data/mysql/data. In

Re: Storing the mysql data in a different location

2001-08-30 Thread Philip Daggett
Thanks Gerald!! That did the trick and everything seems to be running perfectly! At 01:59 PM 8/30/2001 -0500, Gerald Clark wrote: Unfortunately, when you moved the directories, you forgot to make mysql the owner of the new directory. chown -R mysql /data/mysql Philip Daggett wrote: Hello