[Phpmyadmin-news] phpMyAdmin 2.4.0 released

Marc Delisle DelislMa at CollegeSherbrooke.qc.ca
Sun Feb 23 13:50:03 CET 2003

phpMyAdmin 2.4.0 - February 23rd, 2003

   A set of PHP-scripts to administrate MySQL over the WWW.


    After 7 months of work and 2 release candidate versions,
    the phpMyAdmin developers are pleased to announce the availability
    of phpMyAdmin 2.4.0.

    phpMyAdmin is intended to handle the administration of MySQL over
    the Web, and is now one of the most popular PHP script used
    worldwide: more than 3.1 million download in the past year!

    SourceForge gave phpMyAdmin the "Project of the Month" award in
    December: look at the article http://sourceforge.net/pom_1202.php
    to learn more about the project's history.

    phpMyAdmin 2.4.0 includes the following highlights:


   Some improvements:

      * PDF pages
         - new data dictionary
         - support for deleting a PDF page definition
         - better browser support
      * cookie login: login error message
      * new server/user management interface with sub-pages
         - more intuitive interface
         - interface to most MySQL status variables
         - server traffic & query statistics
         - support new MySQL 4 privileges
         - support for user resource limits
         - privileges may now be edited without reloading the user tables
         - copy user profiles
      * Export
         - export to LaTeX format
         - better handling of charset conversion
         - better output order of inserts/creates
         - export results of any single-table SELECT
      * option to only copy data (append) to a table
      * better handling of confirmation requests (bookmarks) and LIMIT
      * support EXTRACT ... FROM
      * check/uncheck all for field selection
      * moving cursor with ctrl/arrows in table creation and row editing
      * images in PNG format where possible
      * display UPDATE SQL statement after a row edit
      * in Select sub-page, drop-down for ENUMs
      * support for compressed connections to the MySQL server
      * upload of binary file into a field
      * new documentation layout
      * (for phpMyAdmin developers) interface to DBG extension for
      * show blob size

   Some fixes:

      * output handler warning for PHP >=4.3.0
      * usernames with "@" character
      * links or submit buttons for db search results
      * warning for bzip problem of PHP 4.2.1
      * wrong "Back" links
      * UNION processing generated undefined variables
      * handling of "LOCAL" in recent MySQL versions for LOAD DATA INFILE
      * wrong drop-down for foreign keys in Select sub-page
      * wrong charset information in XML exports
      * parsing error for the single quote case
      * problem with SQL validator interface
      * wrong parsing of INTERVAL and AUTO_INCREMENT
      * no longer allow invalid options like UNSIGNED in SET/ENUM
      * problem entering comments in Relation view
      * fix for kanji encoding problem
      * empty field names on add fields page caused problems
      * the quicklinks on top of each page are now pointing to the 
    default tabs
      * problem with recieving the database list with MySQL >= 4.0.2-alpha
      * adjusted font sizes for Opera 7 for Windows and Konqueror
      * problems with editing the contents of the SQL query boxes with 
Opera 7
        for Windows
      * query-by-example and only one table
      * do not display edit link for database-independent queries
      * fix some of the problems with record counting

   Detailed list of changes since version 2.2.0 is available under

     This software is available under the GNU General Public License V2.0.

     You can get the newest version at http://www.phpmyadmin.net/
     Available file formats are: .zip, .tar.gz and .tar.bz2.

     If you install phpMyAdmin on your system, it's recommended to
     subscribe to the news mailing list by adding your address under

     This way, you will be informed of new updates and security fixes.
     It is a read only list, and traffic is not greater than a few
     mail every year.

Support and Documentation

     The documentation is included in the software package as text and
     HTML file, but can also be downloaded from:


     The software is provided as is without any express or implied
     warranty, but there is a bugs tracker page under:

        http://sourceforge.net/projects/phpmyadmin/   [click on "Bugs"]

     In addition, there are also a number of discussion lists
     related to phpMyAdmin.  A list of mailing lists with archives
     is available at:

        http://sourceforge.net/mail/?group_id=23067  or
        http://sourceforge.net/projects/phpmyadmin/   [click on "Lists"]

     Finally, an users support forum is also available under:


Known bugs

   * The total number of rows of UNION SELECT is not calculated correctly.
   * Some users reported problems on machines running Zend Accelerator (TM).
   * The MySQL 4.1.x and php 5.0.x branches are not yet supported by 
   * Displaying large exports may crash Microsoft Internet Explorer.
   * When renaming tables or fields the relations set in phpMyAdmin are 

   To be informed about new releases fixing these problems, please
   subscribe to the news mailing list under
   or regularly check the sourceforge bugs tracker.


   phpMyAdmin is intended to handle the administration of MySQL over the 
WWW. It can manage a whole MySQL server as well as a single database.

     Currently it can:
       - create and drop databases
       - create, copy, drop, rename and alter tables
       - do table maintenance
       - delete, edit and add fields
       - execute any SQL-statement, even batch-queries
       - manage keys on fields
       - load text files into tables
       - create and read dumps of tables
       - export data to CSV, XML and Latex formats
       - administer multiple servers
       - manage MySQL users and privileges
       - check referential integrity
       - using Query-by-example (QBE), create complex queries automatically
         connecting required tables
       - create PDF graphics of your Database layout
       - search globally in a database or a subset of it
       - communicate in 42 different languages

Author & Copyright

     Copyright (C) 1998-2000 Tobias Ratschiller
     Copyright (C) 2001-
     Marc Delisle <DelislMa_at_CollegeSherbrooke.qc.ca>
     Olivier Müller <om_at_omnis.ch>
     Loïc Chapeaux <lolo_at_phpHeaven.net>
     Robin Johnson <robbat2_at_users.sourceforge.net>
     Armel Fauveau <armel.fauveau_at_globalis-ms.com>
     Steve Alberty <alberty_at_neptunlabs.de>
     Alexander M. Turek <rabus_at_users.sourceforge.net>
     Mike Beck <mikebeck_at_users.sourceforge.net>
     Michal Cihar <nijel_at_users.sourceforge.net>
     Garvin Hicking <hicking_at_faktor-e.de>
                 + many other people
     (check the CREDITS section of our documentation)

     This program is free software; you can redistribute it and/or modify
     it under the terms of the GNU General Public License as published by
     the Free Software Foundation; either version 2 of the License, or
     (at your option) any later version.

     This program is distributed in the hope that it will be useful,
     but WITHOUT ANY WARRANTY; without even the implied warranty of
     GNU General Public License for more details.

     You should have received a copy of the GNU General Public License
     along with this program; if not, write to the Free Software
     Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 
02111-1307  USA

EOF -- Alexander M. Turek / 2003-02-23

More information about the News mailing list