defaults in MySQL

2003-03-19 Thread Jon Miller
Can someone tell me how do I find the default settings in MySQL.  Mainly
I'm interested in knowing where are the data files stored.  I'm building
a application server (RH7.3) and need to know which partition should be
sized to handle the database.
-- 
Jon Miller [EMAIL PROTECTED]
MMT Networks Pty Ltd



-
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: defaults in MySQL

2003-03-19 Thread Barry Marler
/etc/my.cnf: Global options
DATADIR/my.cnf: Server-specific options
defaults-extra-file: The file specified with --defaults-extra-file=#
~/.my.cnf: User-specific options
By default, data is in /var/lib/mysql.

Jon Miller wrote:
Can someone tell me how do I find the default settings in MySQL.  Mainly
I'm interested in knowing where are the data files stored.  I'm building
a application server (RH7.3) and need to know which partition should be
sized to handle the database.
--
Barry Marler
Plant Genome Mapping Laboratory
University of Georgia
Room 229, CAGT
111 Riverbend Road
Athens, GA 30602
706.583.0164
706.583.8120[fax]
http://www.plantgenome.uga.edu
-
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