For MySQL 5.1 on Windows, the default installation
directory is C:\Program Files\MySQL\MySQL Server
5.1. Some Windows users prefer to install
in C:\mysql, the directory that formerly was
used as the default. However, the layout of the subdirectories
remains the same.
For MySQL 5.1.23 and earlier, all of the files are located within the parent directory, using the structure shown in the following table.
Table 1.1. Installation Layout for Windows Using MySQL 5.1.23 and Earlier
| Directory | Contents of Directory |
|---|---|
bin | Client programs and the mysqld server |
data | Log files, databases |
examples | Example programs and scripts |
include | Include (header) files |
lib | Libraries |
scripts | Utility scripts |
share | Miscellaneous support files, including error messages, character set files, sample configuration files, SQL for database installation |
For MySQL 5.1.24 and later, the default location of data directory was changed. The remainder of the directory structure remains the same.
Table 1.2. Installation Layout for Microsoft Windows using MySQL 5.1.24 and later
| Directory | Contents of Directory | Notes |
|---|---|---|
bin | Client programs and the mysqld server | |
%ALLUSERSPROFILE%\MySQL\MySQL Server
5.1\ | Log files, databases (Windows XP, Windows Server 2003) | The Windows system variable %ALLUSERSPROFILE%
defaults to C:\Documents and Settings\All
Users\Application Data |
%PROGRAMDATA%\MySQL\MySQL Server 5.1\ | Log files, databases (Vista, Windows 7, Windows Server 2008, and newer) | The Windows system variable %PROGRAMDATA% defaults to
C:\ProgramData |
examples | Example programs and scripts | |
include | Include (header) files | |
lib | Libraries | |
scripts | Utility scripts | |
share | Miscellaneous support files, including error messages, character set files, sample configuration files, SQL for database installation |

User Comments
Add your own comment.