| # MySQL Server This chapter describes how to setup the MySQL software for ERP Enterprise. Before you can install the ERP Enterprise software, you must complete several tasks, as described in the following sections. Overview of the installation process MySQL installations are version and system-dependant. Refer to the MySQL documentation for the installation procedure for the MySQL version you want to install. More information can be found at: http://www.mysql.com Requirements Install the latest version of the MySQL software. The minimal recommended version for installation is 5.0.19. Reserve a dedicated disk for temporary storage of MySQL, by setting the MySQL variable tmpdir. Set the lock wait timeout (MySQL variable innodb_lock_wait_timeout) to a low value such as 5. For more-detailed information, refer to the Enterprise Server Technical Notes (U8891 US) or contact Infor for additional sizing information. Character set for the MySQL database For MySQLyou do not need to choose a default character set for the database. However, during the installation of ERP Enterprise on MySQL the user is prompted to choose a character set used for the creation of all database objects by the MySQL database driver. Here you must select a character set. |