replication help

hello, i had a master-master replication now one of the masters seems to be about two days ahead of the slave how do i make the first server in sync with the second and force any data added to the second master to be pushed back into the first server. thanks -- ˙uʍop ǝpısdn p,uɹnʇ pןɹoʍ ǝɥʇ

Re: BLOB data gets encoded as utf8! (Anyone?)

I think that probably the mistake is in the way you are inserting the blob. If i understand right, you are inserting the blob with a traditional insert statement ??, in my experience i always use prepared statements to insert blobs, in that way the text goes exactly as the source without any

permissions in information_schema

Can somebody tell me why the last command bellow doesn't works? mysql GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'senha' WITH GRANT OPTION; Query OK, 0 rows affected (0.02 sec) mysql FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) mysql GRANT SUPER,REPLICATION CLIENT,SELECT

RE: replication help

Force all traffic to Node A Break/Stop replication backup Node using mysqldump Restore backup file on Node B Resume replication Install Maatkit Should do the trick... From: ext Norman Khine [nor...@khine.net] Sent: 30 August 2010 15:50 To:

RE: permissions in information_schema

Information_schema is a read-only memory database. When you create'MySqlMonitor'@'localhost', you will still see the information_schema. However, the information_schema will only contain table info 'MySqlMonitor'@'localhost' can access. Information_schema behaves more like a restricted view

how to run dbt 1/3/4/5 with mysql?

Hello all, I have run dbt2 with mysql. Can I also run dbt1/3/4/5 with mysql? thanks! -neutron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: permissions in information_schema

Thanks Rolando for your help. But there is one thing that is very stranger When I use Mysql Administrator to configure the permissions that I want for the user MySqlMonitor , everything works fine, as you can see in the image bellow:

Re: Sequence of Execution in Non-Transactional Script

On Aug 30, 2010, at 12:09 PM, real...@areality.co.uk wrote: Hello, I'm working on a very simple stock tracking system on unix with MySQL 5 and PHP. Working under the assumption that all my updates would be executed sequentially in the order they appear in the PHP script I perform

Nested join query?

Hello everyone. I'm trying to perform a query that acts on 3 tables at once. I'm thinking I need to produce a set of joins between all three tables to get the results that I want, but am not sure how to go about it with nesting or maybe there's even a better way. I need to check TableC for

RE: Nested join query?

I think you could do away with your right outer join of table B (which will include all rows from B whether or not they match to C), since you are explicitly filtering for C.State like 'Yes'. The intermediate result doesn't necessarily need to be stored in a temporary table. You can include

Re: Nested join query?

Travis, Thanks a lot! That seems to work perfectly and also cleans up the syntax a bit so I think it's more understandable. Michael On Aug 30, 2010, at 7:21 PM, Travis Ard wrote: I think you could do away with your right outer join of table B (which will include all rows from B whether or

Fast Index Creation and fill factor

I've been going through the 5.1 manual and exploring the new features. To add a secondary index to an existing table, InnoDB scans the table, and sorts the rows using memory buffers and temporary files in order by the value(s) of the secondary index key column(s). The B-tree is then built in