MySQL provides a number of preconfigured option files that can
be used as a basis for tuning the MySQL server. Look in your
installation directory for files such as
my-small.cnf,
my-medium.cnf,
my-large.cnf, and
my-huge.cnf, which you can rename and
copy to the appropriate location for use as a base
configuration file. Regarding names and appropriate location,
see the general information provided in
Section 4.3.2, “Using Option Files”. On Windows, those files have a
.ini rather than a
.cnf extension.
User Comments
I recently had to change my configuration
to a "huge configuration". MAKE SURE to back up!
]$ su - root
Password: XXXXXX
]#service mysqld stop
Stopping MySQL: [OK]
]#cp /etc/my.cnf /etc/my.cnf.bkup
]#locate .cnf
]#cp /usr/share/doc/mysql-server-4.1.20/my-huge.cnf /etc/my.cnf
cp: overwrite '/etc/my.cnf'? y
]#service mysqld start
Starting MySQL: [OK]
If you wanted to change back to your original configuration,
it's as simple as this:
]# service mysqld stop
Stopping MySQL: [OK]
]# cp /etc/my.cnf.bkup /etc/my.cnf
cp: overwrite '/etc/my.cnf'? y
]# service mysqld start
Starting MySQL: [OK]
Add your own comment.