MySQL 5.0.6-beta has been released
fail loading dump files containing certain `\'-sequences. (Bug #9756) * Fixed a failure to resolve a column reference properly when an outer join involving a view contained a subquery and the column was used in the subquery and the outer query. (Bug #6106, Bug #6107) * Use of a subquery that used `WITH ROLLUP' in the `FROM' clause of the main query sometimes resulted in a `Column cannot be null' error. (Bug #9681) * Fixed a memory leak that occurred when selecting from a view that contained a subquery. (Bug #10107) * Fixed an optimizer bug in computing the union of two ranges for the `OR' operator. (Bug #9348) * Fixed a segmentation fault in `mysqlcheck' that occurred when the last table checked in `--auto-repair' mode returned an error (such as the table being a `MERGE' table). (Bug #9492) * `SET @var= CAST(NULL AS [INTEGER|CHAR])' now sets the result type of the variable to `INTEGER'/`CHAR'. (Bug #6598) * Incorrect results were returned for queries of the form `SELECT ... LEFT JOIN ... WHERE EXISTS (SUBQUERY)', where the subquery selected rows based on an `IS NULL' condition. (Bug #9516) * Executing `LOCK TABLES' and then calling a stored procedure caused an error and resulting in the server thinking that no stored procedures exist. (Bug #9566) * Selecting from a view containing a subquery caused the server to hang. (Bug #8490) * Within a stored procedure, attempting to execute a multiple-table `UPDATE' failed with a `Table 'TBL_NAME' was locked with a READ lock and can't be updated' error. (Bug #9486) * Starting `mysqld' with the `--skip-innodb' and `--default-storage-engine=innodb' (or `--default-table-type=innodb' caused a server crash. (Bug #9815) * Queries containing `CURRENT_USER()' incorrectly were registered in the query cache. (Bug #9796) * Setting the `storage_engine' system variable to `MEMORY' succeeded, but retrieving the variable resulted in a value of `HEAP' (the old name for the `MEMORY' storage engine) rather than `MEMORY'. (Bug #10039) * `mysqlshow' displayed an incorrect row count for tables. (Bug #9391) * The server died with signal 11 if a non-existent location was specified for the location of the binary log. Now the server exits after printing an appropriate error messsage. (Bug #9542) * Fixed a problem in the client/server protocol where the server closed the connection before sending the final error message. The problem could show up as a `Lost connection to MySQL server during query' when attempting to connect to access a non-existent database. (Bug #6387, Bug #9455) * Fixed a `readline'-related crash in `mysql' when the user pressed Control-R. (Bug #9568) * For stored functions that should return a `YEAR' value, corrected a failure of the value to be in `YEAR' format. (Bug #8861) * Fixed a server crash resulting from invocation of a stored function that returned a value having an `ENUM' or `SET' data type. (Bug #9775) * Fixed a server crash resulting from invocation of a stored function that returned a value having a `BLOB' data type. (Bug #9102) * Fixed a server crash resulting from invocation of a stored function that returned a value having a `BIT' data type. (Bug #7648) * `TIMEDIFF()' with a negative time first argument and postive time second argument produced incorrect results. (Bug #8068) * Fixed a problem with `OPTIMIZE TABLE' for `InnoDB' tables being written twice to the binary log. (Bug #9149) * `InnoDB': Prevent `ALTER TABLE' from changing the storage engine if there are foreign key constraints on the table. (Bug #5574, Bug #5670) * `InnoDB': Fixed a bug where next-key locking doesn't allow the insert which does not produce a phantom. (Bug #9354) If the range is of type `'a' <= uniquecolumn', `InnoDB' lock only the RECORD, if the record with the column value `'a'' exists in a CLUSTERED index. This allows inserts before a range. * `InnoDB': When `FOREIGN_KEY_CHECKS=0', `ALTER TABLE' and `RENAME TABLE' will ignore any type incompatibilities between referencing and referenced columns. Thus, it will be possible to convert the character sets of columns that participate in a foreign key. Be sure to convert all tables before modifying any data! (Bug #9802) * Provide more informative error messages in clustered setting when a query is issued against a table that has been modified by another `mysqld' server. (Bug #6762) Enjoy! Matt -- Matt Wagner, Production Engineer MySQL AB, www.mysql.com Northfield, MN, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1.12 has been released
On 5/16/05 1:04 PM, Jan Pieter Kunst <[EMAIL PROTECTED]> wrote: >> A new version of MySQL Community Edition 4.1.12 Open Source database >> management system has been released. It is now available in source and >> binary form for a number of platforms from our download pages at >> http://dev.mysql.com/downloads/ and mirror sites. > > The link to the Mac OS X 10.3 version is out of date. It links to > 4.1.11. 4.1.12 is downloadable if this: > > <http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-standard-4.1.11-apple-darw > in7.8.0-powerpc.tar.gz/from/pick> > > is manually changed to: > > <http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-standard-4.1.12-apple-darw > in7.9.0-powerpc.tar.gz/from/pick> Jan, Yes, sorry about that. The latest update for OS X 10.3 changed the kernel version number again. A request is already in to our web team to update the download page, should be coming up shortly. Matt -- Matt Wagner, Production Engineer MySQL AB, www.mysql.com Northfield, MN, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1.12 has been released
On 5/16/05 12:57 PM, Dan Bolser <[EMAIL PROTECTED]> wrote: >> A new version of MySQL Community Edition 4.1.12 Open Source database >> management system has been released. It is now available in source and >> binary form for a number of platforms from our download pages at >> http://dev.mysql.com/downloads/ and mirror sites. > > How long is it before the Dec OSF downloads are updated usually? Dan, We had to skip Dec OSF for this release due to some unresolved build problems. Sorry. Matt -- Matt Wagner, Production Engineer MySQL AB, www.mysql.com Northfield, MN, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.1.12 has been released
ENAME TABLE for an ARCHIVE table failed if the `.arn' file was not present. (Bug #9911) * Fixed an optimizer problem where extraneous comparisons between NULL values in indexed columns were being done for operators such as = that are never true for NULL. (Bug #8877) * SELECT ROUND(expr) produced a different result than CREATE TABLE ... SELECT ROUND(expr). (Bug #9837) * Fixed some awk scriptportabilityproblems in cmd-line-utils/libedit/makelist.sh. (Bug #9954) * Changed metadata for result of SHOW KEYS: Data type for Sub_part column now is SMALLINT rather than TINYINT because key part length can be longer than 255. (Bug #9439) * Fixed some problems with myisampack on 64-bit systems that resulted in segmentation violations. (Bug #9487) * Fixed an optimizer bug in computing the union of two ranges for the OR operator. (Bug #9348) * Fixed an index corruption problem for MyISAM tables that resulted from the 4.1 behavior of padding values with blanks for comparison: Dumping a table with mysqldump, reloading it, and then re-running the binary log against it crashed the index and necessitated a repair. (Bug #9188) * Fixed a segmentation fault in mysqlcheck that occurred when the last table checked in --auto-repair mode returned an error (such as the table being a MERGE table). (Bug #9492) * Fixed the client/server protocol for prepared statements so that reconnection works properly when the connection is killed while reconnect is enabled. (Bug #8866) * INSERT ... ON DUPLICATE KEY UPDATE incorrectly updated a TIMESTAMP column to the current timestamp, even if the update list included col_name = col_name for that column to prevent the update. (Bug #7806) * Starting mysqld with the --skip-innodb and --default-storage-engine=innodb (or --default-table-type=innodb caused a server crash. (Bug #9815) * Queries containing CURRENT_USER() incorrectly were registered in the query cache. (Bug #9796) * A server installed as a Windows service and started with --shared-memory could not be stopped. (Bug #9665) * mysqldump dumped core when invoked with --tmp and --single-transaction options and a non-existent table name. (Bug #9175) * Additional fix for mysql_server_init() and mysql_server_end() C API functions so that stopping and restarting the embedded server will not cause a crash. (Bug #7344) * mysql.server no longer uses non-portable alias command or LSB functions. (Bug #9852) * Fixed a readline-related crash in mysql when the user pressed Control-R. (Bug #9568) * TIMEDIFF() with a negative time first argument and postive time second argument produced incorrect results. (Bug #8068) * Fixed a bug that caused concurrent inserts to be allowed into the tables in the SELECT ... UNION ... part of INSERT ... SELECT ... UNION This could result in the incorrect order of queries in the binary log. (Bug #9922) * Warning message from GROUP_CONCAT() did not always indicate correct number of lines. (Bug #8681) * InnoDB: ENUM and SET columns were treated incorrectly as character strings. This bug did not manifest itself with latin1 collations, but it caused malfunction with utf8. Old tables will continue to work. In new tables, ENUM and SET will be internally stored as unsigned integers. (Bug #9526) * InnoDB: Avoid test suite failures caused by a locking conflict between two server instances at server shutdown/startup. This conflict on advisory locks appears to be the result of a bug in the operating system; these locks should be released when the files are closed, but somehow that does not always happen immediately in Linux. (Bug #9381) * InnoDB: Prevent ALTER TABLE from changing the storage engine if there are foreign key constraints on the table. (Bug #5574, Bug #5670) * InnoDB: Fixed a deadlock without any locking, simple select and update. (Bug #7975) InnoDB now takes an exclusive lock when INSERT ON DUPLICATE KEY UPDATE is checking duplicate keys. * Creating a table did not work for a cluster with 6 nodes. (Bug #8928) Databases with 1, 2, 4, 8, ... (2^n nodes) did not have the problem. After a rolling upgrade, restart each node manually by restarting it with the --initial option. Otherwise, use dump and restore after an upgrade. * Fix undersized array in my_print_defaults that caused crash on Sun Solaris (and maybe strange results on other platforms). (Bug #9136) * Fix for auto-increment not working with INSERT..SELECT and NDB storage engine. (Bug #9675) En
MySQL 4.1.11 has been released
treated the same by the utf8_general_ci collation. (Bug #8385) * The MAX_CONNECTIONS_PER_HOUR resource limit was not being reset hourly and thus imposed an absolute limit on number of connections per account until the server is restarted or the limits flushed. (Bug #8350) * With a database was dropped with lower_case_table_names=2, tables in the database also were dropped but not being flushed properly from the table cache. If the database was recreated, the tables also would appear to have been recreated. (Bug #8355) * Changed mysql_server_end() C API function to restore more variables to their initial state so that a subsequent call to mysql_server_init() would not cause a client program crash. (Bug #7344) * Fixed a problem with accented letters improperly being treated as distinct with the utf_general_ci collation. (Bug #7878) * ENUM and SET columns in privilege tables incorrectly had a case-sensitive collation, resulting in failure of assignments of values that did not have the same lettercase as given in the column definitions. The collation was changed to be case insensitive. (Bug #7617) * An expression that tested a case-insensitive character column against string constants that differed in lettercase could fail because the constants were treated as having a binary collation. (For example, WHERE city='London' AND city='london' could fail.) (Bug #7098, Bug #8690) * The output of the STATUS (\s) command in mysql had the values for the server and client character sets reversed. (Bug #7571) * If the slave was running with --replicate-*-table options which excluded one temporary table and included another, and the two tables were used in a single DROP TEMPORARY TABLE IF EXISTS statement, as the ones the master automatically writes to its binary log upon client's disconnection when client has not explicitly dropped these, the slave could forget to delete the included replicated temporary table. Only the slave needs to be upgraded. (Bug #8055) * Treat user variables as having IMPLICIT derivation (coercibility) to avoid ``Illegal mix of collations'' errors when replicating user variables. (Bug #6676) * When setting integer system variables to a negative value with SET VARIABLES, the value was treated as a positive value modulo 2^32. (Bug #6958) * Fixed a bug in bundled readline library that caused segmentation fault in mysql when user entered Shift+Enter. (Bug #5672) * Fix conversion of strings -> double to get higher accuracy for floating point values that are integers, like: 123.45E+02 (Bug #7840). * Fixed a bug in MATCH ... AGAINST in natural language mode that could cause a server crash if the FULLTEXT index was not used in a join (EXPLAIN did not show fulltext join mode) and the search query matched no rows in the table (Bug #8522). * Platform and architecture information in version information produced for --version option on Windows was always Win95/Win98 (i32). More accurately determine platform as Win32 or Win64 for 32-bit or 64-bit Windows, and architecture as ia32 for x86, ia64 for Itanium, and axp for Alpha. (Bug #4445) * Fixed a rare race condition which could lead to FLUSH TABLES WITH READ LOCK hanging. (Bug #8682) * Fixed a bug that caused the slave to stop on statements that produced an error on the master. (Bug #8412) * If multiple semicolon-separated statements were received in a single packet, they were written to the binary log as a single event rather than as separate per-statement events. For a server serving as a replication master, this caused replication to fail when the event was sent to slave servers. (Bug #8436) Enjoy! Matt -- Matt Wagner, Production Engineer MySQL AB, www.mysql.com Northfield, MN, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: problem with mysql-max-5.0.3 for Solaris 8 32 bit
> It would appear that the package is for the 64-bit OS, even though it is > listed as being for the 32-bit one. > > I see directories, that failed to install, of: > /usr/local/mysql-max-5.0.3-beta-sun-solaris2.8-sparc-64bit/sql-bench > > I had gotten my file from > http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-max-5.0.3-beta-sun-solaris2 > .8-sparc.pkg.gz/from/http://mysql.mirrors.pair.com/ James, Sorry about this. Somehow the 64bit tarball was used for this package. I've fixed it now and uploaded a new 32bit Solaris 2.8 PKG. Note that it will take a bit to propagate out to the mirrors (probably 8-10 hrs). Thanks for notifying us about this. Matt -- Matt Wagner, Production Engineer MySQL AB, www.mysql.com Northfield, MN, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 5.0.3-beta has been released
read was stopped and started. (Bug #6148) * Giving mysqld a SIGHUP caused it to crash. * Changed semantics of CREATE/ALTER/DROP DATABASE statements so that replication of CREATE DATABASE is possible when using --binlog-do-db and --binlog-ignore-db. (Bug #6391) * A sequence of BEGIN (or SET AUTOCOMMIT=0), FLUSH TABLES WITH READ LOCK, transactional update, COMMIT, FLUSH TABLES WITH READ LOCK could hang the connection forever and possibly the MySQL server itself. This happened for example when running the innobackup script several times. (Bug #6732) * mysqlbinlog did not print SET PSEUDO_THREAD_ID statements in front of LOAD DATA INFILE statements inserting into temporary tables, thus causing potential problems when rolling forward these statements after restoring a backup. (Bug #6671) * InnoDB: Fixed a bug no error message for ALTER with InnoDB and AUTO_INCREMENT(Bug #7061). InnoDB now supports ALTER TABLE...AUTO_INCREMENT = x query to set auto increment value for a table. * Made the MySQL server accept executing SHOW CREATE DATABASE even if the connection has an open transaction or locked tables; refusing it made mysqldump --single-transaction sometimes fail to print a complete CREATE DATABASE statement for some dumped databases. (Bug #7358) * Fixed that, when encountering a ``disk full'' or ``quota exceeded'' write error, MyISAM sometimes didn't sleep and retry the write, thus resulting in a corrupted table. (Bug #7714) * Fixed that --expire-log-days was not honored if using only transactions. (Bug #7236) * Fixed that a slave could crash after replicating many ANALYZE TABLE, OPTIMIZE TABLE, or REPAIR TABLE statements from the master. (Bug #6461, Bug #7658) * mysqlbinlog forgot to add backquotes around the collation of user variables (causing later parsing problems as BINARY is a reserved word). (Bug #7793) * Ensured that mysqldump --single-transaction sets its transaction isolation level to REPEATABLE READ before proceeding (otherwise if the MySQL server was configured to run with a default isolation level lower than REPEATABLE READ it could give an inconsistent dump). (Bug #7850) * Fixed that when using the RPAD() function (or any function adding spaces to the right) in a query that had to be resolved by using a temporary table, all resulting strings had rightmost spaces removed (i.e. RPAD() did not work) (Bug #4048) * Fixed that a 5.0.3 slave can connect to a master < 3.23.50 without hanging (the reason for the hang is a bug in these quite old masters -- SELECT @@unknown_var hangs them -- which was fixed in MySQL 3.23.50). (Bug #7965) * InnoDB: Fixed a deadlock without any locking, simple select and update (Bug #7975). InnoDB now takes an exclusive lock when INSERT ON DUPLICATE KEY UPDATE is checking duplicate keys. * Fixed a bug where MySQL was allowing concurrent updates (inserts, deletes) to a table if binary logging is enabled. Changed to ensure that all updates are executed in a serialized fashion, because they are executed serialized when binlog is replayed. (Bug #7879) * Fixed a rare race condition which could lead to FLUSH TABLES WITH READ LOCK hanging. (Bug #8682) * Fixed a bug that caused the slave to stop on statements that produced an error on the master. (Bug #8412) Enjoy! Matt -- Matt Wagner, Production Engineer MySQL AB, www.mysql.com Northfield, MN, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.1.9 has been released
atetime values to TIME or DATE values. (Bug #6914) * Include compression library flags in the output from mysql_config --lib_r. (Bug #7021) * Corrected a problem with mysql_config not producing all relevant flags from CFLAGS. (Bug #6964) * Corrected a problem with mysqld_safe not properly capturing output from ps. (Bug #5878) * Fixed a bug that caused a linking failure when linking both the MySQL client library and IMAP library. (Bug #7428) * Fixed a bug that caused microseconds to be gobbled from the string result of the STR_TO_DATE function, if there is some other specifier in the format string following %f. (Bugs #7458) * Made the MySQL server accept executing SHOW CREATE DATABASE even if the connection has an open transaction or locked tables. Refusing it made mysqldump --single-transaction sometimes fail to print a complete CREATE DATABASE statement for some dumped databases. (Bug #7358) * Fixed that, when encountering a ``disk full'' or ``quota exceeded'' write error, MyISAM sometimes didn't sleep and retry the write, thus resulting in a corrupted table. (Bug #7714) * Fixed that --expire-log-days was not honored if using only transactions. (Bug #7236) * Fixed that a slave could crash after replicating many ANALYZE TABLE, OPTIMIZE TABLE, or REPAIR TABLE statements from the master. (Bug #6461, Bug #7658) * ndb_restore fails to handle blobs and multiple databases (Bug #7379) * ndb_restore enters infinite loop (Bug #7346) * ndb_mgmd is aborted on startup when using SHM connection (Bug #7124) Enjoy! Matt -- Matt Wagner, Production Engineer MySQL AB, www.mysql.com Northfield, MN, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 5.0.2-alpha has been released
or message (warning only) if a VIEW without presence of a key in the underlying table is used in queries with a LIMIT clause for updating. (This is the default value.) + 0 or NO: Prohibit update of a VIEW, which does not contain a key in the underlying table and the query uses a LIMIT clause (usually found in GUI tools). * Reverted output format of SHOW TABLES to old pre-5.0.1 format that did not include a table type column. To get the additional column that lists the table type, use SHOW FULL TABLES now. * The mysql_fix_privilege_tables script now initializes the global CREATE VIEW and SHOW VIEW privileges in the user table to the value of the CREATE privilege in that table. * If the server finds that the user table has not been upgraded to include the view-related privilege columns, it treats each account as having view privileges that are the same as its CREATE privilege. * CHECK TABLE now works with VIEWs (i.e. check view integrity: all underlying tables and columns are present and so on) * Added merge algorithm for join VIEW (view consists of several tables) and UPDATE/INSERT support for one of underlying tables in such VIEWs. Bugs fixed: * Fixed that mysqlbinlog --read-from-remote-server sometimes couldn't accept two binary logfiles on the command line. (Bug #4507) * Fixed that mysqlbinlog --position --read-from-remote-server had incorrect # at lines. (Bug #4506) * Fixed that CREATE TABLE ... TYPE=HEAP ... AS SELECT... caused replication slave to stop. (Bug #4971) * Fixed that mysql_options(...,MYSQL_OPT_LOCAL_INFILE,...) failed to disable LOAD DATA LOCAL INFILE. (Bug #5038) * Fixed that disable-local-infile option had no effect if client read it from a configuration file using mysql_options(...,MYSQL_READ_DEFAULT,...). (Bug #5073) * Fixed that SET GLOBAL SYNC_BINLOG did not work on some platforms (Mac OS X). (Bug #5064) * Fixed that mysql-test-run failed on the rpl_trunc_binlog test if running test from the installed (the target of 'make install') directory. (Bug #5050) * Fixed that mysql-test-run failed on the grant_cache test when run as Unix user 'root'. (Bug #4678) * Fixed an unlikely deadlock which could happen when using KILL. (Bug #4810) * Fixed a crash when one connection got KILLed while it was doing START SLAVE. (Bug #4827) * Made FLUSH TABLES WITH READ LOCK block COMMIT if server is running with binary logging; this ensures that the binary log position can be trusted when doing a full backup of tables and the binary log. (Bug #4953) * Fixed that the counter of an auto_increment column was not reset by TRUNCATE TABLE is the table was a temporary one. (Bug #5033) * Fixed slave SQL thread so that the SET COLLATION_SERVER... statements it replicates don't advance its position (so that if it gets interrupted before the actual update query, it will later redo the SET). (Bug #5705) * Fixed that if the slave SQL thread found a syntax error in a query (which should be rare, as the master parsed it successfully), it stops. (Bug #5711) * Fixed that if a write to a MyISAM table fails because of a full disk or an exceeded disk quota, it prints a message to the error log every 10 minutes, and waits until disk becomes free. (Bug #3248) * Fixed problem introduced in 4.0.21 where a connection starting a transaction, doing updates, then FLUSH TABLES WITH READ LOCK, then COMMIT, would cause replication slaves to stop (complaining about error 1223). Bug surfaced when using the InnoDB innobackup script. (Bug #5949) * OPTIMIZE TABLE, REPAIR TABLE, and ANALYZE TABLE are now replicated without any error code in the binary log. (Bug #5551) Enjoy! Matt -- Matt Wagner, Production Engineer MySQL AB, www.mysql.com Northfield, MN, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.0.22 has been released
option -l or --opt, or if one used LOCK TABLES ... LOCAL. (Workaround in 4.0.21: use --quick and --single-transaction. (Bug #5538) * Fixed that if the slave SQL thread found a syntax error in a query (which should be rare, as the master parsed it successfully), it stops. (Bug #5711) * Fixed that if a write to a MyISAM table fails because of a full disk or an exceeded disk quota, it prints a message to the error log every 10 minutes, and waits until disk becomes free. (Bug #3248) * Fixed problem with symlinked databases on Windows being shown with SHOW DATABASES even if the database name doesn't match the given wildcard (Bug #5539) Additional Notes: * Due to a temporary hardware failure the binaries for HP-UX 11.11 are missing from the initial release. They will be provided as soon as this HP-UX build system is online again. Enjoy! Matt -- Matt Wagner, Production Engineer MySQL AB, www.mysql.com Northfield, MN, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.1.7 has been released
Hi, MySQL 4.1.7, a new version of the popular Open Source/Free Software Database Management System has been released. It is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror sites. Note that not all mirror sites may be up-to-date at this point. If you cannot find this version on a particular mirror, please try again later or choose another download site. This is the first 4.1 production release. Please refer to our bugs database at http://bugs.mysql.com/ for more details about the individual bugs fixed in this version. News from the ChangeLog: Changes in release 4.1.7 Functionality added or changed: * InnoDB: Made LOCK TABLES behave by default like it did before MySQL 4.0.20 or 4.1.2: no InnoDB lock will be taken. Added a startup option and settable system variable innodb_table_locks for making LOCK TABLE acquire also InnoDB locks. See section "Restrictions on InnoDB Tables" in the manual. (Bug #3299, Bug #5998) Bugs fixed: * Fixed a bug with FOUND_ROWS() used together with LIMIT clause in prepared statements. (Bug #6088) * Fixed a bug with NATURAL JOIN in prepared statements. (Bug #6046). * Fixed a bug in join of tables from different databases having columns with identical names (prepared statements). (Bug #6050) * Now implicit access to system time zone description tables (which happens when you set time_zone variable or use CONVERT_TZ() function) does not require any privileges. (Bug #6116) * Fixed a bug which caused the server to crash when the deprecated libmysqlclient function mysql_create_db() was called. (Bug #6081) * Fixed REVOKE ALL PRIVILEGES, GRANT OPTION FROM user so that all privileges are revoked correctly. (Bug #5831). This corrects a case that the fix in 4.1.6 could miss. * Fixed a bug that could cause MyISAM index corruption when key values start with character codes below BLANK. This was caused by the new key sort order in 4.1. (Bug #6151) * Fixed a bug in the prepared statements protocol when wrong metadata was sent for SELECT statements not returning a result set (such as SELECT ... INTO OUTFILE). (Bug #6059) * Fixed bug which allowed one to circumvent missing UPDATE privilege if one had INSERT and SELECT privileges for table with primary key. (Bug #6173) * Fixed a bug in libmysqlclient with wrong conversion of negative time values to strings. (Bug #6049). * Fixed a bug in libmysqlclient with wrong conversion of zero date values (-00-00) to strings. (Bug #6058) * Fixed a bug that caused the server to crash on attempt to prepare a statement with RAND(?). (Bug #5985) * Fixed a bug with handling of DATE, TIME, and DATETIME columns in the binary protocol. The problem is compiler-specific and could have been observed on HP-UX, AIX, Solaris9, when compiling with native compiler. (Bug #6025) * Fixed a bug with handling of TINYINT columns in the binary protocol. The problem is specific to platforms where the C compiler has the char data type unsigned by default. (Bug #6024) * Fixed problem introduced in MySQL 4.0.21 where a connection starting a transaction, doing updates, then FLUSH TABLES WITH READ LOCK, then COMMIT, would cause replication slaves to stop complaining about error 1223. Bug surfaced when using the InnoDB innobackup script. (Bug #5949) Enjoy! Matt -- Matt Wagner, Production Engineer MySQL AB, www.mysql.com Northfield, MN, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.1.6 has been released
ger affected by NO_AUTO_VALUE_ON_ZERO mode. (Bug #5915). Enjoy! Matt -- Matt Wagner, Production Engineer MySQL AB, www.mysql.com Northfield, MN, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.0.21 has been released
#x27;, and `innodb_validate' in `CREATE TABLE' and `DROP TABLE' statements was accidentally removed in MySQL/InnoDB-4.0.19. The diagnostic functions attached to these special table names (*note InnoDB Monitor::) are accessible again in MySQL/InnoDB-4.0.21. * When the private SQL parser of InnoDB was modified in MySQL/InnoDB-4.0.19 in order to allow the use of the apostrophe (`'') in table and column names, the fix relied on a previously unused function `mem_realloc()', whose implementation was incorrect. As a result, InnoDB can incorrectly parse column and table names as the empty string. The InnoDB `realloc()' implementation has been corrected in MySQL/InnoDB-4.0.21. * Fixed a glitch introduced in 4.0.18 and 4.1.2: in `SHOW TABLE STATUS' InnoDB systematically overestimated the row count by 1 if the table fit on a single 16 kB data page. * InnoDB created temporary files with the C library function `tmpfile()'. On Windows, the files would be created in the root directory of the current file system. To correct this behavior, the invocations of `tmpfile()' were replaced with code that uses the function `create_temp_file()' in the MySQL portability layer. (Bug #3998) Enjoy! Matt -- Matt Wagner, Production Engineer MySQL AB, www.mysql.com Northfield, MN, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unicode in 4.1
On Tue, 2002-03-19 at 10:02, David Ayliffe wrote: > Hello, > > I need some details on the EXACT type of Unicode that MySQL will use > 4.1. > Ideally I'm looking for information on which type of Unicode MySQL will > use internally, and which type it will return data to the user in; and > is the MySQL Unicode implementation going to be phased in or with v4.1 > will Unicode suddenly arrive? > > I need to know if MySQL will use UTF-8, UCS or whatever both for use > internally and externally. Hi, Unicode in 4.1 will use UTF-8 and UCS2 with a possibility to recode between them (as well as between any supported character sets). > Some (VERY) technical documentation on this > subject would be appreciated. Sorry, this will not appear until the 4.1 branch is released -- and even then it will just be the end-user documentation that tells how to use the feature(s). If you would like some sort of a in-depth whitepaper, then you could hire some consulting services from our developers to write this for you. Please contact <[EMAIL PROTECTED]> if you are interested. Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Coordinator of Development /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com M: +1 952 250 5434 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: xml
On Sat, 2002-03-09 at 13:13, James Cox wrote: > Matt, > > Are you suggesting development of a wrapper around MySQL to convert XML to > SQL and back, so that you would have a pseudo XML front end to mysqld? James, Well 'wrapper' and 'pseudo XML front end' are kind of nebulous terms and phrases. :) But yeah basically. Functionality can be added to the MySQL client library (libmysqlclient) -- which is the library that holds all the C API functions and whatnot. It is the library that your PHP, Perl DBI, Java MySQL drivers link against in order to be able to talk to the MySQL server. http://www.mysql.com/doc/C/_/C_API_function_overview.html So for instance, for XML retrieval of your results it would be quite trival to add additional API calls to libmysqlclient that return XML to your application. However, loading an XML file into your MySQL server (via the C API) would be a more difficult and tricky task. DTDs would have to be defined, some software would have to manage these DTDs so that the data in the XML file could be correctly mapped into your database schema, etc etc. You can't just load any old XML file and expect MySQL to know how to deal with it. There would have to be a DTD (the file that defines the format of your XML file) submitted with the XML file so that things could be interpretted correctly. This means that this would involve an SGML parser (such as nsgmls) and some way to validate the XML file (I think nsgmls can do this), etc etc. This brings us to the point where if all of this was added to libmysqlclient, we would start running into bloatware issues there also. That's why I suggested that probably an external process (a daemon) that provides a "bridge" (as Rob ([EMAIL PROTECTED]) suggested earlier in this thread) would be better suited to *inputting* XML into MySQL. Output is easy. Input is more difficult. :) As you may be aware we are currently working diligently to add big functionality to MySQL (sub-selects, store procedures, failsafe replication, etc). That makes something like this XML stuff better suited for sponsorship. I'm not saying that with sponsorship, this XML stuff can pre-empt the development of the above features. But instead, sponsorship would allow us to hire another developer or two to develop this proposed XML functionality. It allows us to develop features that are in demand in parallel with our other priorities. Again, if anyone is interested in this sponsorship, please contact <[EMAIL PROTECTED]>. Regards, Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Coordinator of Development /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com M: +1 952 250 5434 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: xml
On Sat, 2002-03-09 at 11:52, Jeremy Zawodny wrote: > On Sat, Mar 09, 2002 at 05:37:28PM -, James Cox wrote: > > Anyhow, > > > > Mysql can return data in XML. > > The client can, but not the server, right? Jeremy, Correct, currently only the 'mysql' (-X option in MySQL 4.x) and 'mysqldump' (-X option in MySQL 3.23) client programs can return XML output. We believe that this sort of functionality belongs in the client programs and libraries. So that means for direct server XML interaction support would have to be added to the libmysqlclient library. Not bloat the 'mysqld' code. Of course inputting XML to a MySQL database is quite a different and more difficult task. It would require a lot more monkey business of some piece of software knowing how to map the XML schema into the DB schema. This is one of those fluffy features that is not traditionally in the RDBMS project scope -- and therefore lends itself to be a prime project for corporate sponsorship. Potential sponsors reading this should contact our sales team ([EMAIL PROTECTED]) if interested in helping. If seriously interested, we could develop some whitepaper specs and discuss options to for your company to help fund development. Regards, Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Coordinator of Development /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com M: +1 952 250 5434 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ETA for MySql having sub queries capabilities
On Fri, 2002-03-08 at 14:21, Rolando Morales wrote: > Does anyone know the ETA for MySql having > sub queries capabilities? Hi, Basic Sub-Selects are schedule to appear in the alpha release of 4.1. Which should be in about 1-3 months. Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Coordinator of Development /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
On Fri, 2002-03-08 at 10:02, Ireneusz Piasecki wrote: > Hi, > > It is very interesting, what are you wwriting, but: > > > " To determine if you should be concerned about this compiler issue, execute > gcc -v from the command prompt on your system. If the compiler reports > version 2.96, then there is a problem (this is the case, for example on RH > 7.x series or Mandrake 8.x). In this case, you should not try to compile > your own binary before downgrading to one of the compilers mentioned above. > You should also NOT use the MySQL server provided with your distribution -- > as this copy of MySQL was compiled with the same ill-advised compiler > version. " > this is from http://www.mysql.com/downloads/mysql-3.23.html > I understud, don't compile mysql with 2.96 of gcc. > I'm confiused. > > The query is: Compile server mysql with 2.96 or not ? Ireneusz, Our (MySQL AB) recommendation is to NOT compile *mysql* with RedHat's 2.96 compiler. Instead, in the case of RedHat, you should use 2.91 EGCS or 2.95 GCC compilers. If you do choose to compile with 2.96RH, then you are most likely going to run into problems in a production system. We definitely have a difference of opinion with Trond here. The bottom line is that if you want a stable MySQL server, then you should compile with GCC 2.91 or 2.95. These are the compilers for which our extensive testing has shown MySQL to be stable with. In any large and complicated project there are going to be dependencies on the compiler that the software was written for. Please note that the reason (atleast one of the reasons) RedHat includes 2.91 EGCS in their distribution is to compile the Linux kernel correctly. The Linux kernel -- another large and complicated project -- requires 2.91 EGCS. Read the kernel documentation for more information (README file included in every stock kernel tarball). This is absolutely normal and acceptable for large, complex softwares. Software simply cannot be changed everytime a software vendor (RH in this case) decides to fork their own version of something as fundamental as a compiler. MySQL in particular is a software product that gives your system a real work-out. We have discovered many critical bugs in the libc's, kernels and compilers of various systems -- for instance Glibc, the Linux kernel, and RedHat's forked 2.96 compiler. You will find the same is true of projects like ReiserFS (who do not recommend 2.96 either). While RedHat's 2.96 compiler may indeed work fine for relatively lightweight software that is most likely not going to be used in a high-performance production environment. We (MySQL AB) have determined -- through many investigations of MySQL under high-load compiled with 2.96RH -- that this compiler is not good for MySQL. Now that GCC 3.x has been released, we will be looking at making MySQL 4.x series (and higher) work well with it. GCC 3.x is looking very promising. Regards, Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Coordinator of Development /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Geo- datatype support
On Sun, 2002-03-03 at 21:41, Jeremy Zawodny wrote: > On Mon, Mar 04, 2002 at 01:46:47PM +1100, Ashley Joyce wrote: > > > > Does anyone know if Mysql supports geo-datatypes similiar to > > PostgreSQL.. I want to use Mysql as the data source for > > Mapserver? > > It doesn't yet, no. > > But I've seen hints of that work in version 4.1 Jeremy, Yes, we will have matched functionality to that of PostgreSQL's PostGIS in MySQL 4.1. We will probably start an Alpha release of 4.1 within the next 1-2 months. Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Coordinator of Development /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
My Apologies - Re: Summary: Board Meeting
All, Please disregard this "Summary: Board Meeting" message. It was sent to the public mailing list in error. This message was NOT at all meant for the public mailing list. Please except my apologies for the intrusion. Matt Wagner, MySQL AB -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Summary: Board Meeting
n that picture.) 14:24:38 Kaj: yeah, i too young :)) but i was in Sank Peterburg :) 14:24:43 :) 14:24:46 that's why I happened to have the picture! :) -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Decrypting PASSWORD() from MySQL
sherzodR writes: > > Hmm, I can't aggree with having two password columns, one raw password and > another is encrypted. It just doesn't make any sence. Why do you need to > encrypt the password in that case, don't you still have the original > password in yoru database? It just defeats the whole purpose of > authentication. So don't do that. Keep one password, in encrypted form, > that's it. SherzodR, Sure enough.. maybe it's not a good way to do things. But that is up to Zach to decide. :) I'm not answering his mail to tell him how he should write his application. I simply told him how he can do what he was trying to do. It's up to him to decide if it is a good/bad solution. Regards, Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Decrypting PASSWORD() from MySQL
Zach Curtis writes:
> I have a form for a user to request their forgotten username and password by
> entering their email address. I then process this using PHP and use mail()
> to send them their username and password. However, the password is stored in
> an encrypted PASSWORD('password') field in the MySQL table. How can I
> retrieve the decrypted password in a SELECT statement?
Zach,
You cannot do this. PASSWORD() is one-way.
What you have to do is have two fields, 'passwd' and 'epasswd', with
'passwd' being clear-text, the other being encrypted (with PASSWORD()
or other).
If you want to obscure the clear-text field in a decodable fashion,
then check out the ENCODE()/DECODE() functions.
Note, in MySQL 4.x there will be two new functions,
DES_ENCRYPT()/DES_DECRYPT().
Matt
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor
/_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA
<___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 4.0 style full text searching in 3.23.x
Martin Oldfield writes: > > I'd quite like to have the whizzy new 4.x style full text searching > features, but I'm scared of installing 4.x on a production system, so > I'm seeking advice. > > I see two options: > > 1. Stop fussing and install 4.x; > > 2. Patch 3.23.x with 4.x's full text stuff. > > Has anyone tried option (2), and am I being silly to worry about the > stability of MySQL 4.x ? Martin, Nobody has tried this as far as I know. However, the reason that 3.23.x is considered stable is because there are no new features being added -- only bug fixes. Any time you add new feature -- even if the code for the new feature is stable -- you risk creating bugs in other places. So if you managed to make a back-port, you would probably make the 3.23.x code as unstable as 4.x. :) Feel free to try it! But I think it is self-defeating -- if you are considering it for a production environment. :) My advice is to setup a test environment and try out 4.x, and submit good bug reports to us so that 4.x can become stable faster. Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and kernel upgrade
Sommai Fongnamthip writes: > Hi, > I was read recommendation from MySQL download page to upgrade Linux Kernel > for latest MySQL version. I have problem because I must still with Linux > Red Hat 6.2 (kernel 2.2.16-3) because it's my production server and Red Hat > has many task to upgrade in newer kernel. What will effect my system if I > install latest MySQL with current kernel? Sommai, Linux kernel 2.2.16 should be ok. The problem is specifically with an I/O bug in kernel 2.2.14. Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Alpha Linux binary distribution: Core dumped on AlphaServer 1200
Trond Eivind =?iso-8859-1?Q?Glomsr=F8d?= writes: > Robert Alexander <[EMAIL PROTECTED]> writes: > > > >Sinisa Milivojevic <[EMAIL PROTECTED]> writes: > > > > > >> Ron Jamison writes: > > >> > Using MySQL 3.23.46 from: > > >> > > > >> > http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unknown-linux-gnu-alp > > >> > > >> Try a binary from our site. > > > > > >The above one _is_ your site, isn't it? > > > > The actual MySQL site is, predictably enough, www.mysql.com. For downloads, try: > > http://www.mysql.com/downloads/ > > I know that, but I'm pretty sure sourceforge is one of their > mirrors. Yes, SourceForge has our *official* binaries... the same as MySQL.com. Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with bk://work.mysql.com ?
Fournier Jocelyn [Presence-PC] writes: > Hi, > > When I try to do a "bk pull", I have the following unexpected message : > > >bk pull > bk://work.mysql.com:7001: No route to host > > What's wrong ? Hi, It should be fixed now. We were doing an internet connection upgrade (from 10mb to 100mb). Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql 4.0
Harald Fuchs writes: > In article <v04210102b835719159b3@[207.112.85.67]>, > Robert Alexander <[EMAIL PROTECTED]> writes: > > > I'm getting the exact same error when trying to install MySQL 4.0 on RedHat 7.0 -- >both the binary distribution and the RPM. > > Previous binary versions of MySQL have worked just fine on the same machine. > > It seems to depend on the CPU. For me the binary distribution of > MySQL 4.0 works fine on Pentiums and Athlons, but I get illegal > instructions on K6/2s. Hi, AFAIK, this should be fixed when 4.0.1 comes out in a couple days. Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Obtaining MySQL for Solaris 8, Intel Version
Pauljames Dimitriu writes: > > Hello, > > Where can I get a version of MySQL for Solaris > 8, Intel version? Do I use the FreeBSD version of > MySQL or should I d/l the Linux version? I am just > getting used to the Solaris / UNIX environment. Hi, It seems that the latest build that we have of Solaris 8 (Intel) is for version 3.23.39. For a newer build, you will have to download the source tarball and compile yourself. You can find version 3.23.39 of standard MySQL (without transactions) here: http://www.mysql.com/downloads/mysql-3.23.html Or version 3.23.39 of MySQL-Max (with transactions): http://www.mysql.com/downloads/mysql-max-3.23.html Both are found in the "Solaris" section. Regards, Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Features in 4.0
Kyle Hayes writes: > > I did not see subselects in this list. Will MySQL support subselects in 4.x? > > What exactly does the "LOAD TABLE FROM MASTER" 'automagically' comment mean? > Does that command sync the slave with the master at that point? If I have > three tables, A, B, and C, and I want to load them at runtime from the master > and start replication do I have to lock them before doing "LOAD TABLE FROM > MASTER"? > > We are searching for a solution to enable us to load a large amount of data > without stopping the master for more than a couple of seconds. So far, we > have been able to write our own complex code to do this, but it is far from > the level of automation that we want. > > Could someone from the MySQL team please give us some details on subselects > and the new load table functionality? Hi, Subselects are scheduled for version 4.1. I don't know about the LOAD TABLE question, please direct this question to Sasha Pachev ([EMAIL PROTECTED]). Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql List Bounce Message?
Carl Troein writes: > > Jason Frisvold writes: > > > Can anyone explain why I'm getting a "Mail account is disabled" message from > > [EMAIL PROTECTED] regarding anything I post to the mysql list? > > Yep, that server uses some sort of broken software which > mistakes the sender for the receiver or does something > similarly braindead. > > If someone from MySQL reads this, PLEASE do delete whatever > domainhost.com address is causing this problem. Hi, I have already searched our subscription database for anyone with a domainhost.com address, and there are none. We have managed to contact an admin at domainhost.com and they say they are working on it. :-\ Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql as backend for email ?!?
Christopher Bergeron writes: > Does anyone know of any applications that insert email into mysql databases? > I can use either Windows or Linux as the client; however, I want mysql > server on the linux box (for stability). I don't like having all of my > email in MSOutlook's proprietary format because in 5 years when I need to > look back at something, I'll need a sql db search, not ms-outlooks little > search algorithm (I get a lot of email daily). > > Anyone have any suggestions or recommendations?? Hi, In every src and binary tarball distribution of MySQL there is a script called 'mail_to_db.pl' in the 'tests/' subdirectory. This script is exactly what you are looking for. You can either pipe mails to it one by one as they come into your system, or you can feed it mailbox files. Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [fwd] 123box.co.uk mail delivery system (from: MAILER-DAEMON@123box.co.uk)
Alexander Skwar writes: > sql > > Could this user please be removed? It's [EMAIL PROTECTED] Done. -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: creating tables using a number THIS IS A BUG
indrek siitan writes: > Hi, > > > SO this does seem like a bug .. hope MySql guys see this. I have > > looked but can't find anything about how to contact in case of bugs .. > > mail to [EMAIL PROTECTED] :-) er, [EMAIL PROTECTED] -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: XML Support
Gary Huntress writes:
> In the past few days 3 different people have asked me about "xml support" in
> mysql. I was unsure what to tell them actually, beyond saying "you can
> easily export recordsets to xml documents".Obviously you can store
> entire XML documents in a TEXT field, but I'm not sure thats really the
> functionality that they want.
>
> Actually the observation made was that MySQL and PostgreSQL might be falling
> behind the commercial databases in terms of native XML support. Oracle,
> MSSQL, and Sybase (probably DB2 as well since IBM is pretty big in the XML
> arena) already have some type of support.
Hi,
It would be nice if someone could detail more specifically what XML
features these commercial databases provide; and to what extent they
are actually useful and necessary in the RDBMS context.
The generally feeling about XML and MySQL right now, is that it
doesn't belong in the server. It is considered bloatware, and goes
counter to the aim of MySQL to be lean 'n mean. :)
At most there could be some additions to the MySQL Client library to
help with XML transformations and whatnot.
In 4.0 I have already added XML output to the 'mysql' command-line
tool ('-X' option) to equate to the current HTML output
functionality. I will also try to add XML output functionality to the
'mysqldump' utility in 4.0. Although this may have to wait until 4.1.
On my long-range TODO I would like to contact people like Matt
Sergeant (of Perl XML/AxKit fame) to see what features we could
add to the MySQL server to assist his efforts.
If anybody on this list has ideas/suggestions/requests on this topic,
please direct them to the Internals List <[EMAIL PROTECTED]>.
Regards,
Matt
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor
/_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA
<___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problems getting into MySQL.com
Philip Daggett writes: > Is anybody else not able to get onto mysql.com??? Hi, We're working on it. The eth card seems to have bombed, and the admins at our hosting facility (andover, where slashdot and freshmeat are) are working on it ASAP. Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: fwd: What is "Pupport" ? :)
Hi, Damn you guys are fast! :) Fixed. But the udmsearch is busted right now for unknown reasons. I will fix shortly. Matt Jeremy Zawodny writes: > FYI... > > - Forwarded message from Sam Masiello <[EMAIL PROTECTED]> - > > From: "Sam Masiello" <[EMAIL PROTECTED]> > To: "MySQL General" <[EMAIL PROTECTED]> > Date: Tue, 28 Aug 2001 17:10:17 -0400 > X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) > Subject: What is "Pupport" ? :) > > > Not really a MySQL question, but it is related to the MySQL web site > > If I go to: > > http://www.mysql.com/udmsearch/search.php > > the "Support" link is spelled "Pupport" (on other pages it is spelled > correctly, however)whoops :) > > --Sam > > Sam Masiello > Software Quality Assurance Engineer (providing quality Pupport :) ) > Synacor > (716) 853-1362 x289 > [EMAIL PROTECTED] > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > - End forwarded message - > > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 > > MySQL 3.23.41-max: up 11 days, processed 137,299,690 queries (137/sec. avg) -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Documentation - how do you do it ?
David Herring writes: > > > Good morning, > > Let me first start by praising the MySQL documentation. It is > excellent - both in content and in it's indexed, linked, and > searchable layout. > > On that later point, I would like to know how you acheived this ? > What tool(s) was used to create the texinfo document, and which > utilities are used to parse this for web contect, etc. Hi, Sorry for the late response. The primary format of the manual is Texinfo. Most of us write the texinfo in XEmacs with the aid of the 'Texinfo' xemacs mode (of course some less fortunate developers use the lowly 'vi' ;-). You can find out more about Texinfo here: http://www.gnu.org/directory/texinfo.html So we have the manual in this format, and then when we publish the MySQL.com website, we convert the manual to HTML with a perl script called 'texi2html'. You can find this script in our Source Tarball: mysql-3.23.41/Docs/Support/texi2html But to get the searchable manual that you know and love, there are a few more steps. We use a couple of in-house programs written by Sasha Pachev ([EMAIL PROTECTED]), that take this converted 'manual.html', and rip it apart and store it into a MySQL database. The manual is stored in the database according to texinfo node sections. Once the manual is in the database, we can pretty much reconstitute it into any organization that we want. For instance, this page: http://www.mysql.com/doc/ Never use to be such an extensive "Table of Contents", it used to only contain the main chapter headings. But after some reconsideration, we decided that it would be more useful to have a very extensive TOC similiar to this one: http://www.mysql.com/documentation/mysql/bychapter/ Anyways, so we have a second program (the first one is called 'html2mysql', the second 'idxman'), that does this reconstitution that you see at http://www.mysql.com/doc/ . 'idxman' also does all kinds of black magic to hook-up the user comments with the appropriate manual section. I'm sure if you contact Mr. :) Sasha Pachev ([EMAIL PROTECTED]), he could explain in more detail how both of his programs work. You could probably also prod him into giving you copies, as he's been meaning to release them publicly for some time now. Matt > >On Thu, Aug 16, 2001 at 09:47:30AM +0100, David Herring wrote: > > > > Good morning, > > > > Does anyone have any details on the how the MySQL searchable > > documentation is produced. Is the content held in MySQL with PHP to > > produce the frontend pages - and is this something that can be > > applied generally for web based doumentation services. > > The source file is in texinfo format, and it has good cross-reference > and keyword stuff in it. I believe they have a custom script that > turns it into what's on their site. > > Check with Matt <[EMAIL PROTECTED]> or Jeremy <[EMAIL PROTECTED]> for > details. I suspect that one (or both) of them will know. > > Jeremy > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MS Excel to MySQL upload macro?
Craig Westerman writes: > I have data I create daily in MS Excel. I need to insert this data into > MySQL data base on my web server every night. Does anyone here have a VB > technique to upload to MySQL from Excel via a macro? Hi, There is an 'excel2mysql' perl script at the bottom of the 'Converters' section of our contributed software page: http://www.mysql.com/downloads/contrib.html Regards, Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Got and mirrored it... (Re: MySQL-MAX 3.23.41 download link is dead... (need a download))
Matt Wagner writes: > Matt Wagner writes: > > Jeremy Zawodny writes: > > > On Thu, Aug 16, 2001 at 06:00:16PM -0700, Jeremy Zawodny wrote: > > > > > > > > Does anyone have the latest 3.23.41 I could grab a copy of? > > > > > > I managed to fetch it from ftp.mysql.com. A copy is now available here > > > as well: > > > > > > http://jeremy.zawodny.com/mysql/mysql-max-3.23.41-pc-linux-gnu-i686.tar.gz > > > > Hi, > > > > Thanks Jeremy for providing the quick work-around. > > > > I have temporarily fixed this by redirecting to the ftp.sunet.se > > mirror. > > Er.. I have been schnookered by some sunet.se automatching-closest-filename > thing (when you click on the .41 links, sunet.se auto-redirects you to > .40 files!). Turns out they only have .40 also. :( > > Fixing... will mail back soon. Done. -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Got and mirrored it... (Re: MySQL-MAX 3.23.41 download link is dead... (need a download))
Matt Wagner writes: > Jeremy Zawodny writes: > > On Thu, Aug 16, 2001 at 06:00:16PM -0700, Jeremy Zawodny wrote: > > > > > > Does anyone have the latest 3.23.41 I could grab a copy of? > > > > I managed to fetch it from ftp.mysql.com. A copy is now available here > > as well: > > > > http://jeremy.zawodny.com/mysql/mysql-max-3.23.41-pc-linux-gnu-i686.tar.gz > > Hi, > > Thanks Jeremy for providing the quick work-around. > > I have temporarily fixed this by redirecting to the ftp.sunet.se > mirror. Er.. I have been schnookered by some sunet.se automatching-closest-filename thing (when you click on the .41 links, sunet.se auto-redirects you to .40 files!). Turns out they only have .40 also. :( Fixing... will mail back soon. Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Got and mirrored it... (Re: MySQL-MAX 3.23.41 download link is dead... (need a download))
Jeremy Zawodny writes: > On Thu, Aug 16, 2001 at 06:00:16PM -0700, Jeremy Zawodny wrote: > > > > Does anyone have the latest 3.23.41 I could grab a copy of? > > I managed to fetch it from ftp.mysql.com. A copy is now available here > as well: > > http://jeremy.zawodny.com/mysql/mysql-max-3.23.41-pc-linux-gnu-i686.tar.gz Hi, Thanks Jeremy for providing the quick work-around. I have temporarily fixed this by redirecting to the ftp.sunet.se mirror. The problem is because SourceForge (sometime recently) changed their rsync frequency with us; from every hour to something on the order of days(!) now. :( I have mailed the SourceForge admins to ask if they can fix this. Sorry for the inconvenience! Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fwd: "This Ad Really Works!!!"
Colin Faber writes: > > Is the filter no longer working? We're looking into it. The problem is that I wasn't the one who monkeyed with the new query,database,table "goodword" filter. Sasha did this. I have mailed him about it already. Hopefully he'll have time to look at it later today. Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [fwd] Returned mail: Host unknown (Name server: mailserv: host not found) (from: MAILER-DAEMON@host2.webprovider.net)
Hi, I have removed '[EMAIL PROTECTED]'. Matt Alexander Skwar writes: > Hi! > > Could someone please do anything about this? > > - Forwarded message from Mail Delivery Subsystem ><[EMAIL PROTECTED]> - > > From: [EMAIL PROTECTED] (Mail Delivery Subsystem) > Date: Thu, 26 Jul 2001 19:06:21 +0200 (CEST) > Subject: Returned mail: Host unknown (Name server: mailserv: host not found) > To: <[EMAIL PROTECTED]> > Envelope-to: [EMAIL PROTECTED] > Delivery-date: Thu, 26 Jul 2001 13:05:12 -0400 > Auto-Submitted: auto-generated (failure) > > The original message was received at Thu, 26 Jul 2001 19:06:18 +0200 (CEST) > from handi6-212-144-247-017.arcor-ip.net [212.144.247.17] > >- The following addresses had permanent fatal errors - > > >- Transcript of session follows - > 550 ... Host unknown (Name server: mailserv: host not found) > >- Original message follows - > > Return-Path: [EMAIL PROTECTED] > Received: from newald.homeip.net (handi6-212-144-247-017.arcor-ip.net >[212.144.247.17]) by host2.webprovider.net (8.8.5) id TAA16097; Thu, 26 Jul 2001 >19:06:18 +0200 (CEST) > Received: from localhost (webserv.home.net [192.168.1.50]) > by newald.homeip.net (8.12.0.Beta12/8.12.0.Beta12/8.12.0.Beta12) with ESMTP id >f6QH5QQA030877 > for ; Thu, 26 Jul 2001 19:05:27 +0200 > Received: from 192.41.49.97 [192.41.49.97] > by localhost with POP3 (fetchmail-5.8.5) > for alex@mailserv (single-drop); Thu, 26 Jul 2001 19:05:27 +0200 (CEST) > Received: from web.mysql.com ([EMAIL PROTECTED] [192.58.197.162]) by >host2.webprovider.net (8.8.5) id TAA15997; Thu, 26 Jul 2001 19:04:50 +0200 (CEST) > Received: (qmail 21256 invoked by uid 7797); 26 Jul 2001 16:48:41 - > Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) > List-ID: > Precedence: bulk > List-Help: <mailto:[EMAIL PROTECTED]> > List-Unsubscribe: <mailto:[EMAIL PROTECTED]> > List-Post: <mailto:[EMAIL PROTECTED]> > List-Subscribe: <mailto:[EMAIL PROTECTED]> > Delivered-To: mailing list [EMAIL PROTECTED] > Received: (qmail 21241 invoked from network); 26 Jul 2001 16:48:40 - > Date: Thu, 26 Jul 2001 18:51:30 +0200 > From: Alexander Skwar <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: [fwd] Re: Re: mysql and credit cards (from: [EMAIL PROTECTED]) > Message-ID: <[EMAIL PROTECTED]> > Mime-Version: 1.0 > Content-Type: text/plain; charset=iso-8859-1 > Content-Disposition: inline > Content-Transfer-Encoding: quoted-printable > User-Agent: Mutt/1.3.19i > X-Operating-System: An i686 Linux with Kernel v2.4.6-5mdk > X-Face: nope > X-Sender: [EMAIL PROTECTED] > X-UIDL: dff8ef9a96c5fdc1d2c62b07679acea3 > > database,sql,query,table > > So sprach =3DBBPeter van Dijk=3DAB am 2001-07-25 um 23:59:48 +0200 : > > That is only true for a parallel cipher. A non-parallel cipher (like > > Yep, that's why I said symetrical encryption. Asymetrical enc.'s work > like you explained. > > Alexander Skwar > --=20 > How to quote: http://learn.to/quote (german) http://quote.6x.to (english) > Homepage: http://www.digitalprojects.com | http://www.iso-top.de >iso-top.de - Die g=FCnstige Art an Linux Distributionen zu kommen > Uptime: 3 days 17 hours 34 minutes > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > - End forwarded message - > > PS: sql filter > > Alexander Skwar > -- > How to quote: http://learn.to/quote (german) http://quote.6x.to (english) > Homepage: http://www.digitalprojects.com | http://www.iso-top.de >iso-top.de - Die günstige Art an Linux Distributionen zu kommen > Uptime: 3 days 17 hours 51 minutes > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt
Re: Urgent Help needed for installing
"MikeBlezien" <[EMAIL PROTECTED]> writes: > Hello All, > > >>I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired >with both the binary distro and source distro with no luck. The install seems to go >OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel 2.4.6 i686 >system. > > Please disregard this posting, after blowing everything out and starting from > scratch I was finally able to get the source distro successfully installed now! > :) > > Just one other question, I thought that the source distro 3.23.40 came with BDB > table handlers enabled by default?? Come find out it doesn't!! Is there > something else that needs to be done during the install to enable BDB table > handlers?? Hi, Please read: http://www.mysql.com/doc/B/D/BDB_install.html Regards, Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Testing
Is this working again? -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query Help
[EMAIL PROTECTED] writes:
> Hello, I have a table of 26 million rows that I need to query. The table
> is a keywords database with the keyword and a pointer to what page it
> came off of. (pageid|keyword) The problem is that when I use the
> following query is the group by make the query take about 14 seconds to
> do. However, if I remove the group by portion it finishes the query in
> less then .10.
>
> Here is the query:
> SELECT count(pageid) as n, pageid FROM keywords left join
> deleted_keywords on keywords.keyid = deleted_keywords.keyid where
> deleted_keywords.keyid is null and (keyword = 'Big' OR keyword =
> 'Brown') group by pageid having n = 2 limit 100;
I recognize this query... I'll give you the answer for a papajohns.com
pizza. ;-)
Anyways, looks like Jeremy and Sasha were discussing the optimization
of `OR' in your query on our internal IRC network last night. Looking
at the IRC log, Sasha recommended that you should use:
"... keyword IN('Big', 'Brown') group by ..."
instead of the OR statement. This helps MySQL to decide to use the
index on 'keyword'.
Then Sasha talked with Monty about it, and asked about the
optimization of OR in a query. Monty said that the only time OR is not
optimized is if the OR happens on a different key or a non-key. So
this kind of adds to the confusion. :)
Can you try the "keyword IN()" as I mentioned above. If this doesn't
work, can you tell us the specifics of your setup -- MySQL version,
OS, etc (mysqlbug stuff). Actually mysqlbug output would probably be
desired, as this *may* be a bug in the optimizer. Also, please include
the output from EXPLAIN on all the queries you have tried.
http://www.mysql.com/doc/E/X/EXPLAIN.html
Regards,
Matt
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Saint Paul, Minnesota, USA
<___/ Developer
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: socket problem in red hat.
[EMAIL PROTECTED] writes:
> Hi there,
> I am setting up a lab on MySQL and I am not able to.
> Its a red hat 7.0 server and has PHP installed and working with apache.
> I installed MySQL from the very RPMs Red Hat provided.
> Whenever I try to start the server, I get the error message:
>
> Can't connect to local MySQL server through socket '/var/lib/mysql/m
> ysql.sock' (111)
>
> Well the file /var/lib/mysql/mysql.sock exists on the computer. I can't
> understand what this socket problem is and I went through all documentation
> and couldn't find a solution to this. Can you please provide a solution to
> this
> at the earliest. I have students piling on my head and I have already
> skipped my deadline of setting the server up.
Hi!
We have seen this problem (although I have not personally
investigated) with many RH7+default_mysql. The quick and easy solution
(until I figure out further) is to download the MySQL RPMs from:
http://www.mysql.com/downloads/mysql-3.23.html
Uninstall the standard RedHat 7.0 MySQL RPMs, then reinstall
ours. Like I said, I'm not sure what RedHat is doing wrong with their
MySQL RPMs... But I have seen this numerous times with regard to their
supplied RPMs. Something is amiss.
I will investigate more.
Regards,
Matt
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA
<___/ Developer
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP and MySQL combo
Mike Yuen writes: > Is there anyway to tell how many connections are currently being served by > MySQL. I'm using this in combination with PHP. Also, does MySQL > automatically shut down when you leave the page? I'm not using > mysql_pconnect - just the regular mysql_connect. Hi! You are probably looking for 'SHOW STATUS': http://www.mysql.com/doc/S/H/SHOW_STATUS.html And yes, if you are NOT using mysql_pconnect, the connection to your mysqld is closed each time. The 'p' in 'mysql_pconnect' is for "persistant" which avoids this problem. :) Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help me to write a sql,please :)
Rolf Hopkins writes: > select colname > from tablename > where (where clause) > order by b,a,c > > This is all in the manual. If you have a search on the internet, you should > be able to find a manual in chinese, if you haven't already got one. I know > there is one in traditional chinese, but I'm sure there is one for > simplified as well. Hi! I just added a link (the other day) for a Chinese translation of the MySQL Manual (encoded in GB) to the main documentation page: http://www.mysql.com/documentation/ Hope this helps! Regards, Matt -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h
Greg Cope writes: > Chris Johnson wrote: > > > > >Description: > > I just downloaded MySQL 3.23.31 and the "patched version" of > > Berkeley DB 3.2.3h from the www.mysql.com site. I ran configure > > with the option to enable the Berkeley DB, but it fails, telling > > me I don't have the proper version of the DB. Here are the last > > few lines from the configure output: > > This sounds similar to a problem that I reported a few hours ago to this > list. > > Monty, MySQL dev team, any ideas ? I've forwarded Chris's report to bugs@. Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: DuBois' book
Adel Sabet writes: > Dear subscribers > > I just baught the book "mySQL" from DuBois and it refers to a sample > data base called samp_db. This data base should be on the url: > www.mysql.com/contrib/rxamples/ Hi! I see someone else has already answered with the correct URL you need. But I would like to know on what page in Dubois' book that you found the URL you quote above? Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: fixed width
phiLLip maDDux II writes:
> Hello,
>
> I am working on loading data into a table from a text file. I've read
> the documentation on the LOAD DATA command. But I noticed that it only
> works with some kind of delimited file. Is there any way to load a
> fixed width file???
Hi!
Unfortunately this is not possible with just LOAD DATA INFILE or
`mysqlimport'. :(
You will have to write some small program that parses your file into
some delimited form. For instance here is a simple one in Perl:
mwagner@evoq ~-> cat datafile
aabb
ccdd
eeff
gghh
1234
mwagner@evoq ~-> cat deli_parse.pl
#!/usr/bin/perl
while (<>) {
m/^(.{2})(.{2})$/;
print "$1,$2\n";
}
mwagner@evoq ~-> cat datafile | perl ./deli_parse.pl
aa,bb
cc,dd
ee,ff
gg,hh
12,34
Hopefully you can figure out how to adjust the perl regular expression
"m/^(.{2})(.{2})$/;" to suit your needs. Each "(.{2})" unit in the
expression matches one chunk of data 2 characters long, and stores the
trapped data in the variable $1. Adjust the '2' and add more trapping
units to fit your data file.
After you have this file delimited, then it should be trivial to load
it into MySQL using either the LOAD DATA INFILE syntax or the
`mysqlimport' utility.
Regards,
Matt
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA
<___/ Developer
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [RedHat 6.2 RPM install: 'perl5', changing password]
[EMAIL PROTECTED] writes: > >Description: > Installed: > * MySQL-3.23.27-1.i386.rpmMySQL-shared-3.23.27-1.i386.rpm > * MySQL-client-3.23.27-1.i386.rpm MySQL-devel-3.23.27-1.i386.rpm > > #1) > Had to use "--nodeps" so the server and client portions would pass > the "/usr/bin/perl5" dependency check. I tried doing > > # cd /usr/bin; ln perl perl5 > > It would be nice if the dependency could be met by looking for any > /usr/bin/perl5*. (E.g. my system has '/usr/bin/perl5.00503'). Yes this would be nice. But this is a deficiency in the RPM system. :( This dependency has been corrected to /usr/bin/perl in the new 3.23.31 RPMs. > #2) > The installation script said to change the database password via: > > # /usr/bin/mysqladmin -u root -p password 'new-password' > # /usr/bin/mysqladmin -u root -h pipek.truedisk.com -p password >'new-password' > > It doesn't work! What do you mean, "It doesn't work"? What does it do? > > > > 4. Try changing the password ... > > # /usr/bin/mysqladmin -u root -p password newpass > Enter password: > /usr/bin/mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: 'root@localhost' (Using password: YES)' > # /usr/bin/mysqladmin -u root -h pipek.truedisk.com -p password newpass > Enter password: > /usr/bin/mysqladmin: connect to server at 'pipek.truedisk.com' failed > error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: >YES)' > >Note--typed "password" when prompted There *may* (?) be some confusion here with the usage of the '-p' option. If you did everything verbatim as you stated above, then you the root password is currently (at your point of failure) set to nothing. So when the "Enter password:" prompt comes, just hit enter. After this, 'newpass' will take effect. Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug in MySQL TRIM() Function! ?
Paul Wisén writes:
> This works:
>
> mysql> select trim('foo' FROM 'foobaar');
> ++
> | trim('foo' FROM 'foobaar') |
> ++
> | baar |
> ++
> 1 row in set (0.00 sec)
>
> This does not work: !
>
> mysql> select trim('foo' FROM 'foo');
> ++
> | trim('foo' FROM 'foo') |
> ++
> | foo|
> ++
> 1 row in set (0.00 sec)
>
> I was expecting a null string from this one.. But nope ??
>
> Why ? Is it a bug?
Hi!
Since 'foo' in your latter case is neither strictly a prefix or suffix (as defined
by the TRIM() documentation); I'm not sure if this a bug in the code
or something that needs to be clarified in the documentation.
Monty?
Matt
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA
<___/ Developer
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: can i buil mysql database in win98
cpcs writes: > sir, > can i build mysql database in win 98 and install on server runnin on > winNT Hi! Yes. Although, technically, the database will reside with the server installation on the NT machine. :) You just need the *client* program(s) on your win98 box. http://www.mysql.com/doc/m/y/mysql.html Because we don't distribute a "clients only" package for the win32 platform, you will have to install MySQL on both your win98 and NT systems. You just won't be using the MySQL server binary that is installed on the win98 system. If you don't want to do that, you could just install MyODBC on your win98 box, and connect to MySQL running on your NT box thru ODBC -- using your choice of ODBC compliant programs (access?). http://www.mysql.com/downloads/api-myodbc.html Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Win 95/98/nt
Chetram Ramnarain writes: > Hello, > > I am trying to download a copy of MySQL for my Win 98/NT computer. There are > so many different kinds of downloads, which one do I choose. Which > documentation do I need? HELP! Anyone. I am trying to learn this software, > as it was recommended to me. Hi! On: http://www.mysql.com/downloads/mysql-3.23.html The second to the last link in the "Standard binary (tarball) distributions" section: o Windows 95/98/NT/2000 (Intel) More specifically: http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.30-gamma-win.zip Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connection Refused
[EMAIL PROTECTED] writes: > I've spent most of this day reading and rereading the documents on setting up > MySQL. I'm currently working on NIDS and have setup MySQL on the same box as > the sensor for logging of packets to verify that I had the NIDS setup > correctly for db logging. I then installed MySQL (binary rpm version) on a > server and configured it. I added the user (who also exists on that > system) and granted it insert and select privledges and set the host to be a > class b subnet (xxx.xxx.0.0/255.255.0.0). when I try to test the connection > remotely I get an error (1130) saying Host '' is not allowed to connect. The > machine has no DNS entry and since the system is from that range of IP's I > don't see why it says connection refused. Sounds like a problem with reloading the privileges table. Did you actually use the "GRANT" statement to add these privileges? If not -- if you just did an INSERT/UPDATE -- then you need to issue a "FLUSH PRIVILEGES" or "mysqladmin -u root -p reload". If you *did* use a GRANT statement, then reloading of the privilege tables is automatic. http://www.mysql.com/doc/P/r/Privilege_changes.html > While logged in locally at the box I tried doing a telnet localhost 3306 and > got a refused connection, but when I tried telnet 3306 I get a few > garbage characters (this is from the box that will do the logging to > itself). When I tried telnetting from the remote box I again get the host not > allowed message. Refused connection from localhost must have something to do with local firewall rules. Nothing that MySQL is doing (at the level of making a TCP/IP connection) would result in this kind of behavior (localhost refused; remote allowed). Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication: Please help!!
Jeremy D. Zawodny writes: > On Thu, Jan 18, 2001 at 01:21:05PM -0700, Basuki Setiawan wrote: > > So do I > > In their usual amazing fashion, the MySQL team responded very quickly > and put the changes online only hours after I sent them a diff. This is only because you caught all of us (that are in the western hemisphere) awake at the same time. :-) Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: forwarded message from Brian Kaney
Sasha Pachev writes: > > > > We will add a stricter sanity check for the referers to work around > the bugs in some browsers. Completo. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: date_format
Cindy writes:
>
> OK. I went to the documentation at www.mysql.com and typed in
> DATE_FORMAT in the search box, hopefully find a list of the %M's, etc
> rules that may be used (I'd like December to become Dec, etc). No
> dice. Randomly looking through sections that came up under "DATE"
> search didn't yield any other info on DATE_FORMAT. 20 minutes later,
> I surrender. Where would I find out the info on DATE_FORMAT I'm
> looking for?
Hi!
There are 2 search methods on our website. There is the site-wide
search that appears in the upper left corner of the front page; and
then there is the localized search of the commented manual.
I'm assuming you used the site-wide search... I can't understand why
it is producing no results for 'DATE_FORMAT'. I will look into it.
However, when I tried your search query in the localized commented
manual search (http://www.mysql.com/doc/), the correct item came in
as the second search result.
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
So my suggestion to you is to use the commented manual
search. Meanwhile I will try to figure out why UdmSearch (site-wide)
is not working like it should.
Regards,
Matt
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA
<___/ Developer
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Virus Test Attachment
Matt Wagner writes: > Hi all, > > Just testing ezmlm's attachment filter to make sure our changes catch > this 'Emanual.exe' from "funky gao". > > Attachment should be here: Okay, looks like we are all GO Houston. Matt -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: lockup in test suite
Robert Marchand writes: > Hi, > > I have download the latest binary distribution for SGI Irix: > mysql-3.23.30-gamma-sgi-irix6.5-mips and it lock when I try the test > suite: Hi! Could you send this message along with the a report filled out with `mysqlbug' to [EMAIL PROTECTED]? Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Virus Test Attachment
Hi all, Just testing ezmlm's attachment filter to make sure our changes catch this 'Emanual.exe' from "funky gao". Attachment should be here: Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fw: Mysql v3.23.30 make test failed ('select * from foo')
Steve Costaras writes: > > >Description: > Trying to upgrade mysql from v3.22.32 to latest version 3.23.30, > configured and compiled fine on the system. Ran the test suite and > it discovered an error. Would like to know if this is a known bug > (ignore?) Or what can be done to fix things. Yes, this is known. There are some issues with testing replication that still need to be worked out (timing issues). I think the plan is to have this cleaned up for the 3.23.31 release. You can just ignore these failed replication (rpl0*) tests. They are not indicative of the replication functionality (yet). Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql privileges problem
Chee-Siong Cheong writes: > Hi everyone, > > Recently I accidentally modify the user permission of "root" from > "localhost" to "any" with webmin. After I modified, I can no longer connect > to the database with my machine, the error is > > ERROR 1045: Access denied for user: '@localhost' > > > What can I do to change it back to the original mode? Thanks in advance. Hi! Restart your mysqld with '--skip-grant-tables', you will not need a password, nor will you need to be on the bogus host "any". :) Once in, correct the problem, and then restart mysqld (without the '--skip-grant-tables'). Note that this is basically an FAQ. You should have searched the MySQL Manual and/or the Mailing List Archive before posting: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) If you *did* do this before posting, my apologies... It was not very apparant that you had. :( Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1044
Franck ABELLI writes:
> To change the root password i connected to mysql: bin/mysql
> mysql>connect mysql localhost
> mysql>UPDATE user set Password='***' where User='root';
> ->No problems
> mysql>SELECT User,Password FROM user;
> -> to verify if the pass was set... it was.
>
> then i stopped mysql and restart it and it was impossible connecting
> again. here is the detailed result :
>
> Linux>bin/mysql -u root -p
> Enter password :
> mysql >use mysql
> Database changed
> mysql>SELECT * FROM user;
> ERROR 1044:Access Denied for user: '@localhost' to database 'mysql'
> ERROR:
> can't connect to the server
>
>
> sure,i made mistakes, but now how can i recover my Mysql ?
Hi!
If you are going to go about setting the password in this fashion,
then you need to make sure to use the password() function in your
UPDATE statement. For example:
UPDATE user set Password=password('***') where User='root';
To connect to your server in it's current state (with bad root passwd)
you need to start mysqld with the '--skip-grant-tables' option.
In the future, instead of restarting the mysql daemon for changes to
the grant tables to take effect, check out 'FLUSH PRIVILEGES'.
http://www.mysql.com/manual.php?section=FLUSH
Regards,
Matt
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA
<___/ Developer
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: rpm requires perl5 on redhat 7.0
Matt Wagner writes: > SATYAN NAIR writes: > > dear friends, > > i am not able to install MySQL-3.23.30-1.i386.rpm on redhat 6.2 and 7.0 > > it says REQUIRES PERL5 at /usr/bin/perl5 > > and under /usr/bin i have perl as well as perl5.006 > > > > > > please let me know how do i install the rpm on linux!! > > Hi! > > We have fixed this problem for the *upcoming* 3.23.31 release. For > now, you can just pass '--no-deps' to the RPM install command, and it > should work. Doh! That should be '--nodeps'. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Please read the manual
Neff Patrick K writes: > > > > I in fact finally got mysql up and running last night but not one > word in your manual helped me do it. So in fact all the reading in > the world would have left me sitting in the same position. Neff, What stumbling blocks in the documentation did you run across? What can we add (new sections, rewordings, etc) to help the many that will likely follow the same frustrating path you just did? Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: rpm requires perl5 on redhat 7.0
SATYAN NAIR writes: > dear friends, > i am not able to install MySQL-3.23.30-1.i386.rpm on redhat 6.2 and 7.0 > it says REQUIRES PERL5 at /usr/bin/perl5 > and under /usr/bin i have perl as well as perl5.006 > > > please let me know how do i install the rpm on linux!! Hi! We have fixed this problem for the *upcoming* 3.23.31 release. For now, you can just pass '--no-deps' to the RPM install command, and it should work. Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Lazy
Quentin Bennett writes: > Perhaps, along with the 'Please check the manual' message at the end of all > messages, there should be a reference to a reliable archive, allowing list > users who are referred to the archive an easy way of finding it! Done. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Testing new trailer
Testing new trailer message. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail <[EMAIL PROTECTED]> If you are having troubles with unsubscribing, try: http://lists.mysql.com/php/unsubscribe.php
Re: Other uses for admin
Carlos Corzo writes: > Hello, > > Other than installing the .pkg file into the server and running it > through his interface, do I need to get the server admin to do anything > else? I am afraid that I am running out of time with him, meaning, I am > running out of time with root priviledges. I am trying here. We have > tried all sorts of crap but nothing. What would be beautiful is just a > small sample creation of a database. I have tried the sample I have but > did not work very well! Hi! Alright, there are only a few steps where you need your admin guy. Here's what you need to do: shell> mysqladmin -u root --password=? create carlos_database shell> mysql -u root --password=? mysql -> GRANT ALL ON carlos_database.* TO carlos@"%_" IDENTIFIED BY -> 'carlos_password'; -> FLUSH PRIVILEGES; -> exit; After this is done, you (Carlos) will be able to connect to your database 'carlos_database' (or whatever you want to call it) as user 'carlos' (again, or whatever you chose for a username) with password 'your_password' (again, you can guess what I'm about to say :). Once connected you can create all tables and whatnot yourself. Note that the SQL Grant statement above will allow the user 'carlos' to connect from _any_ machine. This *may* be a security issue...? But without knowing more about your exact needs, this should work. For more info about GRANT look at: http://www.mysql.com/manual.php?section=GRANT For clarity, note that 'shell>' indicates the UNIX Shell -- and '->' indicates the MySQL Shell. Hope everything works for you! Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: Please read the manual
Eric Fitzgerald writes: > > > > Also, might it be possible to move the manual comments to another > list? :) I have decided to stop the [DOCS COMMENT] flood. *Most* comments were completely useless... even though I added in BIG RED LETTERS that adding a comment to the manual is not a good place to ask questions. :( I guess it proves the need for some alternate forum for newbies to ask questions. Apparantly joining the mailing list is too daunting for beginners. We will soon begin to moderate the comments in the manual, to remove the cruft. Maybe during this moderation, we (the people moderating) can forward *interesting* comments (and questions if they come up) to the list for all to share. Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: [Make Crashes and Burns on myisam - "Don't know how to make mi_test_all"]
[EMAIL PROTECTED] writes: > > > > >How-To-Repeat: >As far as I know, just try building it on an i386 running BSDI 4.1 Sinisa, Who was the guy that just contributed the BSDI 4.2 tarball? Maybe he could give Aaron here some pointers. Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Re: Some problems
Bob Hall writes: > >This is the first time I've ever been directly in charge of adminstering a > >mysql server. I have a few questions. Since I can't get mysql 3.23.X to > >install, I'm stuck with 3.22.30 and I was wondering what I could do to > >facilitate backups, and to be able to protect my data integrity. I'm at the > >moment taking a mysqldump every 5 minutes via a CRON job, but I'm sure there > >are better facilities available to me. > > > >If anyone has some suggestions I'd appreciate it. (I'd also appreciate some > >assistance with my make problem in 3.23.x) > > Sir, go down to the local bookstore and buy a copy of "MySQL" by Paul > DuBois, published by New Riders. If the local bookstore doesn't have > it, order it from Amazon and have it shipped FedEx overnight. I was > in your situation about 8 months ago and Paul's book saved my sorry > attitude. Or better than going to Amazon, go to the MySQL Books page: http://www.mysql.com/documentation/books.html And order your copy from Barnes and Noble through the links provided. By doing this, B&N will give the MySQL Development team a small kick-back. This helps fund development! Also, Amazon has got that whole sticky "trying to patent web clicks" issue that the Free Software Foundation (and MySQL AB) is boycotting. :) Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA <___/ Developer -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
