MySQL 4.1.7 for OS/2 Warp build 2 ================================= WARNING Read this file is you are upgrading from 3.x NOTE This installer will not overwrite your existing 3.x or 4.0 installation. Contents -------- Welcome to the latest port of MySQL for OS/2 and eComStation. This software is based on the MySQL 4.1 source tree. Modules included in this build: - protocol data compression - Library and header files for C/CPP developers included This package has been built using Innotek gcc, and so it requires the innotek runtime (included in this package). The MySQL server is distributed under the GPL license. Please refer to the file COPYING for the license information. The MySQL client library is distributed under the LGPL license. Please refer to the file COPYING for the license information. Most of the MySQL clients are distributed under the GPL license, but some files may be in the public domain. The latest information about MySQL can be found at: http://www.mysql.com To get the latest information about this port please subscribe to our newsgroup/mailinglist mysql-os2 at groups.yahoo.com. To see what MySQL can do, take a look at the features section in the manual. For future plans see the TODO appendix in the manual. New features/bug fixes history is in the news appendix in the manual. For the currently known bugs/misfeatures (known errors) see the bugs appendix in the manual. The OS/2 section contains notes that are specific to the MySQL OS/2 and eComStation version. Please note that MySQL is a constantly moving target. New builds for Linux are made available every week. This port may therefore be a few minor versions after the latest Linux/Win32 builds but its generally more stable than the "latest and greatest" port. MySQL is brought to you by: TcX DataKonsult AB & MySQL Finland AB This port is brought to you by: Yuri Dario , development, porting Timo Maier , documentation, testing John M Alfredsson , documentation, testing System requirements: -------------------- - OS/2 Warp 3 with FP ?? or later, OS/2 Warp 4 with FP ?? or later, OS/2 Warp Server for e-Business, eComStation 1.0,1.1,1.2 - TCPIP 4.x installed (requires 32-bit tcpip stack) - WarpIN installer 1.0.4 (ftp://ftp.netlabs.org/pub/warpin/warpin-1-0-4.exe) - Pentium (or higher) processor is required (no 386/486) Note: probably some fixpak level is required on both Warp3&Warp4 to support >2GB file sizes. Installation ------------ NOTE: read http://dev.mysql.com/doc/mysql/en/Upgrading-from-3.23.html if you are upgrading a 3.23.xx installation! mysql_fix_privilege_tables.sql is in your mysql41\data directorty. Save the installation archives into a temporary folder and double click on the main package; otherwise you can drop the mysql package in your WarpIN object or type WARPIN MYSQL-4-1-??-B?.WPI from the command line. The configuration file for MySQL is named my.cnf and it is placed into your %ETC% directory. Usually it located into the boot driver under x:\MPTN\ETC If the installation detect an existing configuration file, it will not be overwritten, keeping you settings; see x:\...\mysql\data\my.cnf.sample for new settings. This file is not deleted by uninstall process. Startup options for MySQL daemon could be added there. NOTE: from MySQL 4.0, my.cnf is not required to run mysqld. NEW: starting with MySQL 3.23.50, the installation scripts are no longer executed at every installation. NOTE: If this is your first time MySQL installation, please select also the last package to create default databases and configuration files. If installation scripts are not selected, WarpIN will only copy the included files, without touching your current configuration. As default, client connections uses data compression: if you don't like it, remove the following from your %ETC%\my.cnf [client] compress The server switches automatically compression mode on client request. This release comes with DLL client library MYSQL41.DLL: it is installed by default into mysql\bin together with client applications. Copy it to your x:\OS2\DLL or another directory in your LIBPATH to run command line utilities from every place. The client dll name has been changed since the internal data structures for MySQL 4.1 are different from the 3.x and 4.0 source tree: to avoid crashes, name has been changed to include also the version number. If you are a developer, use new headers to link with the new library. See documentation for manuals installation. NOTE tables upgraded to 4.1 could be no longer compatible with 4.0.18 or 3.x. New features ------------ (4.0)Named pipes: use --enable-named-pipe for mysqld to enable localhost communications with named pipes; this should be a little faster than unix local sockets. Clients can connect using named pipes using \pipe\MySQL as socket name, e.g. mysql --socket=\pipe\MySQL Replication: master/slave configurations are now working; be aware that this configuration has not been fully tested. Binaries can be moved everywhere without changing my.cnf, as in Windows. InnoDB database engine is included. Enabled usage of high memory arena for memory allocation. The default output is now sent to data\hostname.err; you can use --console to write standard output to console (as it was in 3.x). Binaries are compiled for Pentium processor (or higher), code is tuned for Pentium III processors (or higher). File support for 64bit access (>2GB databases). Access to table names is case insensitive by default: disabling it could lead to table corruption since the internal cache will refer to different tables (one for every used name). Deprecated features: --preload-client-dll is no longer available. Documentation ------------- Documentation can be viewed online at http://dev.mysql.com/doc/mysql/en/index.html Documentation is provided in separate files. You can use either the PDF documentation (requires Adobe Acrobat Reader) or the INF documentation (requires OS/2 view or NewView). The PDF documentation is found in MYSQL-4-1-??-PDF.WPI and the INF documentation is found in MYSQL-4-1-??-INF.WPI The latest documentation in other formats can always be downloaded from http://www.mysql.com. However this documentation may not fully apply to this port. The INF documentation could contain errors because of semi-automatic translation from texi original. Also it is not updated as the latest PDF manual (sorry, but conversion from texi to ipf requires quite a lot of work). To install the manuals, their WPI must be placed in the same directory of the main WPI package: once the main package installation is started, new install options will be available (inf or pdf manual). Test Suite ---------- Running the MySQL test suite requires a working unix enviroment: the tests are shell based, and many other command line utilities are required. At least sh, sed, expr, find, which are required. Please adjust line#182 BASEDIR=e:/bin/mysql41 with your path settings. Support ------- Since MySQL is a OpenSource freeware product there are no formal support options available. Please subscribe to mysql-os2 at www.yahoogroups.com to get in contact with other users using this port. http://www.yahoogroups.com/group/mysql-os2 This newsgroup/mailinglist is the official "home" of this port. Donations --------- Since this software is ported for free, donations are welcome! you can use PayPal to donate me and support OS/2 developement. Please use the below email or see my home page. You can get also an extended support, which is not free and subject to custom rates. Ask in the mailing list for details. At least, a post card is welcome! Know problems ------------- - Some tests fail on deleting of open files; usually this is related to unix ability to delete opened files without reporting error; you can avoid this changing your queries to release tables in a different order. - There is a bug in current tempnam() implementation: temporary files will be written to the root of %TMP% drive (mask: ib*.tmp). - Since OS/2 cannot delete open files, it is likely to find old files in your %TMP% directory: you can safely delete them if not locked (e.g. a cron batch file). Apache/2 + PHP -------------- To avoid problems with different socket when you use PHP and Apache webserver, get the PHP4 module from the Apache Server for OS/2 homepage http://silk.apana.org.au/apache/ Developing MySQL ---------------- If you want to help us develop MySQL for OS2/eComStation please join the mysql-os2 mailinglist at groups.yahoo.com and ask for help to set up your environment! All questions that are specific to the OS2/eComStation version should be posted to this list! Please remember to include all relevant information that may help solve your problem. Building MySQL (Innotek gcc libc) --------------------------------- Requirements: - resource compiler - ppwizard - warpin - get data/mysql, data/test from Windows source distribution; - get libmysql/dll.c from Windows source distribution (put into libmysql_r); - download manual-a4.pdf and put into docs; (more...) =============================================================================== Yuri Dario http://www.os2power.com/yuri