Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted Feb 13, 2004

MySQL 4.0.18 released

By DatabaseJournal.com Staff

[From MySQL AB]

The latest production version of MySQL was released on February 12. This release includes added and changed functionality and bug fixes.

C.3.2 Changes in release 4.0.18 (12 Feb 2004)

Functionality added or changed:

  • Fixed processing of LOAD DATA by mysqlbinlog in remote mode. (Bug #1378)
  • New utility program `myisam_ftdump' was added to binary distributions.
  • mysqlhotcopy now works on NetWare.
  • ENGINE is now a synonym for the TYPE option for CREATE TABLE and ALTER TABLE.
  • lower_case_table_names system variable now can take a value of 2, to store table names in mixed case on case-insensitive filesystems.
  • For replication of HEAP tables: Made the master automatically write a DELETE FROM statement to its binary log when a HEAP table is opened for the first time since master's startup. This is for the case where the slave has replicated a non-empty HEAP table, then the master is shut down and restarted: the table is now empty on master; the DELETE FROM empties it on slave too. Note that even with this fix, between the master's restart and the first use of the table on master, the slave still has out-of-date data in the table. But if you use the init-file option to populate the HEAP table on the master at startup, it ensures that the failing time interval is zero. (Bug #2477)

The article continues at http://www.mysql.com/doc/en/News-4.0.18.html

Database News Archives

Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM