Hello,
Sorry sorry, I know we're supposed to be in "code freeze"
period, but I really needed this feature :) And it can't break
anything anyway, because it's a new script, hacked in a few
minutes tonight. (not sure if the html output is 100% correct:
not checked yet)
Link ("Databases Statistics") is displayed on main.php3 only
if the user may also access mysql.user (root). I hope you will
also find it useful!
Greetings,
Olivier
--
_________________________________________________________________
Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland
qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch
I have a problem when editing the result of a select query, when you post
the edit the db gets updated but phpmyadmin then comes back with an sql
error trying to redisplay the results - every time ...
Thought I'd post it here as I know you are close to release ...
Also a suggestion - in the right hand frame when you click on the db in
the lh frame, could not the table properties be collapsed under a link
that said 'properties' so you can expand it if you want, but all the other
options would be visible on the screen. There are a lot more options in
the new version ....
Also - any chance of the 'drop database' option being configurable to not
be available ... we run an isp and offer phpmyadmin - its a real pain when
users drop their databases without going through our interface ...
Regards
Lance
At the bottom of the database frame shouldnt it say :-
'Drop table xxxx' rather than just 'Drop xxxx' which may be confusing if
you have both a database and a table of the same name ??
Lance
Done in the CVS: MYSQL_MAJOR_VERSION and MYSQL_MINOR_VERSION constants have
been replaced
by MYSQL_INT_VERSION.
Jocelyn, please test it.
Loïc
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif
Other small thing:
there is an user 'om', with rights on db 'omtest' :
if I log in as 'om' with adv auth, I see only the db "omtest"
in left.php3.
but if I log in with std auth (om/passwd set in config.php),
the whole db list is still displayed.
Shouldn't it look the same ? (only my own db)
Olivier
--
_________________________________________________________________
Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland
qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch
Olivier wrote:
>still seems ok over here... (just tested with a few pma-generated
>dumps).
Indeed, whith a pma generated dump (beginning with comments)
containing more than one query (eg create a table then inserts data)
not using the remove_remark function make phpMyAdmin fails.
Loïc
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif
Hi again!
Well, it seems that importing sql dump files with table creation + data
no long works. Can someone confirm this ?
Loïc
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif
Jocelyn Fournier wrote:
>Could it be possible to enable Space Used, stastics, optimise table,
>etc for MySQL-4.0 (as it works same as MySQL-3.23.xx) ?
Yep. The problem in the code is that we test
MYSQL_MAJOR_VERSION >= 3.23
&&
MYSQL_MINOR_VERSION >= nn
Why don't we use a constant just like PHP_INT_VERSION?
Loïc
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif
Hi,
Could it be possible to enable Space Used, stastics, optimise table, etc for MySQL-4.0 (as it works same as MySQL-3.23.xx) ?
I think it shouldn't be hard to modify the code to do this ? :)
Thank you,
Jocelyn Fournier
Presence-PC
Hi Olivier & all!
>It works if it's empty or contains "/var/lib/mysql/mysql.sock" (socket
>on my server). But just tried a little stupid thing: replaced the
>path by something not existing, and it still works, so I don't know... :)
Amazing !
>Will have a better look on it later if you want
It would be nice :)
BTW the db_stats.php3 script is a good idea.
Have a good night,
Loïc
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif