|thecoolone19||strike: 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 ?
|strike||at 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^way||hey, can anyone give me a rows what i should use for my counter|
|thecoolone19||i have already done a mysqldump on C|
so both are syncronized for the moment
|aa^way||counter for counting how much there has been people on my site|
i thought: "IP,DATE,incrementing ID", is there a more proffesional way =P?
|thecoolone19||my doubt is about the binlog that was used with A and B setup|
can i just ignore them ?
|[Puer]Damien||I still got some problem, is there a way to check what password you use?|
|juxtap||is grasping normalization supposed to make you feel stupid? :/|
|strike||so you have to clear all logs on B and start afresh|
thecoolone19: so you have to clear all logs on B and start afresh
|thecoolone19||how to do that ?|
i mean do i delete all logs in /var/log/mysql ?
|[Puer]Damien||When 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
|Leithal||wrong password I would guess|
|[Puer]Damien||is there a way to check my password?|
|praseodym||how can I execute an INSERT while ignoring any errors about duplicate keys (if a duplicate exists, just ignore the INSERT)?|
call me dumb :) but still, thanks snoyes
|[Puer]Damien||i will be back in a better time :D|
|strike||thecoolone19: there was command like flush slave or some such.. I don't remember exactly|
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. firstname.lastname@example.org, email@example.com gives '2', etc
|snoyes||use SUBSTRING_INDEX to find everything after the @|
|bradmw||why might changing the innodb log's buffer and file sizes cause mysql queries to fail in php?|
|zimnyx||What is defautl value for open-files-limit ?|
|snoyes||Depends on the OS, I think.|
|zimnyx||I'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
|Mrdini||hmmm, having a bit of a trouble using the GROUP BY for substring_index - any thoughts, folks? http://pastebin.ca/492842|