| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Comments:
<0> then the inner becomes a cartesian product
<1> Both do.
<2> I mentally included where conditions that joined all the tables yet excluded ones where sent_match didnt' work for teachers
<3> yo firewire, question. if you replicate, do you have to have same table structure exactly? If I want one server to contain certain info, and another to hide it, aka a string, can I make the hidden server field a tinyint(1) so it will simply not contain a string? or will the binary log not like that
<2> replication replicates acutal queries, not data
<3> great, so that trick should work
<2> if you want those queries to succeed on the slave like they did on the master then you should have the same tables :)
<1> INSERT INTO table VALUES ( 'haha', 'this', 'wont', 'work' )
<3> another point of this is to not have sensitive data exist on a public server
<2> values ('haha'), ('this'), ('wont') , ('work') will work
<3> so if I make sensitive strings like CC numbers on the slave tinyint(1), it should in effect not store it
<4> will: hmmm.... but in mysql documentation write:
<4> will: The [client] option group is read by all client programs (but not by mysqld).
<1> muhlik, Try it then.
<0> mysqld is server
<1> lokus, He's wondering if PHP will read my.cnf
<2> muhlik: it's read by all client _programs_ not by all client _libraries_ which php uses
<0> php could be a client too :)
<4> will: but php dont read this section.... and perl script too :_(
<2> client programs includes programs distributed by mysql ab like mysql mysqldump mysqlhotcopy ect
<1> I ***umed that "client programs" was referring to mysql, mysqldump, mysqlimport, etc.
<2> php won't even read my.cnf
<4> OK
<1> muhlik, So I'm right?
<2> will: you're slow!
<1> firewire, I'm doing other things (involving that privmsg...)
<2> die
<5> can any one tell me how to add a user to mysql??
<1> What's up with the bot anyways? I should call Therion
<2> grant.
<1> sizaint, http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
<1> !die
<5> thanks
<1> !quit
<1> !we hate you
<5> g thanks
<1> Not talking to you.
<5> love you too
<5> oh..
<5> ok
<1> SQL, PING
<4> anybody know russian mysql channel ;-)
<1> You don't like us?
<2> not you
<5> dose phpmyadmin have a way to add users? the grant thing is way over my head :S
<2> will: are you going to the UC?
<1> No
<2> why not?
<1> sizaint, Yes
<1> firewire, Because I'm lame. And the fact that the other manager is going to TX for another conference.
<6> firewire: I'm back to where I was this morning again .... the query works, but if I add a teacher_id to sent_match. The query will then ignore all matches for that teacher_id. And if I put in an add-on stating that it should match NULL or recruiter_jobs_id ... it starts matching multiple copies of the same job ... :-(
<5> will, where? ah the privledges tab?
<2> IS NULL
<4> will: my poor English is a big wall for meeting :-((((
<6> firewire: can I show you the query ?
<2> babo: will can help you. I need to sleep
<2> I have to work in 7 hours
<7> firewire, *gasps* better get to bed :)
<2> hah
<6> firewire: ok cool thanks
<2> meetings, conferences and whatnot
<8> firewire, thanks for reminding me
<8> it must be like 5am here
<1> firewire, And I don't?
<2> will: no, you dn't
<1> Oh
<7> lol
<1> I have to work now.
<8> lol
<1> muhlik, You're English is fine.
<4> :-D
<1> sizaint, Click it?
<1> muhlik, What is ":-D" in English?
<4> will: it's "burst of laughter"
<4> will: or "roar"...
<6> Can someone (will ... ? ) have a look at this here pls ? ... thanks
<1> Wow, you're a lion.
<1> Why me?
<1> Dude, like I started using MySQL two days ago...
<6> firewire volunteered you ...
<9> hi, is it possible to use something like select * from xxx where my_id IN <list of values>;?
<10> having an odd update issue, i'm trying to update a PK field and it says that there is a duplicate entry, however a select * from table_name; doesn't return a duplicate http://pastebin.com/645672
<1> mr_claus_, Yes.
<6> will ... oh ... ok then ...
<6> :-)
<1> IN ( 1,2,3,4)
<9> will: whats the syntax?
<9> will: ty
<0> StarScream: try to check the table
<10> lokus: check the table ?
<0> check table users_site_structure;
<10> | OnlineBizBuilder.users_site_structure | check | status | OK
<11> hi
<0> StarScream: then no index corruption
<0> StarScream: is it that someone made an insert before your update?
<11> i'm running a mysql 5.0.19 cluster, which works... except the sql node, which fails with error 2350...
<11> the distribution is debian sarge with mysql installed from sid
<10> lokus: only me on the server at the moment, and that select was taken after the insert
<10> lokus: and i'm locking the table before i do the update
<11> architecture is amd64 on all systems
<1> brb
<0> StarScream: no idea whats wrong
<10> lokus: its a PK field with auto_increment on it...does that make a difference ?
<0> StarScream: do another select after the failed update
<0> StarScream: auto_inc should not have any effect here
<10> select max(menu_id) from users_site_structure; returns 340
<11> any idea, or do you need any additional information?
<0> StarScream: report a bug then
<0> aszlig: full error message, don't know what does the numbermeans
<10> lokus: k, thanks
<11> NDB error code 2350: Invalid configuration received from Management Server: Permanent error, external action needed: Configuration error
<12> hi everyone
<1> hi one
<12> -:)
<0> aszlig: possible configuration file error
<1> That can't be!
<0> aszlig: check the config file in the managemenr node
<11> yeah, but i've checked the config and searched the web, but the config seems okay...
<12> i`m on slackware, as i start mysqld_safe the output is:
<12> Starting mysqld daemon with databases from /var/lib/mysql
<12> STOPPING server from pid file /var/lib/mysql/djudjanka.pid
<12> 060407 11:50:40 mysqld ended
<1> Punko, Check /var/lib/mysql for a .err file
<1> !tell us about slackware
<12> thats from the *.err log : 060407 11:50:40 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
<11> and the management server doesn't seem to be very verbose about this ;-)
<1> Punko, You need to run mysql_install_db
<12> :))
<1> And then make sure mysql owns /var/lib/mysql
<12> ahm. ill do that. -:)
<1> Oh I bet you will
<12> everything runs. thanks will -:)
<1> np
<6> So if I do a TABLE1 LEFT JOIN TABLE2 ... I still refer to the field of TABLE2 , as TABLE2.field , not TABLE1.field ... yes
<1> huh?
<1> "of course"?
<11> [mysqld(API)] 1 node(s)
<11> id=4 (not connected, accepting connect from enospc)
<6> will: I guess, I think it'd more logical to refer to it the other way, because TABLE2 is now a part of TABLE1 right ? ... but anyway ...
<1> No
<11> the only thing that i'm unsure - should it be SQL instead of API?
<0> aszlig: could it be the hostname resolution
<1> It's not a "part" of it. Just references it.
<11> Note: If you are using an older version of MySQL, you may see the SQL node referenced as [mysqld(API)]. This reflects an older usage that is now deprecated. <-
<11> hrm, the hostname res works, already checked it...
<11> the other nodes work well, but not the sql nodes...
<11> and the documentation is for 5.0.19 - i'am using 5.0.19 O_o
<0> older version? when you are using the latest already
<11> yeah, that's what the docs say
<11> (the note from above is from the docs, btw ;-)
<11> that's what i found, which could possibly be the cause...
Return to
#mysql
or
Go to some related
logs:
newaliases: fatal: alias initialization mode requires no recipient
bash trim
#qemu
#math
#perl
#centos
turkenator
namp for ubuntu
#css
x11-drm 9700
|
|