MySQL Manual
2 MySQL Installation
- 2.2 General Installation Issues
- 2.2.1 How to Get MySQL
- 2.2.2 Verifying Package Integrity Using
MD5 ChecksumsorGnuPG - 2.2.5 Operating Systems Supported by MySQL
- 2.2.6 Which MySQL Version to Use
- 2.2.7 Installation Layouts
- 2.2.8 How and When Updates Are Released
- 2.2.9 Release Philosophy - No Known Bugs in Releases
- 2.2.10 MySQL Binaries Compiled by MySQL AB
- 2.2.11 Installing a MySQL Binary Distribution
2.2.7 Installation Layouts
This section describes the default layout of the directories created by installing binary and source distributions.
A binary distribution is installed by unpacking it at the installation location you choose (typically `/usr/local/mysql') and creates the following directories in that location:
| Directory | Contents of directory |
| `bin' | Client programs and the mysqld server
|
| `data' | Log files, databases |
| `include' | Include (header) files |
| `lib' | Libraries |
| `scripts' | mysql_install_db
|
| `share/mysql' | Error message files |
| `sql-bench' | Benchmarks |
A source distribution is installed after you configure and compile it. By default, the installation step installs files under `/usr/local', in the following subdirectories:
| Directory | Contents of directory |
| `bin' | Client programs and scripts |
| `include/mysql' | Include (header) files |
| `info' | Documentation in Info format |
| `lib/mysql' | Libraries |
| `libexec' | The mysqld server
|
| `share/mysql' | Error message files |
| `sql-bench' | Benchmarks and crash-me test
|
| `var' | Databases and log files |
Within an installation directory, the layout of a source installation differs from that of a binary installation in the following ways:
-
The
mysqldserver is installed in the `libexec' directory rather than in the `bin' directory. - The data directory is `var' rather than `data'.
-
mysql_install_dbis installed in the `/usr/local/bin' directory rather than in `/usr/local/mysql/scripts'. - The header file and library directories are `include/mysql' and `lib/mysql' rather than `include' and `lib'.
You can create your own binary installation from a compiled source distribution by executing the script `scripts/make_binary_distribution'.
User Comments
| Posted by [name withheld] on Wednesday December 4 2002, @12:51am | [Delete] [Edit] |
Under RedHat 7.x (at least) ISAM files, &c., are kept
in /var/lib/mysql/{DBNAME}
| Posted by Sal Young on Thursday January 30 2003, @9:27pm | [Delete] [Edit] |
I installed MySQL 3.23.48 and the location of 'mysql_install_db' is not in the 'scripts' directory but in the '/usr/bin/' and 'usr/share/doc/packages/mysql/'
Also, the 'mysqld' is in the 'sbin' folder and not in the 'bin' as stated above.
