Oracle 5.0, Справочное руководство

Страница: 61 / 3232

41
Chapter 2. Installing and Upgrading MySQL
Table of Contents
2.1. MySQL Installation Overview ................................................................................................ 42
2.2. Determining your current MySQL version .............................................................................. 42
2.3. Notes for MySQL Enterprise Server ...................................................................................... 43
2.3.1. Enterprise Server Distribution Types ........................................................................... 44
2.3.2. Upgrading MySQL Enterprise Server .......................................................................... 44
2.4. Notes for MySQL Community Server .................................................................................... 44
2.4.1. Overview of MySQL Community Server Installation ..................................................... 44
2.4.2. Operating Systems Supported by MySQL Community Server ....................................... 45
2.4.3. Choosing Which MySQL Distribution to Install ............................................................. 46
2.5. How to Get MySQL .............................................................................................................. 50
2.6. Verifying Package Integrity Using MD5 Checksums or
GnuPG
................................................ 50
2.6.1. Verifying the MD5 Checksum ..................................................................................... 50
2.6.2. Signature Checking Using
GnuPG
............................................................................... 51
2.6.3. Signature Checking Using
Gpg4win
for Windows ....................................................... 53
2.6.4. Signature Checking Using
RPM
................................................................................... 57
2.7. Installation Layouts ............................................................................................................... 58
2.8. Compiler-Specific Build Characteristics .................................................................................. 59
2.9. Standard MySQL Installation from a Binary Distribution .......................................................... 60
2.10. Installing MySQL on Microsoft Windows .............................................................................. 60
2.10.1. Choosing An Installation Package ............................................................................ 61
2.10.2. Installing MySQL on Microsoft Windows Using an MSI Package ................................. 62
2.10.3. MySQL Server Instance Configuration Wizard ........................................................... 67
2.10.4. Installing MySQL on Microsoft Windows Using a
noinstall
Zip Archive ................... 79
2.10.5. Troubleshooting a MySQL Installation Under Windows .............................................. 86
2.10.6. Upgrading MySQL on Windows ................................................................................ 87
2.10.7. Windows Postinstallation Procedures ........................................................................ 88
2.10.8. Installing MySQL from Source on Windows ............................................................... 90
2.11. Installing MySQL on Mac OS X .......................................................................................... 95
2.12. Installing MySQL from RPM Packages on Linux .................................................................. 97
2.13. Installing MySQL on Solaris .............................................................................................. 100
2.14. Installing MySQL on i5/OS ................................................................................................ 101
2.15. Installing MySQL on NetWare ........................................................................................... 105
2.16. Installing MySQL from Generic Binaries on Other Unix-Like Systems .................................. 107
2.17. Installing MySQL from Source ........................................................................................... 109
2.17.1. Installing MySQL from a Standard Source Distribution ............................................. 110
2.17.2. Installing MySQL from a Development Source Tree ................................................. 113
2.17.3. MySQL Source-Configuration Options ..................................................................... 115
2.17.4. Dealing with Problems Compiling MySQL ............................................................... 123
2.17.5. Compiling and Linking an Optimized
mysqld
Server ............................................... 126
2.18. Postinstallation Setup and Testing ..................................................................................... 127
2.18.1. Unix Postinstallation Procedures ............................................................................. 127
2.18.2. Securing the Initial MySQL Accounts ...................................................................... 138
2.19. Upgrading or Downgrading MySQL ................................................................................... 142
2.19.1. Upgrading MySQL ................................................................................................. 142
2.19.2. Downgrading MySQL ............................................................................................. 153
2.19.3. Checking Whether Tables or Indexes Must Be Rebuilt ............................................. 154
2.19.4. Rebuilding or Repairing Tables or Indexes .............................................................. 156
2.19.5. Copying MySQL Databases to Another Machine ..................................................... 158
2.20. Operating System-Specific Notes ...................................................................................... 159
2.20.1. Linux Notes ........................................................................................................... 159
2.20.2. Mac OS X Notes ................................................................................................... 165
2.20.3. Solaris Notes ......................................................................................................... 165