| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> true, thats true for you
<1> My not playign WoW may cause certain difficulties with that.
<0> i will find whatever game you're playing and haunt you
<0> lol
<0> sorry
<2> Therion start playing WoW so we can have a new medium to instult you
<3> Therion, tha'ts OK, you're just hearing things.
<0> that beep is so 1990s ircN ..
<0> btw, if you guys haven't used eventum lately.. you should try it.. much more maturer than oh 1 yr ago
<4> eventum was nice back in the day when I used it
<0> oh, it ****ed when i tried to use it for myself.
<4> now I'm forced to use bugzilla
<4> it's not so bad since I've patched it up with four or five greasemonkey scripts :)
<0> ahh well i thought eventum was better than bugzilla even then
<4> plus a bunch of custom reports/views
<0> i was using trac, but the ticket system is not very flexible
<5> hey, I have mysql5 installed on my server but I need to run mysql4.1 too. Is it possible to run both, one #skip-networking and the other not? or is it somehow possible to do it?
<4> yes it's possible
<5> should I install from source, ./configure /another/dir ?
<5> sorry
<5> --prefix=/another/dir
<0> or you could just use different ports
<6> !m scott33353 multiple servers
<7> scott33353: (Running Multiple MySQL Servers on the Same Machine) : http://dev.mysql.com/doc/mysql/en/Multiple_servers.html
<5> thanks!
<8> morning all
<8> am i in the right place to ask for a quick helping hand with a connection issue?
<5> would it be ok to run both mysql's (5 and 4.1) out of /var/lib/mysql, but only use 4.1 to connect to a single database that 5 doesn't - if you understand what i mean (it's late here) - is bad idea?
<5> or bad idea* told ya it's late
<6> scott33353: bad idea indeed, both should have separate data dir
<6> scott33353: and the mysql grant tables in 4.1 and 5 are different
<5> lokus, k thanks :)
<8> could anyone tell me how i get the server to spit out a list of current databases a specific user has access to?
<6> pagangeek: show grants
<8> oo.. thanks lokus.. ill go try that
<8> hmm seems my issue is host related..
<8> ah well..
<9> hello
<9> i'm trying to make mysqld listen on many interfaces, but not all
<9> is it possible?
<9> i've tried bind-address = ip1 ip2
<9> and two bind-address statements
<9> no luck
<6> anarcat: remove bind-address, default will be all interfaces
<9> lokus, i know, but i don't want all interfaces
<6> anarcat: bind-address is restricted to 1 ip
<9> i see
<9> so it's all or nothing
<9> i have two NICs on the server
<9> i'd like mysqld to listen on loopback in one of the nics
<10> huh?
<10> you mean listen on loopback AND one of the NICs?
<9> Darien, yes.
<9> i have 3 interfaces here:
<9> lo: 127.0.0.1
<9> eth0: (some public ip)
<9> eth1: 192.168.0.101
<9> i want mysql to listen on lo and eth1
<11> edit my.ini?
<12> anarcat: you'd sort that out in your firewall settings. mysql can only listen to either all or only one.
<9> the workaround i'll be going for will soon be to open a server on eth0 so that mysql can't bind to it
<9> arjenAU, right
<12> anarcat: and that workaround would be silly and not work.
<9> arjenAU, why wouldn't it work?
<9> well, sure i want a decent solution
<9> i'm just curious
<12> try it and see. whatever.
<9> right
<9> thanks
<13> hi everybody
<14> can triggers trigger stored preocedures?
<10> I don't think so
<10> !man triggers
<7> (Triggers) : http://dev.mysql.com/doc/mysql/en/Triggers.html
<10> try it, I guess
<14> hmm k
<14> what time is it over at yours?
<10> 23h15
<14> 4:15am here; can't sleep; so reading up on triggers :)
<14> much saner time for you to be in here
<15> hello
<16> hilo
<15> hey, I have this problem...
<15> I have a .sql file which is in latin1
<15> but mysql was confgured to use utf8
<15> so the mysql command line is also receiving utf8
<15> anyway, when I try to import the file... it has errors ('cause they're different charsets)
<15> how can I tell mysql the file I'm using is in latin1
<15> ?
<16> you have to change it
<15> O_O
<15> my file?
<15> how do I tell mysql the file is in latin1?
<16> what does this show you
<15> ERROR 1406 (22001) at line 1592: Data too long for column 'name' at row 1
<6> Kronuz: set names
<16> you have to alter table mytable convert to character set latin`
<16> err
<16> you have to alter table mytable convert to character set latin1
<16> !man character set
<7> (Character String Literal Character Set and Collation) : http://dev.mysql.com/doc/mysql/en/Charset-literal.html
<15> that's not working
<15> I already have the table and the database in latin1
<15> but mysql thinks the file is in utf8
<16> SHOW CREATE TABLE yourtable;
<16> what does it show
<6> what file? sql or csv ?
<15> sql
<6> insert statements ?
<15> yep
<6> add a "set names latin1" at the start of the sql file
<15> _m00: ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin
<15> oh
<15> let me try lokus :)
<15> lokus: it seems it's working :)
<15> lokus: gosh the other day I had the same problem and I couldn't figure out how to make it work... I just changed my file to utf8
<15> but this time my file is 600 MB I didn't want to change it to utf.. it would have taken hours :P
<15> ... still waiting :P
<15> don't know how long it'll take to insert all that :P
<17> Narada: Not sure about MySQL, but normally, stored procedures are accessible from triggers.
<14> hmm i see
<18> I just set up a trigger to call a procedure. Has to be the same database, and I think there's other restrictions as well, like it can't return a resultset. Most likely can't reopen the trigger's tabe either.
<17> I suspect some of those restrictions will eventually be removed.
<14> tabe?
<18> table
<14> ah
<17> Seems a little odd to limit the trigger to a database.
<18> I mean the trigger can'
<18> I mean the trigger can't call a procedure in a different database
<18> I think that's a bug
<6> can you qualified the stored procedure wiht a db name?
<18> because it said table x.y not found when I said call x.y()
<18> apparently not
<18> adding the db qualifier confuses it
<15> lokus: I think I didn't thank you... really, thanks for the help :)
<17> Sounds like a minor oversight.
<19> guys in running gentoo and trying to run php5 and mysql5, but you don't know what php module to install to get them working together
<20> in mysql; can I force all doubles to be printed with a decial point?
<20> (even in exp notation)
<18> richiefrich, http://www.php.net/manual/en/ref.mysql.php
<18> !m wimp string functions
<7> wimp: (String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
<18> see format() function
<20> bobfield, thanks
<18> np
<21> welcome
<19> bobfield, must i change a mysql setting?
<18> shouldn't have to, what problem are you encountering?
Return to
#mysql
or
Go to some related
logs:
casiopiea wifi
#fedora
libcssdvd rpm
#ai
#lisp
#asm
udev eth0 disapears
#math
bernulli's principle wikipedia
ubuntu x336 dapper
|
|