Storing the mysql data in a different location
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 command and the requisite tables are installed in my new data directory, the message states that it is starting with the data in the new directory, then the server stops and the error message from the error log is : /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) This file in fact exists in the new data directory as well as the /var/lib/mysql directory. Does anyone know how to do this correctly?? Thanks, Phil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Storing the mysql data in a different location
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 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 command and the requisite tables are installed in my new data directory, the message states that it is starting with the data in the new directory, then the server stops and the error message from the error log is : /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) This file in fact exists in the new data directory as well as the /var/lib/mysql directory. Does anyone know how to do this correctly?? Thanks, Phil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Storing the mysql data in a different location
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 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 command and the requisite tables are installed in my new data directory, the message states that it is starting with the data in the new directory, then the server stops and the error message from the error log is : /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) This file in fact exists in the new data directory as well as the /var/lib/mysql directory. Does anyone know how to do this correctly?? Thanks, Phil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php