MySQL GA & clustering

2010-11-18 Thread Machiel Richards
Good day all I would just like to confirm the following please. I have a client who is running the free downloadable version of MySQL and they would like to go the clustering route for quite a couple of reasons. Does anybody know whether clustering is availabl

Re: export db to oracle

2010-11-18 Thread Johan De Meersman
On Thu, Nov 18, 2010 at 2:54 PM, Sydney Puente wrot > a mysqldump might do that job too, but the output from mysqldump > --compatible > was rejected by oracle. > Hmm. Interesting, you might want to file an issue about that - now that MySQL is oracle-owned, you'd expect at least that to work, wou

Re: Does mysql cache strip out /* comments */ first?

2010-11-18 Thread Waynn Lue
Percona's got a great reputation in the community, and I would have no qualms using their builds. On 11/18/10, Ewen Fortune wrote: > Daevid, > > On Thu, Nov 18, 2010 at 11:41 PM, Daevid Vincent wrote: >> Ewen thank you! You've opened my eyes to something I didn't even know >> about >> and made m

Re: Granting access rights to a user

2010-11-18 Thread Tim Johnson
* Tim Johnson [101118 12:58]: > * Tim Johnson [101118 11:05]: > > using > > mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu > > > > I have root access to the mysql command line. > > > > I need to grant access to user 'username' for all databases > > except for the mysql database for both

Re: Does mysql cache strip out /* comments */ first?

2010-11-18 Thread Ewen Fortune
Daevid, On Thu, Nov 18, 2010 at 11:41 PM, Daevid Vincent wrote: > Ewen thank you! You've opened my eyes to something I didn't even know about > and made my "special purpose" tingle. > > Have you used Percona personally? What are your opinions/thoughts? If you > haven't used it, I'd be curious why

RE: Does mysql cache strip out /* comments */ first?

2010-11-18 Thread Daevid Vincent
Ewen thank you! You've opened my eyes to something I didn't even know about and made my "special purpose" tingle. Have you used Percona personally? What are your opinions/thoughts? If you haven't used it, I'd be curious why not or what turned you "away" from it? > -Original Message- > Fr

Re: Granting access rights to a user

2010-11-18 Thread Tim Johnson
* Tim Johnson [101118 11:05]: > using > mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu > > I have root access to the mysql command line. > > I need to grant access to user 'username' for all databases > except for the mysql database for both onsite (cgi script) and > remote access. > >

Granting access rights to a user

2010-11-18 Thread Tim Johnson
using mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu I have root access to the mysql command line. I need to grant access to user 'username' for all databases except for the mysql database for both onsite (cgi script) and remote access. What is the syntax? -- Tim tim at johnsons-web.c

Re: export db to oracle

2010-11-18 Thread Sydney Puente
Hi, Actually all the helpful tips that I have gotten have caused me to review the requirements! I now realise that that csv or xml files for the storage of an extract would be helpful, for testing and validation. a mysqldump might do that job too, but the output from mysqldump --compatible was r

Re: Does mysql cache strip out /* comments */ first?

2010-11-18 Thread Ewen Fortune
Daevid, > My concern is, my gut tells me that the built in mysql cache system is > "dumb". And by that I mean, I suspect that mySQL isn't "smart" enough to > strip out comments from the SQL statement string BEFORE storing it as the > cache hash key (yet I have no facts either way to back it up an

Re: Does mysql cache strip out /* comments */ first?

2010-11-18 Thread Johan De Meersman
On Thu, Nov 18, 2010 at 9:00 AM, wrote: > I think you will probably find that the code you write isn't what MySQL > executes or stores in the cache. > it is indeed not quite what it executes, but as I understand it the QC index is *exactly* the string you send (well, hashed presumably), includin

Mysql installation - Innodb not enabled?

2010-11-18 Thread Machiel Richards
Good day all We have downloaded the following MySQL version which untarred to provide a list of RPM's: MySQL-server-advanced-gpl-5.1.50-1.rhel5.x86_64.tar The installations went through fine, however while doing some configurations I found that Innodb is not enabled / installed.

RE: Does mysql cache strip out /* comments */ first?

2010-11-18 Thread andrew.2.moore
I think you will probably find that the code you write isn't what MySQL executes or stores in the cache. From: vegiv...@gmail.com [vegiv...@gmail.com] On Behalf Of ext Johan De Meersman [vegiv...@tuxera.be] Sent: 18 November 2010 07:48 To: Daevid Vincent