diff options
Diffstat (limited to 'Docs/manual.texi')
| -rw-r--r-- | Docs/manual.texi | 150 |
1 files changed, 124 insertions, 26 deletions
diff --git a/Docs/manual.texi b/Docs/manual.texi index ffab4f86593..0435ca991a9 100644 --- a/Docs/manual.texi +++ b/Docs/manual.texi @@ -228,6 +228,7 @@ System-specific issues * HP-UX 10.20:: HP-UX 10.20 notes * HP-UX 11.x:: HP-UX 11.x notes * MacOSX:: MacOSX notes +* BEOS:: Linux notes (all Linux versions) @@ -766,7 +767,7 @@ MySQL change history Changes in release 3.23.x (Recommended; beta) -* News-3.23.24:: +* News-3.23.24:: Changes in release 3.23.24 * News-3.23.23:: Changes in release 3.23.23 * News-3.23.22:: Changes in release 3.23.22 * News-3.23.21:: Changes in release 3.23.21 @@ -5611,6 +5612,7 @@ distribution. * HP-UX 10.20:: HP-UX 10.20 notes * HP-UX 11.x:: HP-UX 11.x notes * MacOSX:: MacOSX notes +* BEOS:: @end menu @node Solaris, Solaris 2.7, Source install system issues, Source install system issues @@ -6874,11 +6876,25 @@ Automatic detection of @code{xlC} is missing from Autoconf, so a @strong{MySQL}: (The example uses the IBM compiler) @example -shell> CC="xlc_r" CFLAGS="-ma -O3 -qstrict" \ - CXX="xlC_r" CXXFLAGS="-ma -O3 -qstrict" \ - ./configure +export CC="xlc_r -ma -O3 -qstrict -qoptimize=3 -qmaxmem=8192 " +export CXX="xlC_r -ma -O3 -qstrict -qoptimize=3 -qmaxmem=8192" +export CFLAGS="-I /usr/local/include" +export LDLFAGS="-L /usr/local/lib" +export CPPFLAGS=$CFLAGS +export CXXFLAGS=$CFLAGS + +./configure --prefix=/usr/local \ + --localstatedir=/var/mysql \ + --sysconfdir=/etc/mysql \ + --sbindir='/usr/local/bin' \ + --libexecdir='/usr/local/bin' \ + --enable-thread-safe-client \ + --enable-large-files @end example +The above is the options used to compile the @strong{MySQL} distribution that +can be found at @uref{http://www-frec.bull.com/, www-frec.bull.com}. + If you change the @code{-O3} to @code{-O2} in the above configure line, you must also remove the @code{-qstrict} option (this is a limitation in the IBM C compiler). @@ -6886,16 +6902,26 @@ the IBM C compiler). If you are using @code{gcc} or @code{egcs} to compile @strong{MySQL}, you @strong{MUST} use the @code{-fno-exceptions} flag, as the exception handling in @code{gcc}/@code{egcs} is not thread-safe! (This is tested with -@code{egcs} 1.1.) We recommend the following @code{configure} line with -@code{egcs} and @code{gcc} on AIX: +@code{egcs} 1.1.). There is also some known problems with IBM's assembler +which may cause it to generate bad code when used with gcc. + +We recommend the following @code{configure} line with @code{egcs} and +@code{gcc 2.95} on AIX: @example -shell> CC=gcc \ - CXX=gcc \ - CXXFLAGS="-felide-constructors -fno-exceptions -fno-rtti" \" \ +shell> CC="gcc -pipe -mcpu=power2 -Wa,-many" \ + CXX="gcc -pipe -mcpu=power2 -Wa,-many" \ + CXXFLAGS="-felide-constructors -fno-exceptions -fno-rtti" \ ./configure --prefix=/usr/local/mysql --with-debug --with-low-memory @end example +The @code{-Wa,-many} is necessary for the compile to be successful. IBM is +aware of this problem but is in to hurry to fix because of the +workaround available. We don't know if the @code{-fno-exceptions} is required +with @code{gcc 2.95}, but as @strong{MySQL} doesn't use exceptions and the +above option generates faster code we recommend that one should always use +this option with @code{egcs / gcc}. + If you have problems with signals (@strong{MySQL} dies unexpectedly under high load) you may have found an OS bug with threads and signals. In this case you can tell @strong{MySQL} not to use signals by @@ -7038,7 +7064,7 @@ The optimization flags used by @strong{MySQL} (-O3) are not recognized by HP's compilers. I did not change the flags. @end itemize -@node MacOSX, , HP-UX 11.x, Source install system issues +@node MacOSX, BEOS, HP-UX 11.x, Source install system issues @subsection MacOS X notes You can get @strong{MySQL} to work on MacOS X by following the links to @@ -7057,6 +7083,20 @@ alias mysql '/usr/local/mysql/bin/mysql' alias mysqladmin '/usr/local/mysql/libexec/mysqladmin' @end example +@node BEOS, , MacOSX, Source install system issues +@subsection BeOS notes + +We are really interested in getting @strong{MySQL} to work on BeOS, but +unfortunately we don't have any person that knows BeOS or have +time to do a port. + +We are interested to find someone to do a port and we will help them +with any techincal questions they may have while doing the port. + +We have previously talked with some BeOS developers that have said that +@strong{MySQL} is '80% ported to BeOS', but we haven't heard from these +in a while. + @node Windows, OS/2, Source install system issues, Installing @section Windows notes @@ -25922,6 +25962,18 @@ whole databases. @xref{Backup}. mysqldump --opt database > backup-file.sql @end example +You can read this back into @strong{MySQL} with: + +@example +mysql database < backup-file.sql +@end example + +or + +@example +mysql -e "source /patch-to-backup/backup-file.sql" database +@end example + However, it's also very useful to populate another @strong{MySQL} server with information from a database: @@ -28115,9 +28167,10 @@ program. @node Which ODBC OS, ODBC administrator, ODBC, ODBC @section Operating systems supported by MyODBC -@strong{MyODBC} is a 32-bit ODBC (2.50) level 0 driver for connecting -an ODBC-aware application to @strong{MySQL}. @strong{MyODBC} works on -Windows95, Windows98, NT and on most Unix platforms. +@strong{MyODBC} is a 32-bit ODBC (2.50) level 0 (with level 1 and level +2 features) driver for connecting an ODBC-aware application to +@strong{MySQL}. @strong{MyODBC} works on Windows95, Windows98, NT and +on most Unix platforms. Normally you only need to install @strong{MyODBC} on Windows machines. You only need @strong{MyODBC} for Unix if you have a program like @@ -28327,6 +28380,16 @@ In some cases, Access may generate illegal SQL queries that @code{"Query|SQLSpecific|Pass-Through"} from the Access menu. @end itemize +@item ADO +When you access @strong{MyODBC} through ADO, @strong{MyODBC} doesn't +return a result for @code{SQLRowCount} for a query. We have tried to +track this down and according to ODBC logs, @strong{MyODBC} returns the +correct answer but the ADO client only gets -1 back from the ODBC +manager. Because of this we can only assume this is a bug in ADO. + +The only known workaround is to use a @code{SELECT COUNT(*)} statement +for a similar query to get the correct row count. + @item Borland Builder 4 When you start a query you can use the property @code{Active} or use the method @code{Open}. Note that @code{Active} will start by automatically issue @@ -34424,8 +34487,7 @@ more than one way to compute} @item @uref{http://www.yaboo.dk/, Yaboo - Yet Another BOOkmarker} -@c Didn't answer 2000-07-11 -@c @item @uref{http://www.yahoosuck.com, Yahoosuck} +item @uref{http://www.yahoosuck.com, Yahoosuck} @item @uref{http://www.ozsearch.com.au, OzSearch Internet Guide} @@ -34438,6 +34500,8 @@ more than one way to compute} @itemize @bullet +@item @uref{http:www.spylog.ru/, SpyLOG ; A very popular web counter site} + @item @uref{http://www.tucows.com/, TuCows Network; Free Software archive} @item @uref{http://www.jobvertise.com,Jobvertise: Post and search for jobs} @@ -34967,11 +35031,18 @@ only on Linux. You can always find the latest version @uref{http://www.trash.net/~ffischer/admin/index.html, here}. +@item @uref{http://www.mysql.com/Downloads/Win32/MySQL-Maker091.zip,MySQL-Maker 091}. +Shareware @strong{MySQL} client for windows. It's WYSIWYG tool which allows +you to create, change and delete databases and tables. +You can change field - structure and add, change and delete data in +these tables directly without ODBC-driver. +@uref{http://www.presult.de, MySQL Maker homepage (look under support/downloads)} + @item @uref{http://www.mysql.com/Downloads/Contrib/mysqlwinadmn.zip, mysqlwinadmn.zip} Windows GUI (binary only) to administrate a database, by David B. Mansel, @email{david@@zhadum.org}. -@item @uref{http://www.mysql.com/Downloads/Contrib/netadmin.zip, netadmin.zip} +@item @uref{http://www.mysql.com/Downloads/Win32/netadmin.zip, netadmin.zip} An administrator tool for @strong{MySQL} on Windows 95/98 and Windows NT 4.0. Only tested with @strong{MySQL} 3.23.5 - 3.23.7. Written using the Tmysql components. @@ -34982,6 +35053,9 @@ have still some bugs. you can test the program with all features. Please send bugs and hints to Marco Suess @email{ms@@it-netservice.de}. Original URL @url{http://www.it-netservice.de/pages/software/index.html}. +@item @uref{http://www.mysql.com/Downloads/Win32/netadmin2.zip, netadmin2.zip} +New version of netadmin; See above for details. + @item @uref{http://www.mysql.com/Downloads/Win32/ARTADMIN203.EXE,Atronic's @strong{MySQL} client for Windows 2.0.3.0}. Home page for this can be found at: @uref{http://www.artronic.hr}. @item @uref{http://www.mysql.com/Downloads/Win32/W9xstop.zip,Utility from Artronic to stop MySQL on win9x} @@ -35184,11 +35258,17 @@ This module authenticates users via @code{pam}, using @strong{MySQL}. Netscape Web Server API (NSAPI) functions to authenticate (BASIC) users against @strong{MySQL} tables. By Yuan John Jiang. -@item @uref{http://www.mysql.com/Downloads/Contrib/qmail-1.03-mysql-0.6.5.patch.gz, -qmail-1.03-mysql-0.6.5.patch.gz} +@item @uref{http://www.mysql.com/Downloads/Contrib/qmail-1.03-mysql-0.6.6.patch.gz,qmail-1.03-mysql-0.6.6.patch.gz} Patch for qmail to authenticate users from a @strong{MySQL} table. +By @email{takeshi@@SoftAgency.co.jp} + +@item @uref{http://www.mysql.com/Downloads/Contrib/proftpd-1.2.0rc2-fix-mysql.patch, proftpd-1.2.0rc2-fix-mysql.patch} +Patch for proftpd1.2.0rc2. By @email{takeshi@@SoftAgency.co.jp} + @item @uref{http://www.mysql.com/Downloads/Contrib/pwcheck_mysql-0.1.tar.gz,pwcheck_mysql-0.1.tar.gz} An authentication module for the Cyrus IMAP server. By Aaron Newsome. + + @end itemize @appendixsec Converters @@ -35260,16 +35340,19 @@ Raw port of a SQL mode for XEmacs. Supports completion. Original by Peter D. Pezaris @email{pez@@atlantic2.sbi.com} and partial @strong{MySQL} port by David Axmark. -@item @uref{http://www.mysql.com/Downloads/Win32/MyAccess97_Ver_1_01.zip, MyAccess97 1.01} -MyAccess is an AddIn for Access 97 and handles a lot of maintanance work -for @strong{MySQL} databases. +@item @uref{http://www.mysql.com/Downloads/Win32/myaccess97_1_1.zip, MyAccess97 1.1} +@item @uref{http://www.mysql.com/Downloads/Win32/myaccess2000_1_1.zip, MyAccess2000 1.1} -@item @uref{http://www.mysql.com/Downloads/Win32/MyAccess2000_Ver_1_01.zip, MyAccess2000 1.01} -MyAccess is an AddIn for Access 2000 and handles a lot of maintanance work -for @strong{MySQL} databases. +MyAccess is an AddIn for MS Access 97/2000 which allows you to manage MySQL databases from within Access. Main functions are: +@itemize @bullet +@item Create/Modify Tables +@item Execute Queries against MySQL +@item Extract "Create Table-Scripts' from MySQL +@item Import/Export tables from Access to MySQL and vice versa +@item Log Changes +@end itemize -@uref{http://www.mysql.com/Downloads/Win32/MyAccess-1.01.readme, -MyAccess-readme}. By Hubertus Hiden. +Written by Hubertus Hiden. @uref{http://myaccess.fsn.net, MyAccess homepage}. @item @uref{http://www.mysql.com/Downloads/Contrib/radius-0.3.tar.gz, radius-0.3.tar.gz} Patches for @code{radiusd} to make it support @strong{MySQL}. By Wim Bonis, @@ -35729,12 +35812,24 @@ though, so 3.23 is not released as a stable version yet. To make it possibly to reliable dump and restore tables with @code{TIMESTAMP(X)} columns, @code{MySQL} now reports columns with X other than 14 or 8 to be strings. +@item +Changed sort order for latin1 as it was before 3.23.22. Any table with +@code{CHAR} columns that may have characters > ASCII 128 created or +modified with 3.23.22 must be repaired! +@item +Fixed small memory leak introduced from 3.23.22 when creating a +temporary table. +@item +Fixed problem with BDB tables and reading on unique (not primary) key. @end itemize @node News-3.23.23, News-3.23.22, News-3.23.24, News-3.23.x @appendixsubsec Changes in release 3.23.23 @itemize @bullet @item +Changed sort order for 'German'; All tables created with 'German' sortorder +must be repaired with @code{REPAIR TABLE} or myisamchk before use! +@item Added option @code{--core-file} to @code{mysqld} to get a core file on Linux if mysqld dies on the SIGSEGV signal. @item @@ -35828,6 +35923,9 @@ Fixed fatal bug in @code{LOAD TABLE FROM MASTER} that did not lock the table dur More variables in @code{SHOW SLAVE STATUS} and @code{SHOW MASTER STATUS} @item @code{SLAVE STOP} now will not return until the slave thread actually exits +@item +Full text search via the @code{MATCH} function and @code{FULLTEXT} index type. +(For MyISAM files). This made @code{FULLTEXT} is reserved word. @end itemize @node News-3.23.22, News-3.23.21, News-3.23.23, News-3.23.x |