store transaction rollback information

I have a large series of mysql changes(inserts/deletes/updates) taking place in a transaction. After committing there may be some times where I need to roll those changes back later on. Is there an easy way of determining what was changed in a transaction in a way I can store it and rollback late

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

Thanks! On Thu, Jul 26, 2012 at 12:05 AM, wrote: > 2012/07/26 06:52 +0530, Dhaval Jaiswal > SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ',' > ENCLOSED BY '"' LINES TERMINATED BY '\n' > > as above give your join condition before INTO OUTFILE. > > Right

Re: How often the slave to pull data from master?

Hello Rick, You nearly got it all correct. On 7/26/2012 1:21 PM, Rick James wrote: My understanding is... * There is a "permanent" connection (TCP/IP socket) between the Master and each Slave. This is opened by the Slave when the slave starts (or restarts or recovers from a network glitch).

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

2012/07/26 06:52 +0530, Dhaval Jaiswal SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' as above give your join condition before INTO OUTFILE. Right: MySQL server writes into some directory where it is, not where

RE: How often the slave to pull data from master?

My understanding is... * There is a "permanent" connection (TCP/IP socket) between the Master and each Slave. This is opened by the Slave when the slave starts (or restarts or recovers from a network glitch). * Master writes to binlog _and_ to that connection whenever there is a 'write' opera

Re: How often the slave to pull data from master?

Yes, the slave pulls from the master. The slave io thread reads the information effectively as soon as it is written to the master's binary log. Keith On Jul 26, 2012 4:17 AM, "Zhigang Zhang" wrote: > Hello: > > > > I haven't read the source code of mysql ,but as I know ,the slave get data > fro

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

Thanks Dhaval. Putting the join condition before INTO outfile doesn't seem to work, either. When I try to use the same outfile name 'test123.csv' I get Error Code: 1086 File 'test123.csv' already exists. But then when I try to find the csv file on my computer, there is a folder with that name, b

Re: How often the slave to pull data from master?

- Original Message - > From: "Zhigang Zhang" > > I haven't read the source code of mysql ,but as I know ,the slave get > > I think there is a timer to do this. You have also not read the documentation, then. There is not. Replication is continuous: the slave opens a permanent connectio

Re: how often the slave to pull data from master?

Please can someone correct me if I am wrong. It doesn't work with timer. On your *master*, you need to activate the binaries log. Everytime and UPDATE/INSERT/DELETE is done on the master mysql server, the event is recorded within those binaries log. On your *slave* - if it is activated to act as

how often the slave to pull data from master?

Hello: I haven't read the source code of mysql ,but as I know ,the slave get data from master server, rather than the master push data to slave. I think there is a timer to do this. Who can tell me the interval about the replicationhow often the slave to pull data from master? Thanks! Zhig

How often the slave to pull data from master?

Hello: I haven't read the source code of mysql ,but as I know ,the slave get data from master server, rather than the master push data to slave. I think there is a timer to do this. Who can tell me the interval about the replicationhow often the slave to pull data from master? T