I also found out that mysqld --help provides a whole lot more of the information that I was looking for than just mysql --help!
whoops > -----Original Message----- > From: Paul DuBois [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 11, 2003 5:15 PM > To: Chris McKeever; [EMAIL PROTECTED] > Subject: Re: configuration questions - newbie getting up-to-speed > > > At 17:04 -0500 6/11/03, Chris McKeever wrote: > >Sorry from the low-level posts, but I am trying to get my > grips around some > >simple set-up configuration. > > > >- What exactly does basedir do? It defauts to / which to me > means it is at > >the 'base' of the filesystem. Why/when would you need to > change it (since > >you would only be moving it up levels - or down depending > how you look at > >it). > > It's the base (root) directory of your MySQL installation. If it's > defaulting to / on your system, I'd guess that you have a system > that doesn't place all the MySQL-related files under a single > directory. > Another typical value is /usr/local/mysql, or C:\mysql on Windows. > > I wouldn't worry about changing it if you have no particular > reason to. > > > > >- What does server-specific options mean (as in placing the > my.cnf for > >server-specific)? Isnt mysql running on the server itself > and the global > >my.cnf handles that? Or is this for something in regards to multiple > >daemons running? > > Yes, multiple servers. You can run several servers on a given machine > (I have several dozen different ones on one of my systems), > and you need > to supply server-specific values for several of the options > to keep them > from interfering with each other. For example, the TCP/IP port they > listen to must be different for each server. > > > > >- Am I correct ot assume the MYSQL 4.0 default to using > innodb data files? > > Yes. See: > > http://www.mysql.com/doc/en/Nutshell_4.0_features.html > > > > >- Is there documentation (or the ability) to specifiy different data > >directories for different database systems. > > Huh? > > > > >I found a nice howto that is pretty low-level: > >http://astro.temple.edu/~kumar/MySQLRepPro/Installing_MySQL.htm > >which got me going with a few questions, but the couple > questions I can't > >figure out. > > > >Once again, if anyone can point to some other online howto's > and basic > >administration, that would be great > > > >Thanks > > > >Chris > > > -- > 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]
