We've got mysql 3.23 installed on a redhat system via the rpm's that come with RedHat 8.0. I'd like to change the default data directory so something other than /var/lib/mysql. I know this is supposed to be possible with a start switch of --datadir=/path/to/data but it doesn't seem to work.
It should work.
The startup of mysql uses the /etc/init.d/mysqld script so I suppose I'll need to change something in that and add the switch, I just can't seem to figure out where.
I wouldn't change the script, it'll get overwritten if you upgrade.
You might try editing /etc/my.cnf (create it if it doesn't exist) and add this to it:
[mysqld] datadir=/path/to/data
Alternatively, rename /var/lib/mysql to something else (or remove it....) and recreate /var/lib/mysql as a symlink to where you really want the data directory. Make sure the target of the symlink exists.
Any suggestions?
Thanks,
Jeff
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]