Hi,
we intentionally display Language in all cases with the goal of helping
anyone seeing the interface in a foreign language to be able to find
where is the language chooser.
I suggest to replace
Language
by
"Language"
to better indicate that this is a foreign word on the interface. That
is, unless the current language is English.
Marc
Hi,
I sent the list of changes to the translators list. I suggest to release
2.9.0-beta1 in one or two weeks.
I plan to open QA_2_9 but I would prefer if we first reach a decision about:
- auto-numbering in Documentation.html
Marc
from the code and the documentation i collected this information about
how and what phpMyAdmin tries to get the db list:
- first it tries SHOW DATABASE for the current user
- if this fails it tries it with controluser and checks against
privilege tables
but the documentation says only that the controlusers requires access to
various `mysql`-tables - not that he also requires SHOW DATABASES
privileges - without this a user with global select privileges will not
see any database - or wildcards cannot expanded to real db names
- if this both fails the dblist stays empty
- phpMyAdmin drops all db's not in cfg[only_db]
- phpMyAdmin drops db's in cfg[hide_db]
- phpMyAdmin tries every db with USE DATABASE (for specific MySQL version)
Questions:
"Note: starting with phpMyAdmin 2.6.1, this section is only applicable
if your MySQL server is older than 4.1.2, or is running with
--skip-show-database."
Why "is older than 4.1.2"?
thinks i want to change:
- if SHOW DATABASE fails try INFORMATION_SCHEMA
- merge PMA_safe_db_list(), PMA_availableDatabases(),
PMA_DBI_get_dblist() into a single function
- if the dblist is still empty check `mysql` and `INFORMATION_SCHEMA`
with USE DATABASE and add them to the list
please correct me if i missed something and feel free to comment
--
Sebastian Mendel
www.sebastianmendel.de
Hi everybody,
So a reportback on OSCON 2006. This is the publicly consumable part, as
with my MySQL UC report.
The trip down was a pain - this is worthy of mention because none of us
are American. The US INS (immigration/customs) guy that I had to speak
to had absolutely no understand of open source software, or that we
could give something away. He asked if I had some proof that I was
associated with phpMyAdmin as a business (he kept referring to it as
such, no matter how many times I pointed out we were closest to a
community organization) - so I showed him one of my phpMyAdmin business
cards, and the 11x17 posters I had
Do not be tempted to lie to these guys, they use infra-red cameras
trained on faces to try and detect it.
This still did not help his understanding of phpMyAdmin and open source,
and he opened his drawer and got out his dreaded orange rejection pad
(by which they deny you entry into the USA) - I had to rack my brains
and make very fast analogies at this point - and eventually I succeeded,
but it is NOT an experience I would like to repeat again.
A number of the other folk at the conference admitted to having similar
troubles while crossing various borders.
The rest of the journey down to Portland was uneventful - I had time for
a brief bite of lunch in Seattle once the bus stopped, and before the
Amtrak train left (I'll take the European rail system, even that of
Italy over Amtrak anyday however).
On reaching Portland, I was grabbing a cab to where I was staying, which
turned out to be interesting in itself - the cab driver was Eritrean,
and could not understand my South African accent whatsoever, to the
point where I had to write down the address.
Originally, I was going to be staying with a fellow Gentoo developer,
but about a week ahead of time, he had roommate issues, and wasn't able
to offer me a place. A few other Open Source leads didn't help either.
So, in the same vein as MySQL UC 2006, I used CouchSurfing.com, and
ended up on a fold-out futon bed, 1.5 miles from the convention centre.
My host said she could loan me a spare bicycle, so I brought my helmet
and other gear down. She asked that I keep her identity to myself, for
various reasons.
CouchSurfing as a concept works out reasonably well. You get a couch or
better to stay on, and generally just try to lend a helping hand while
you are there (I helped in the kitchen, read a bedtime story to my
host's daughter and her friend, tuned up the bicycles, and a few more
things).
The Wednesday morning cycle to the convention centre was ok - I had
previously made a brief study of Google Maps, and was told by my host
that the convention centre had two very large spires that were good
landmarks to orient by within the NE district of Portland. The ride was
a bit interesting, the route I picked based on Google Maps turned out to
go via some of the slummiest parts of town, which felt marginally unsafe
at 8.15am.
Got to the convention centre, signed in, rigged up the 11x17 posters in
the booth (as visible in the photo that Marc linked to, which was taken
by the ZDNet photographer, early on Thursday morning, right after the
doors opened for non-exhibitors), and said Hi to the other dot-org
booths around my area - a bunch of the same people that were at MySQL UC
- Apache, WITI, FSF. Fired up the CVS HEAD demo on my fiance's laptop,
and waited for the first crowd to come in.
As a general summary, while exhibit hall passes were free for OSCON - it
was much subjectively quieter than MySQL UC - most of those that did
come in exhibit hall passes were just there to scoop freebies - and did
not interact with any booth without freebies. At the breaks between
sessions, there was a good deal more activity in the exhibit hall - due
to the refreshments and snacks. For folks approaching the phpMyAdmin
booth I had a number of folk complaining of not getting it working, but
after some targeted debugging questions, the source of their troubles
were Apache/PHP, not phpMyAdmin in any form.
I had a number of UI designers make interesting comments about the PMA
design - such as the cookie login message (from a Databases professor at
Stanford) that I brought up for Marc's message freeze request. Some of
these I see we are already working on (like the present thread for
tracking server/database etc in a cookie). Some more of them I intend to
dig out my UI design textbooks and examine more closely to see if there
are logical ways that we can improve them.
There were no comments about the lack of bleeding edge functionality -
even those that I specifically asked about a stored procedure editor
admitted they did not have a need for one.
There was one notable functionality request, and it's got some
low-hanging fruit we can consider - an explicit tab-separated value
(TSV) export format - in the same vein as our CSV export.
The second part of the request was considerably more complication - and
that was IMPORT functionality for CSV/CSV-Excel/TSV/XML data.
I went for lunch Wednesday with teh Gentoo developers, courtesy of
E-Trade - who are apparently very large Gentoo users - discussions had
about application packaging were very in-depth.
The afternoon was similar to the morning, just hanging in the booth, and
speaking to interested conference attendees.
There were a lot of full conference attendees that just breezed by the
booth shouting out things like 'Great software!', 'We use it everyday!',
and similar slogans of support.
Starting at 15h30, the free beer came out. Nothing as elaborate as the
party at LinuxTag last year, but still very good quality micro-brewery
german-style beers (which Portland is famous for), incl. a nice triple
Bock, and an Altbier similar to that which Alexander had going last year
at LinuxTag for us.
The exhibit hall for Wednesday wrapped up at 5pm, and everybody (incl.
exhibitors) was kicked out so the caterers could set up the
IBM-sponsored reception. The 6pm reception was reasonble - good
appetizers, and a lot more beer and wine.
From there, some of the Gentoo developers and myself went to two of the
open-bar parties that were taking place in nearby hotels - the first was
slow, and badly attended, with a Jewish kleizmer (sp?) [with a story
attached linked to Metallica], and more beer, but no food.
The second party was a lot more active, held by O'Reilly - their hotel
suite was shoulder-to-shoulder people. I engaged in some interesting
conversations with Google employees, before calling it a night around
11pm, so I could cycle back while still marginally sober (and able to
stay upright on the bicycle).
Thursday morning saw me figure out a different cycleroute to the
convention centre - one that turned out to be safer from people and
traffic (there are cycling lanes painted on the road, but DON'T cycle in
them with the traffic unless you have a deathwish, they do NOT like
cyclists). Rigged up the laptop demo again, the ZDNet guy came by and
grabbed the photo of the booth with me busy setting up the laptop demo.
Thursday seemed much quieter. I had an interesting discussion with a
group of high-school youth that were developing a MySQL-based library
book tracking system for their school, and helped out with their
database design. I arranged for 50 blank CACert CAP forms and also did
CACert assurances at the booth during Thursday, as I found that I was
not going to be able to attend the keysigning event Thursday night.
Ate the conference boxed lunch at lunchtime, it wasn't noteworthy in any
way. Come the 5pm teardown time, I grabbed my stuff, and departed. I was
informed of a few more parties, but I turned them down due to my pending
early departure on Friday morning. Stopped at a bookstore on the way
back.
I had a light dinner out with my host, cooked up my famed
near-diabetic-inducing chocolate sauce which was then served over ice
cream and strawberries. Grabbed some sleep before the morning and
leaving to catch the public bus to the train station at 7am. The return
journey was much better, baring the initial 1 hour delay due to a train
derailment south of Portland.
The private report portion will be a followup email to the usual
location.
--
Robin Hugh Johnson
E-Mail : robbat2(a)users.sourceforge.net
GnuPG FP : 11AC BA4F 4778 E3F6 E4ED F38E B27B 944E 3488 4E85
Hi,
starting with MySQL 5.0.23, SHOW CREATE TABLE includes the
AUTO_INCREMENT next value, just after the ENGINE clause.
We had a "Add AUTO_INCREMENT value" option in table operations and db
operations.
So I suggest:
- for 5.0.23+, the "Add AUTO_INCREMENT value" checkbox be removed from
table operations and db operations dialogs. The same functionality is
now being provided automatically in the CREATE TABLE statement
- for 5.0.22-, I would also prefer to remove these checkboxes
For all MySQL versions, I guess that during a copy, the majority of
users want to copy also the AUTO_INCREMENT value. If it's not the case,
they can always go to the copied table on Operations and change the
value in "Table options".
If we still want to provide this checkbox, well for 5.0.23+ we would
have to examine the statement and remove the AUTO_INCREMENT clause.
Marc
Hi,
PMA_safe_db_list() first tries to use SHOW DATABASES if it fails it
tries mysql.db and inside this code there is a query with SHOW DATABASES
again ... why?
did i missed something there?
--
Sebastian Mendel
www.sebastianmendel.de
_ __ __ _ _ _
_ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __
| "_ \| "_ \| "_ \| |\/| | | | | / _ \ / _` | "_ ` _ \| | "_ \
| |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | |
| .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_|
|_| |_| |___/
2.8.2.1
http://www.phpmyadmin.net
phpMyAdmin 2.8.2.1 - August 2nd, 2006
=====================================
A set of PHP-scripts to administrate MySQL over the Web.
--------------------------------------------------------
Announcement
------------
The phpMyAdmin Project is proud to announce the immediate
availability
of phpMyAdmin 2.8.2.1. No new features appear in this version --
it's a bugfix only release.
Development of new features is happening in the 2.9 series.
phpMyAdmin is a web administration tool for MySQL databases,
intended to
handle a whole database server as well as a single database.
Over the years,
it has become the most popular Web GUI for MySQL and is
downloaded between 6,000
and 14,000 times a day, according to SourceForge.net.
New fixes in 2.8.2.1
--------------------
* darkblue_orange theme not readable
* setup script: protect against PHP code input from user
* blank page after Edit in IE6 via IIS
* reload default configuration if config.inc.php is removed
Detailed list of changes 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
----------
Please subscribe to the news mailing list under
http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news
or regularly check the sourceforge bugs tracker.
Donations
---------
The project accepts donations to help improve the product. There is
a "Donations" link on http://www.phpmyadmin.net.
Description
-----------
(from http://www.phpmyadmin.net/documentation)
phpMyAdmin handles the administration of MySQL over the Web. It
can manage a whole MySQL server as well as a single database.
Currently it can:
* easily browse through databases and tables
* create, copy, rename, alter and drop databases
* create, copy, rename, alter and drop tables
* do table maintenance
* add, edit and drop fields
* execute any SQL-statement, even multiple queries
* create, alter and drop indexes
* load text files into tables
* create (*) and read dumps of tables or databases
* export (*) data to SQL, CSV, XML, Word, Excel, PDF and Latex formats
* administer multiple servers
* manage MySQL users and privileges
* check server settings and runtime information with configuration
hints
* check referential integrity in MyISAM tables
* 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
* transform stored data into any format using a set of predefined
functions, like displaying BLOB-data as image or download-link
* support InnoDB tables and foreign keys (see FAQ 3.6)
* support mysqli, the improved MySQL extension (see FAQ 1.17)
* communicate in 50 different languages
(*) phpMyAdmin can compress (Zip, GZip -RFC 1952- or Bzip2
formats)
dumps and CSV exports if you use PHP4 >= 4.0.4 with Zlib
support
(--with-zlib) and/or Bzip2 support (--with-bz2).
Authors & Copyright
-------------------
Copyright (C) 1998-2000 Tobias Ratschiller
<tobias_at_ratschiller.com>
Copyright (C) 2001-2006 Marc Delisle
<Marc.Delisle_at_cegepsherbrooke.qc.ca>
Olivier Müller <om_at_omnis.ch>
Robin Johnson
<robbat2_at_users.sourceforge.net>
Alexander M. Turek <me_at_derrabus.de>
Michal Cihar <michal_at_cihar.com>
Garvin Hicking <me_at_supergarv.de>
Sebastian Mendel
<cybot_tm_at_users.sourceforge.net>
+ 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
Marc Delisle/ 2006-08-02