The Internet, 2003-06-02
Greetings,
the phpMyAdmin development team is pleased to announce availability of
phpMyAdmin 2.5.1.
Improvements:
* LaTeX export
* Show multi-statement query result
* Support for iconv parameters
* Nested display of tables
* CSV import from upload dir.
* Save export to server
* Check for same db/table when moving
* Detection of missing scheme
* Initial SQL box when no db exists
* Reset button on edit page
* Optional bigger textarea for LONGTEXTs
* Show last inserted auto-increment id
* Multi-tables CSV export
* Can now disable ctrl-arrows moving
* Export interface: can now override the use of LOCAL
* Experimental MySQL 4.1 support
Fixes:
* Safari browser frame problems
* "insert as another row" state
* Confirmation when dropping databases
* Light tabs displayed wrong
* No longer saves in the history a query that generates an error
* Error when not using backquotes in export
* Incorrect "Create PHP code"
* Edit link error
* Better PDF schema
* Incorrect GD2 detection
* Avoid long delays when counting millions of rows
* Empty value in ENUM
* Frameset and XHTML
* Execution of query in PHP code view
* Hexification of BLOB when empty
* Tabs highlighing
* Wrong clickable columns and tool-tips with column alias
* Behavior when clicking "Databases"
* Invalid back link on invalid queries
* Interface to SQL Validator
* Correct parser behavior for "CHARACTER SET" and "SHOW INNODB STATUS"
Download/support information on http://www.phpmyadmin.net.
Marc Delisle, for the team.
The Internet, 2003-05-26
To: phpMyAdmin community
The development team is pleased to announce version 2.5.1-rc1
(first release candidate) of phpMyAdmin.
MySQL 4.1 note:
phpMyAdmin 2.5.1 is not ready for MySQL 4.1.
Improvements:
* LaTeX export
* Show multi-statement query result
* Support for iconv parameters
* Nested display of tables
* CSV import from upload dir.
* Save export to server
* Check for same db/table when moving
* Detection of missing scheme
* Initial SQL box when no db exists
* Reset button on edit page
* Optional bigger textarea for LONGTEXTs
* Show last inserted auto-increment id
* Multi-tables CSV export
* Can now disable ctrl-arrows moving
Fixes:
* Safari browser frame problems
* "insert as another row" state
* Confirmation when dropping databases
* Light tabs displayed wrong
* No longer saves in the history a query that generates an error
* Error when not using backquotes in export
* Incorrect "Create PHP code"
* Edit link error
* Better PDF schema
* Incorrect GD2 detection
* Avoid long delays when counting millions of rows
* Empty value in ENUM
* Frameset and XHTML
* Execution of query in PHP code view
* Hexification of BLOB when empty
* Tabs highlighing
* Wrong clickable columns and tool-tips with column alias
* Behavior when clicking "Databases"
* Invalid back link on invalid queries
Download links, as usual, on http://www.phpmyadmin.net
Marc Delisle, for the team.
The Internet, 2003-05-11
To: phpMyAdmin community
The development team is pleased to announce version 2.5.0 of phpMyAdmin.
MySQL 4.1 note:
phpMyAdmin 2.5.0 is not ready for MySQL 4.1.
About future versions:
The versions after 2.5.x will have those requirements:
PHP >=4.1.0 and MySQL >=3.23.32.
Improvements:
* distinct Query window
* field contents transformations (inline resized images, links,
external programs, etc)
* display column comments in exports
* automatic update of relations, display fields, comments,
bookmarks, etc after table/column changes
* new display mode with 90 degree rotated headers
* display query time
* js row marker now works in vertical mode
* SQL history: db- or not-db-based
* optional vertical display of the columns in edit mode
* optional lightweight menu tabs
* InnoDB status monitor
* print button in db view
* new Export page with dynamic options
* better security for docSQL importer
* in edit mode, display first the functions that match field type
* parameters for bookmarks queries
* support for changing auto-increment value
* default initial query in browse mode, based on a bookmark with
the same name as the table
* execute bookmarks when browsing bookmarks table
* if available, display Create/Update/Check_time
* in browse mode, highlight the fields used in the WHERE condition
for the query
* automatic layout of the PDF schema
* choose results page in browse mode
* automatic detection of compression for uploaded data
* CHECK TABLE/ANALYZE TABLE for multisubmit actions
* support for SHOW FULL PROCESSLIST
* can now insert multiple fields at cursor position in the query
textarea
* can now choose all segments of a key (relations)
Fixes:
* could not insert some words like "$enum$"
* bad URL (extra /) for generated PDFs
* double password query with http auth
* check privileges only shows root user
* display SQL query used for an index modification
* pdf schema headers footers for long pages
* export results and LIMIT
* inserting values with quotes
* $cfg['PmaAbsoluteUri'] autodetection and CGI mode
* escaping of \n, \r and \t characters
* handling of disabled ini_get()
* go back to fields definition form after an error
* support XOR in the parser
* check for field type when doing charset conversion
* support for HTML entities as db/table/column names
* avoid long delays when browsing big tables (MySQL 4)
* support for host-based privileges
* bad arrow aligning on PDF schema in "same widths" mode
* faster record count
* "undefined index" error in the data dictionary when using MySQL
3.22 or below
* the privileges administration script did not work well with
host-based DB privileges
* having added a new user, the corresponding SQL query was not
displayed
* better "superuser" checking mechanism
* "wrong parameter count" error when connecting with some strangely
compiled php versions
* replaced the %e placeholder in the date format string of some
translations because it did not have any effect on Windows machines.
* unaligned column headers
* MONTH() and YEAR() not displayed as functions
* error on "Skip Explain SQL"
* bad Edit link on tables without primary key but with BLOB
* now we export BLOBs hex quoted
* better check for superuser in MySQL 4
* 2.5.0-rc1 syntax error SHOW TABLE STATUS LIKE...
* highlight fields crossing db borders
* FULLTEXT index type not shown in drop-down
* disable CSV export for multiple tables
Download links, as usual, on http://www.phpmyadmin.net
Marc Delisle, for the team.
The Internet, 2003-04-25
To: phpMyAdmin community
The development team is pleased to announce version 2.5.0-rc2
(second release candidate) of phpMyAdmin.
This one includes about 15 bug fixes from -rc1, along with
updated translations.
Final version is planned for mid-May.
Download links and the detailed ChangeLog available on
http://www.phpmyadmin.net.
Marc Delisle, for the team.
The Internet, 2003-04-13
To: phpMyAdmin community
The development team is pleased to announce version 2.5.0-rc1
(first release candidate) of phpMyAdmin.
Improvements:
* distinct Query window
* field contents transformations (inline resized images, links,
external programs, etc)
* display column comments in exports
* automatic update of relations, display fields, comments,
bookmarks, etc after table/column changes
* new display mode with 90 degree rotated headers
* display query time
* js row marker now works in vertical mode
* SQL history: db- or not-db-based
* optional vertical display of the columns in edit mode
* optional lightweight menu tabs
* InnoDB status monitor
* print button in db view
* new Export page with dynamic options
* better security for docSQL importer
* in edit mode, display first the functions that match field type
* parameters for bookmarks queries
* support for changing auto-increment value
* default initial query in browse mode, based on a bookmark with
the same name as the table
* execute bookmarks when browsing bookmarks table
* if available, display Create/Update/Check_time
* in browse mode, highlight the fields used in the WHERE condition
for the query
* automatic layout of the PDF schema
* choose results page in browse mode
* automatic detection of compression for uploaded data
* CHECK TABLE/ANALYSE TABLE for multisubmit actions
* support for SHOW FULL PROCESSLIST
* can now insert multiple fields at cursor position in the query
textarea
Fixes:
* could not insert some words like "$enum$"
* bad URL (extra /) for generated PDFs
* double password query with http auth
* check privileges only shows root user
* display SQL query used for an index modification
* pdf schema headers footers for long pages
* export results and LIMIT
* inserting values with quotes
* $cfg['PmaAbsoluteUri'] autodetection and CGI mode
* escaping of \n, \r and \t characters
* handling of disabled ini_get()
* go back to fields definition form after an error
* support XOR in the parser
* check for field type when doing charset conversion
* support for HTML entities as db/table/column names
* avoid long delays when browsing big tables (MySQL 4)
* support for host-based privileges
* bad arrow aligning on PDF schema in "same widths" mode
* faster record count
* "undefined index" error in the data dictionary when using MySQL
3.22 or below
* the privileges administration script did not work well with
host-based DB privileges
* having added a new user, the corresponding SQL query was not
displayed
* better "superuser" checking mechanism
* "wrong parameter count" error when connecting with some strangely
compiled php versions
* replaced the %e placeholder in the date format string of some
translations because it did not have any effect on Windows machines.
Download links, as usual, on http://www.phpmyadmin.net
Marc Delisle, for the team.
phpMyAdmin 2.4.0 - February 23rd, 2003
======================================
A set of PHP-scripts to administrate MySQL over the WWW.
-----------------------------------------
Announcement
------------
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:
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
debugging/profiling
* 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
http://www.phpmyadmin.net/ChangeLog.txt
Availability
------------
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
http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news
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:
http://www.phpmyadmin.net/documentation/
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:
http://sourceforge.net/forum/forum.php?forum_id=72909
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
phpMyAdmin.
* Displaying large exports may crash Microsoft Internet Explorer.
* When renaming tables or fields the relations set in phpMyAdmin are
lost.
To be informed about new releases fixing these problems, please
subscribe to the news mailing list under
http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news
or regularly check the sourceforge bugs tracker.
Description
-----------
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
<tobias.ratschiller_at_maguma.com>
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
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
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
The Internet, 2003-02-17
To: phpMyAdmin community
The development team is pleased to announce version 2.4.0-rc2
(second release candidate) of phpMyAdmin.
The test cycle is going well, testers of -rc1 found some bugs
so -rc2 is better :) and contains a more polished new privileges/db
management system.
Improvements:
* PDF pages
o new data dictionary
o support for deleting a PDF page definition
o better browser support
* cookie login: login error message
* new server/user management interface with sub-pages
o more intuitive interface
o interface to most MySQL status variables
o server traffic & query statistics
o support new MySQL 4 privileges
o support for user resource limits
o privileges may now be edited without reloading the user tables
o copy user profiles
* Export
o export to LaTeX format
o better handling of charset conversion
o better output order of inserts/creates
o 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
* (experimental) 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
debugging/profiling
* show blob size
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 receiving the database list with MySQL >=
4.0.2-alpha (in CVS)
* adjusted font sizes for Opera 7 for Windows and Konqueror (in CVS)
* problems with editing the contents of the SQL query boxes with
Opera 7 for Windows (in CVS)
* query-by-example and only one table
* do not display edit link for database-independent queries
* fix some of the problems with record counting
Download links, as usual, on http://www.phpmyadmin.net
Marc Delisle, for the team.
The Internet, 2003-02-02
To: phpMyAdmin community
The development team is pleased to announce version 2.4.0-rc1
(first release candidate) of phpMyAdmin.
Improvements:
* PDF pages
o new data dictionary
o support for deleting a PDF page definition
o better browser support
* cookie login: login error message
* new server/user management interface with sub-pages
o more intuitive interface
o support new MySQL 4 privileges
o support for user resource limits
* Export
o export to LaTeX format
o better handling of charset conversion
o better output order of inserts/creates
o 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
* (experimental) 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
debugging/profiling
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
Download links, as usual, on http://www.phpmyadmin.net
Marc Delisle, for the team.
The Internet, 2002-12-02
To: phpMyAdmin community
The development team is pleased to announce version 2.3.3 of phpMyAdmin.
Some improvements:
* upload of compressed dumps
* inform the user who does not have privileges to create a db
* warning if using PHP 4.2.3
* new internal analyzer for db, table, column and alias
* data dictionary report
* warning about blank root password in all auth modes
Some fixes:
* database search and any words
* anonymous user was created as %
* wrong back link after an error
* automatic uppercase causes trouble for some languages
* syntax error for REVOKE
* parsing and INTERVAL
* sorting on a COUNT() column
* no need to check an explicit dot in open_basedir path
* navigation controls not shown with GROUP BY queries
* numeric foreign keys used as aliases
* HTML entities in db or table names
* better dump support for older MySQL
* ignore NULL checkbox if data present
* SHOW INDEXES syntax variant
* USE in query box to change db
* Edit or Delete a row when only an alias is displayed
* Special regexp characters in table name caused bugs
* Reserved words like TABLE in table name caused bugs
* Check referential integrity and NULL foreign key, or self-linked
table
* inconsistent use of radio buttons on db search page
* export and UTF-8
* auto-increment key does not have to be the primary key
* ANSI comments
* cookie auth and PHP3
* javascript problem for row color pointer
* date column wrap in browse mode
* relations and non-primary key
* sorting a column ORDER BY SUM(var)
* cannot delete a row with a TEXT field containing newlines
* let use a blank password in cookie auth mode
* ORDERing by a function applied to a field
* syntax coloring and UPDATE...SET
* parser and multi-byte characters
* revealing of MySQL connect information if server is down
* bad link to doc of ALTER TABLE
* TEXT field containing HTML is sometimes displayed wrong
* FULLTEXT indexes were not detected correctly with MySQL >=
4.0.2-alpha
Download links, as usual, on http://www.phpmyadmin.net
Marc Delisle, for the team.