BLOB data gets encoded as utf8! (Anyone?)

Has no one encountered this before? There has got to be a solution, and I still haven't found it... So if you have any input please let me know! -Original Message- From: Andreas Iwanowski [mailto:namez...@afim.info] Sent: Tuesday, August 24, 2010 2:48 PM To: mysql@lists.mysql.com Subject

RE: Creating a dedicated reporting server for management?

You misunderstand. The slave is LIVE. Every write to the master writes to BOTH slaves. You can add as many slaves to a master as you want. My point was IN ADDITION to that benefit, it also affords you the ability to take down one of the slaves for an offsite archive. So if you need master/slave f

Re: dynamic alias?

It would be easiest if you showed us the query you are using but the simple column alias has been in MySQL since v2 SELECT foo, count(*) bar AS mycount FROM... In keeping with SQL practice, the 'AS' keyword is optional but it does make it easier to see the syntax. This is equivalent: SELECT foo

Surge 2010 Early Registration ends Tuesday!

Early Bird Registration for Surge Scalability Conference 2010 ends next Tuesday, August 31. We have a killer lineup of speakers and architects from across the Internet. Listen to experts talk about the newest methods and technologies for scaling your Web presence. http://omniti.com/surge/2010/re

RE: dynamic alias?

Thanks, PREPARE certainly has some potential. Unfortunately, when I try to use that sort of thing inside of a Cognos report, it complains that "At least one expression in the Select clause is missing the AS clause to make it a proper alias." (Sorry I didn't include the Cognos context -- it didn't

RE: dynamic alias?

DATE_ADD(NOW(), INTERVAL 1 DAY) will give you tomorrow... Not sure if that is what you're looking for or not... Steven Staples > -Original Message- > From: Eric Bloomquist [mailto:eric_bloomqu...@cooley-dickinson.org] > Sent: August 27, 2010 12:17 PM > To: mysql@lists.mysql.com > Subje

RE: How To Duplicate Number of Hits from Prod Sever to NEW QA server?

>-Original Message- >From: Nunzio Daveri [mailto:nunziodav...@yahoo.com] >Sent: Friday, August 27, 2010 10:19 AM >To: mysql@lists.mysql.com >Subject: How To Duplicate Number of Hits from Prod Sever to NEW QA server? > >Hello, I have been asked to "replay" the traffic load we have on one of

Re: dynamic alias?

On 8/27/2010 11:16 AM, Eric Bloomquist wrote: Hi all, I'm wondering if it's possible to have a dynamic alias in MySQL. The result I'm looking for is essentially: See the manual page for PREPARE. PB - +-+---++ | Provider Name

dynamic alias?

Hi all, I'm wondering if it's possible to have a dynamic alias in MySQL. The result I'm looking for is essentially: +-+---++ | Provider Name | Facility Name | Appts on 8/28/2010 | <== +-+---

How To Duplicate Number of Hits from Prod Sever to NEW QA server?

Hello, I have been asked to "replay" the traffic load we have on one of our 5.1.4X servers against a new 5.5 test server we are getting ready to put into production as a stand alone. My question is that I have 6GB of mysqld.log BUT how to I figure out how MUCH to play back at a given time and h