2.3.1 MySQL Installation Layout on Microsoft Windows

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 2.4 Installation Layout for Windows Using MySQL 5.1.23 and Earlier

DirectoryContents of Directory
binClient programs and the mysqld server
dataLog files, databases
examplesExample programs and scripts
includeInclude (header) files
libLibraries
scriptsUtility scripts
shareMiscellaneous 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 2.5 Installation Layout for Microsoft Windows using MySQL 5.1.24 and later

DirectoryContents of DirectoryNotes
binClient 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
examplesExample programs and scripts 
includeInclude (header) files 
libLibraries 
scriptsUtility scripts 
shareMiscellaneous support files, including error messages, character set files, sample configuration files, SQL for database installation