Using Excel to query the database

2011-08-15 Thread Rob Tanner
Hi, I have a fairly standard set of queries that I do then I save the resultset as a CSV and send it off to a couple dozen folks. My understanding is that I can build an Excel .iqy file that can do the queries (one for each query) and that I need send that file but once to the users. Does any

Re: hand replication

2011-08-15 Thread Hal�sz S�ndor
Thank you for the advice, and I read about "mysqlbinlog" 2011/08/15 10:22 -0400, Shawn Green (MySQL) 1) extract the statements from the binary log. 2) get the master to sent you the statements just as if you were a slave. mysqlbinlog will do either - (again, read the manual on how t

Re: hand replication

2011-08-15 Thread Shawn Green (MySQL)
On 8/15/2011 09:06, wrote: 2011/08/10 08:16 +0200, Johan De Meersman Yes, the MySQL binary log can be read (and thus, re-executed) by the mysqlbinlog utility. Yes, but what is the best means of picking up the changes from the instance where there were changes to the instance that

Re: hand replication

2011-08-15 Thread Hal�sz S�ndor
2011/08/10 08:16 +0200, Johan De Meersman Yes, the MySQL binary log can be read (and thus, re-executed) by the mysqlbinlog utility. Yes, but what is the best means of picking up the changes from the instance where there were changes to the instance that is a copy? Is it best to