tailieunhanh - MySQL Administrator's Bible- P2

MySQL Administrator's Bible-P2: With special focus on the release of the next major of MySQL, this resource provides a solid framework for anyone new to MySQL or from a background database,as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of the coverage database management, including unique approach features MySQL database engine and functions-as well as MySQL SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index. | Installing and Upgrading MySQL Server 2 To install the pkg file you will need to run pkgadd -d with root privileges. You can list multiple packages separated by spaces and rpm will install them at the same time shell pkg -d The following shows an example with the start of the package installation shell pkgadd -d The following packages are available 1 mysql MySQL Community Server GPL Select package s you wish to process or all to process all packages . default all q 1 Processing package instance mysql from export home user MySQL Community Server GPL Copyright C 2000-2005 MySQL AB MySQL Finland AB TCX DataKonsult AB The selected base directory opt mysql must exist before installation is attempted. Do you want this directory created now y n q y Using opt mysql as the package base directory. Processing package information. Processing system information. Verifying disk space requirements. Checking for conflicts with packages already installed. Checking for setuid setgid programs. This package contains scripts which will be executed with super-user permission during the process of installing this package. Do you want to continue with the installation of mysql y n y Installing MySQL Community Server GPL as mysql The package places the data files in the data directory which is var lib mysql by default. This can be somewhat confusing because the base directory defaults to opt mysql mysql. In addition both the pid file and error log are in the data directory. Once installation is complete you will need to perform post-installation configuration which is covered in the Initial Configuration section later in the chapter. 17 Part I First Steps with MySQL WARNI - -- Installing from an archive package on Unix A common installation method is to use the compressed archive distributions provided for various platforms. MySQL archive binary .