#mysql - Thu 17 May 2007 between 11:10 and 11:48

NY Lost Funds



thecoolone19strike: the problem is that we had a master slave between A and B with A as master. Now we have removed A and want to have master slave setup between B and C with B as the master.
so do i have to delte the old bin file or any other files ??
or do i just have to add master-host in the C system's /etc/my.cnf file ?
strikeat some point you have to sync both DBs and from that point master should start logging, which then log all changes from that point
aa^wayhey, can anyone give me a rows what i should use for my counter
thecoolone19i have already done a mysqldump on C
so both are syncronized for the moment
aa^waycounter for counting how much there has been people on my site
i thought: "IP,DATE,incrementing ID", is there a more proffesional way =P?
thecoolone19my doubt is about the binlog that was used with A and B setup
can i just ignore them ?
[Puer]DamienI still got some problem, is there a way to check what password you use?
juxtapis grasping normalization supposed to make you feel stupid? :/
strikeso you have to clear all logs on B and start afresh
thecoolone19: so you have to clear all logs on B and start afresh
thecoolone19how to do that ?
i mean do i delete all logs in /var/log/mysql ?
[Puer]DamienWhen i try install my MYSQL it gets stuck on "Apply security settings." with the error:The security settings could not be applied. Error Number 1045. Access denied for user 'root'@'localhost'(using password: YES)
my port is opened
Leithalwrong password I would guess
[Puer]Damienis there a way to check my password?
praseodymhow can I execute an INSERT while ignoring any errors about duplicate keys (if a duplicate exists, just ignore the INSERT)?
snoyesINSERT IGNORE...
praseodymheh.
call me dumb :) but still, thanks snoyes
[Puer]Damieni will be back in a better time :D
strikethecoolone19: there was command like flush slave or some such.. I don't remember exactly
thecoolone19: http://dev.mysql.com/doc/refman/5.0/en/reset.html
Mrdinifrom earlier.....
hmmm, trying to investigate a issue (with user registration) & wondering - is there a 'easy' way to do a COUNT() based on email domains in a CHAR field i.e. blah@yahoo.com, blahblah@yahoo.com gives '2', etc
snoyesuse SUBSTRING_INDEX to find everything after the @
Mrdininiiice
thanks!
bradmwwhy might changing the innodb log's buffer and file sizes cause mysql queries to fail in php?
zimnyxWhat is defautl value for open-files-limit ?
snoyesDepends on the OS, I think.
zimnyxI've made table_cache a bit larger, and wonder whether should set open-files-limit to some value.
Can it overwrite OS defaults?
I wonder what is the point of setting it in my.cnf
Mrdinihmmm, having a bit of a trouble using the GROUP BY for substring_index - any thoughts, folks? http://pastebin.ca/492842

Page: 1 8 15 22 29 36 43 50 57 

IrcArchive

NY Lost Funds