phpMyAdmin 2.5.0

ux komentāros iebrēca par jauno phpMyAdmin 2.5.0 versiju, kas iznāca pirms divām dienām. Domāju, ka MySQL lietotāji, it īpaši tie, kas lieto Windows bāzētos risinājumus, novērtēs jauno versiju (ar šo es domāju, ka uz Windows nav SSH caur kuru var tikt klāt pie konsoles).

Eksperimentētājiem der uzmanīties:
phpMyAdmin 2.5.0 is not ready for MySQL 4.1.

Lejupielādēt:
phpMyAdmin-2.5.0-php.tar.gz 1 472KiB
phpMyAdmin-2.5.0-php.zip 1 640KiB

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

13 thoughts on “phpMyAdmin 2.5.0

  1. Knagis

    nu ir veel viena maziitinja lietinja, ko der ieveerot, vismaz es uz taa uzraavos – phpMyAdmin 2.5.x un uz augshu prasa vismaz PHP 4.1.0.

    Atbildēt
  2. SpoX

    Man shajaa versijaa neizpildaas dazji elementaari SQL, peec tam izmeta vienu error un tagad vispaar vairs nekonekteejas pie MySQL
    Man skjiet ka shii versija paaraak aatri ieraudziija “dienas gaismu” 🙂
    phpMyAdmin-2.4.0 RULZ

    Atbildēt
  3. Delerium

    to brr: a kur tad uz windows ir SSH ? Kad novelk kādu 3rd party tooli un uzinstalē?
    Ok, es uz viena servera uzliku Cygwin ar SSH (lai būtu arī bash, nevis debīls cmd), zinu, ka ir arī citi SSH servisi, bet tie nav windows “dzimtie” …

    Atbildēt
  4. Delf

    to Dilerium – ir viens SSH daemons : FSecure SSH Server
    it ka liekas norm, bet juuzojas cmd, so secinam, ka pie mysql.exe tiekam un varam stradat un viss ruukaa.
    PS: tikai tas ssh serv ir striipains terminals, laikam tapec ka ir creckots vai trails 😐

    Atbildēt
  5. juris

    nu nezinu man shitas phpmajadmins liekas bikin pinkeriigs, pusotrs megabaits zipti skripti ;))))
    tad jau gandriiz labaak rakstiit SQL kverijus (bet taa dara tikai iistie viiri), vai arii lietot kaadu parastu MySQL klientu (MySQL Front, MySQL Control Center)
    Protams klientiem ir truukums ka tie straadaas uz citas kastes kaa DB un daljaa gadiijumu var buut bremze saliidzinot ar to pashu fiicaam paarmudriito phpMyadminu, jo tas DB konekteejas lokalhostaa
    Vispaar kaadus klientus lieto cilveeki? un cik daudzi lieto to phpmyadmin?

    Atbildēt
  6. ManInBlack

    Es palieku uzticigs mysql front.. jauks bezmaksas tuulis ar ko var normali stradat. Apmierina visas vajadzibas.. ok, no jebkuras vietas nevar pieslegties, bet es tapat esmu vienaa majaa ar serveri visu laiku..

    Atbildēt
  7. THP

    Nu nez, tas phpMyAdmin ir bik pa apjomīgu, lai gan noderīgs viennozīmīgi, ja ir nepieciešams piekļūt savai db no kādas citas vietas steidzami. Es gan to daru pats ar savu (krietni mazāku) modulīti doSQL. Ja kādam ir interese, eku papildus infa:
    http://php-dev.lv/?cat=scripts&id=13
    A no normāliem MySQL klientiem es izmantoju Mascon:
    http://www.scibit.com/Products/Software/Utils/Mascon.htm

    Atbildēt

Atbildēt uz komentāru SpoX Atcelt atbildi

Tava e-pasta adrese netiks publicēta. Obligātie lauki ir atzīmēti kā *