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]
