| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> depending on the collation
<0> and, *sigh*, why can you only notice these things by seeing your data get screwed?
<0> I guess that one's rhetorical:)
<0> computers, and all:)
<0> it seems to have the same 22000 limit when complaining 'The maximum row size for the used table type, not counting BLOBs, is 65535.'
<0> color me confused
<0> VARCHARS are byte based, right? The docuented memory use certainly seems to suggest so.
<1> Is there a builtin way to convert "2006-05-26 18:38:50" to something like "May. 26th, 2006"?
<1> Or am I going to have to write a custom PHP function?
<1> that date is pulled directly from the database
<2> Hi :)
<2> Is there any performance hit with joining two tables from different databases?
<3> sages: you mean other than date_format ?
<3> Sembiance: as compared to what ?
<1> No, if that does what I need it should work, is that mysql or php?
<1> ah
<1> got it
<1> thanks
<2> andrewbryson: as compared to joining two tables from the same database
<3> well this being #mysql it is probably mysql :P
<3> Sembiance: are the two databases on the same server ?
<1> ah... it's all so clear now :P
<1> thanks
<2> andrewbryson: yup
<3> well in that case i would expect the performance hit to be negligible
<2> andrewbryson: cool, thanks :)
<1> hmm when I use the date_format modifier the query returns nothing for the date, but gives me valid stuff for the rest of the results
<1> so just that column is failing
<1> any ideas?
<4> hi dudes...
<4> how do I give a certain user, access to connect from other machines?
<5> !m cusco grant
<6> cusco: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<7> hey all, i can control mysql using my current user and here's what i could do..
<7> mysqladmin --user=user --p***word=p*** processlist
<7> as an example.... the question is? could i control a certain mysql table through the command in one line?
<5> mysql -e "whatever query you want to run" -uuser -pp*** db
<7> oh yeah :)
<7> will try now
<7> thanks gleam_ ;)
<4> sorry but.. I used the grant as described on the website
<4> but I can't telnet to the server host on port 3306
<4> connection refused
<4> is tehere a possible reason why it isn't listening on other than localhost?
<7> gleam_ : i think it's not workin
<7> mysql -e update table set row=value where row=value -u USER -pP*** database
<7> gleam_: am i missing something?
<3> you mean apart from the quotes ?
<7> ok i added the quotes and replaced -e with --execute=
<8> m0dY: do you get an error?
<7> no, just an output starting with.. mysql Ver 14.7 Distrib 4.1.18, for unknown-linux-gnu (x86_64) using readline 4.3
<7> Copyright (C) 2002 MySQL AB
<7> may be i'm writing something wrong, i'm not so good in mysql queries :/
<8> that would imply that your params are invalid
<7> mysql --execute="update ibf_members set mgroup='20' where name='name'" -uUSER -pP*** --database=DB
<9> guys i have a problem with mysql and my rhel 3
<7> zircu, think so!
<4> can I set in /etc/mysql/my.cnf 3 diferent IP's in the bind-address
<9> few minutes ago i can execute mysql_install_db
<4> option?
<9> but now i cant
<10> cusco, No.
<9> cusco?
<9> de donde eres cusco ?
<4> io no hablo espaol. perdona me
<7> zircu, ?
<10> Kalavera, Why do you want to run it more than once?
<11> hey guys...
<11> having an issue with a wildcard host on a GRANT command
<9> mmmmmm because i have an auth problem
<11> it seemed to take my GRANT command, but the user can not connect
<9> these script have a limit for execution ?
<4> and if I comment the bind-address line.. will it listen on all teh IP's??
<10> Kalavera, No but it shouldn't be ran more than once.
<11> GRANT ALL ON userdb.* TO 'user'@'%' IDENTIFIED BY 'p***word';
<10> Kalavera, What is the problem.
<10> x86, And the problem?
<11> what did I do wrong?
<9> i try to authenticate and i cant
<10> GUYS
<9> i set a p***word for the root and i cant to loged in
<11> will: <11> it seemed to take my GRANT command, but the user can not connect
<10> No more "I CANT DO THIS". SAY WHY YOU CAN'T
<10> Do you get an error?
<9> i remove mysql directory and run the script for create a clean database
<12> Question for you all concerning SELECT... can I select on all but one column w/o writing all the columns out?
<11> will: access denied for user 'user'@'localhost' (using p***word: YES)
<10> x86, You have an anonymous user. Delete it.
<10> !m x86 secure installation
<6> x86: Nothing found
<10> !m x86 secure
<6> x86: (Using Secure Connections) : http://dev.mysql.com/doc/mysql/en/Secure_connections.html
<11> will: which user is anonymous?>
<13> x86: the '%' also does not match localhost, FYI.
<9> x86, you was upgrade your mysql version =
<11> infi: thanks ;)
<13> aye. give me free voip accounts now ;)
<11> infi: all i needed to know :P
<9> x86, try with 127.0.0.1
<11> infi: haha
<7> zircu!
<13> x86: you have to add an explicit entry for localhost
<7> what am i doing wrong here !
<7> mysql --execute="update ibf_members set mgroup='20' where name='name'" -uUSER -pP*** --database=DB
<11> infi: yep... that fixed it :)
<3> yeah that again chap is good at giving out coherent answers
<3> well... when he is not drunk anyways
<12> Question for you all concerning SELECT... can I select on all but one column w/o writing all the columns out?
<3> certainly
<12> In one SELECT statement, w/o resorting to temp tables?
<3> now you're just being picky
<12> Nah, being cheap. :)
<3> :P
<12> No way of doing it?
<3> oh i am sure there is
<3> could take a little while to figure out though
<3> but i expect that if you join to whatever table contains the column definitions you could construct something
<12> Eh. Though someone knew. I'd probably have to do it the hard way, m***aging the dump with Perl.
<8> m0dY: the command works ok for me
<8> m0dY: what version of mysql?
<7> mysql Ver 14.7 Distrib 4.1.18
<7> zircu
<9> any form to run another time the mysql_inbstall_db script?
<9> i have problems
<3> perhaps if you described the nature of your problems someone might be able to help...
<8> m0dY: the command you use works just fine minus the host, db, host, user and p*** values
<5> m0dy are you getting an error or is it not behaving as you expect?
<7> gleam_: not behaving as expected.. not updating anything
<7> :/
<9> somebody can helpme?
<3> before you state your problem you mean ?
<5> are you sure ther eisn't a problem with your query, m0dy?
<9> i explain my problem
<5> try: mysql -e "select 1" --user= etc etc
<9> but i execute mysql_install_db script a lot of time
<9> and now my bd is ****ed
<7> gleam_: okay
<7> nothing changed
<7> the same output
<5> what output?
<7> here's the piped output http://www.snaketop.net/skin_cache/cacheid_9/sql.txt
<3> lol
<3> what was the exact query that you typed ?
<9> how the script create the initial tables an dbs?
<5> heh
<5> yeah waht did you run exactly?
<7> mysql -e "select 1"
<9> not query only i remove my mysql directory a lot of time and recretae it
<8> m0dY: the problem is i can't even supply invalid arguments to mysql to come up with that, it complains when i do mysql -k
<3> Kalavera: how did you recreate the mysql directory ?
Return to
#mysql
or
Go to some related
logs:
a copy of glibc was found
tg3 FC5 modprobe
Fedora gwav
#php
#perl
#python
AttributeError: 'SessionBus' object has no attribute 'get_service
geniack
#mysql
+php +nusoap +input +dump
|
|