Configure Options:
The configure script gives a great deal of control over how to configure MySQL distribution. To see list the options supported by configure: shell> ./configure --help Some important options for "configure" command we use in our case: 1. Changing location: Change the installation prefix so that everything is installed under the desired directory rather than the default of `/usr/local/mysql': %configure --prefix=/Path-To-Mysql/mysql 2. To load data from any outside files into mysql database: --enable-local-infile 3. Set mysql default user name as mysql: --with-mysqld-user=mysql 4. Options file my.cnf: Different levels of my.cnf files as my-small.cnf,my-medium.cnf, my-large.cnf and my-huge.cnf depending on how big machine user is using are located in $MYSQL_DIR/share/mysql directory. My.cnf file holds any server-specific default options for the MySQL server. It can be edited by user to set any options for the server.Installing many servers on the same machine
Assume an existing server is configured for the default port number and socket file. Two possible options to use another mysql server on the same machine: 1. Configure the new server with a configure command something like this: %configure --with-tcp-port=port_number \ --with-unix-socket-path=file_name --prefix=/.../.../mysqlXXX Here port_number and file_name should be different from the default port number and socket name and the --prefix value should specify an installation directory different from the one under which the existing MySQL installation is located. Ups tailor mysql takes care of configuring multiple instances mysql server on the same machine with user-defined data directory.Mail comments to:css-dgs@fnal.gov
Last Modified December 19, 2002