Re: Changing the default MySQL settings

[Mike Hillyer]

You can use --log-bin[=file_name] to set a path for the binary logs.

Within a CREATE TABLE statement use the following options to relocate the data and index information:

DATA DIRECTORY = 'absolute path to directory'
INDEX DIRECTORY = 'absolute path to directory'

See

http://dev.mysql.com/doc/mysql/en/Binary_log.html
http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html

Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: [phone]

Blog: http://www.openwin.org/mike

"The Open Source movement has become a major force across the software industry, and MySQL is the world's most popular open source database."
--Fortune Magazine