If you leave the parameter innodb_data_home_dir empty, you can specify absolute file paths in the parameter innodb_data_file_path:
innodb_data_home_dir = innodb_data_file_path = /ibdata/ibdata1:988M;/disk2/ibdata2:50M:autoextend See http://www.mysql.com/doc/en/InnoDB_start.html Harmen. Quoting [EMAIL PROTECTED]: > Hi. Anyone know the trick to successfully using a different directory for > database files? > > I've tried changing my.cnf and also using the command line option. When I > run mysqld_safe it says it's using the new directory but then writes "mysqld > ended" and quits. Mysql never comes up. > > I changed owner and group of the new directory and files to be mysql. > > What can be going wrong? It just doesn't seem to work! > > Thanks!! > > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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
