Tips on MySQL

Readings and References

• MySQL 5.0 : server option and variable reference

Notable Options

MySQL 5.0

Maybe the most common options to customize are storage engine, character set, location of data and log files with your MySQL instance.

You can change location of your data files using datadir option. But you should copy the entire contents of the data directory under the installation of your MySQL to the new location.
Default storage engine and character set for your schemas and tables can be specified using default-storage-engine and character-set-server options.
In case of InnoDB, you can specifiy the location of log files and their archives using innodb_log_group_home_dir and innodb_log_arch_dir options.

datadir = D:\home\mysql\5.0\data/
default-storage-engine = innodb
lower_case_table_names = 2

character-set-server = utf8
character-set-filesystem = utf8
collation-server = utf8_general_ci

innodb_data_file_path = ibdata1:30M:autoextend
innodb_log_group_home_dir = D:\home\mysql\5.0\log/
innodb_log_arch_dir = D:\home\mysql\5.0\log/