Re: DB crashing while dumping

On Sun, Feb 15, 2009 at 1:43 PM, Martin Gainty wrote: > Jason- > > can we see the schema and a few data rows for > `soapware_charts_xmldocumentitems` > says something about invalid pointers? > > Martin > Ok, I hope this is what you are wanting, I'm a newb. schema: http://papernapkin.org/pas

Re: DB crashing while dumping

>From what I read it is indeed a bug that was so far only found on 64 bits amd platform. Maybe it is not what is causing your problem, but it is worth looking into :) Walter PS. Sorry for just posting a link in my last message. I was tired and din't have much time :) OlinData: Professional servi

Re: DB crashing while dumping

On Sun, Feb 15, 2009 at 4:07 PM, Walter Heck wrote: > http://bugs.mysql.com/bug.php?id=26081 > Walter, Thanks for replying. I read the bug and the comments. This seems to be a problem on 64bit AMD hardware. Is this a correct assessment? I'm using 2x Xeon quad core 64bit. Thanks, jd

RE: Show Databases issue

Ok, I figured it out. My scenario Had "Deactivate show databases" checked, so users got access denied error when trying to exec show databases. Granted show databases to a user, and now they see all of the databases. New Scenario Unchecked "Deactivate show databases" Removed granted show dat

Re: Show Databases issue

On Sun, 15 Feb 2009, John wrote: > How do I disable showing ALL the databases on the server for a normal user > that only has access to a single database? So that when a user runs show > databases, they only get a list of ones they can access. I've seen this done > before. > > Sorry if it's a newb

Show Databases issue

How do I disable showing ALL the databases on the server for a normal user that only has access to a single database? So that when a user runs show databases, they only get a list of ones they can access. I've seen this done before. Sorry if it's a newb question. John -- MySQL General Mailing

Re: DB crashing while dumping

http://bugs.mysql.com/bug.php?id=26081 OlinData: Professional services for MySQL Support * Consulting * Administration http://www.olindata.com On Sun, Feb 15, 2009 at 9:43 PM, Martin Gainty wrote: > > Jason- > > can we see the schema and a few data rows for > `soapware_charts_xmldocumentitems

Re: Simple data, simple query giving me a brain-ache

The * was just because I am lazy, the point of my question was related to the original post, where he was using "Group by" and "Order by". My question was really "Why not just use order by"? So (with my original question) I should have written: SELECT firstname, lastname from HowToExample ORDER

Re: Simple Search Logic Issue...

Hi Dave, all! revDAVE wrote: > [[...]] > > I'm hoping to get results based on what criteria I type - but I'm not > getting what I expect. I think it's just getting results where in addition > to getting search criteria I type - ALSO none of the search fields can be > blank (not what I hoped) ...

Re: How to execute prepare statement when the placeholder is a specific table name?

Hi, I made a silly typo: Joerg Bruehe wrote: > [[...]] > > So allowing placeholders (variables) for identifiers (table, column, and > other database object names) would block (future) optimization. > > That is (probably) the reason why the SQL standard also does not allow > this.

Re: How to execute prepare statement when the placeholder is a specific table name?

Hi all! Paul DuBois wrote: > > On Feb 14, 2009, at 8:00 PM, Moon's Father wrote: > >> Thanks for your fast reply. >> >> Do you know MySQL will support this feature in the future? (("this feature" = placeholders for table names in prepared statements)) > > It doesn't need to. Baron indicated h

RE: DB crashing while dumping

Jason- can we see the schema and a few data rows for `soapware_charts_xmldocumentitems` says something about invalid pointers? Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official busine

Re: When will MySQL support array datatype?

Complex datatypes are not compatible with the concept of relational databases, probably you want to refer to an Object-Oriented DBMS or Object-Relational DBMS. Cheers Claudio Nanni Moon's Father wrote: Hi. Who could tell me when the MySQL support array datatype? Any reply will be appreciat

DB crashing while dumping

Hello, I have been trying mysqldump with different switches to get my DB to dump. All give me the same error (after dumping 218gigs) : http://papernapkin.org/pastebin/view/4447/ Here is the command I'm currently trying.. mysqldump -A -q -v --lock-all-tables -u root -p --skip-extended-insert --

Re: When will MySQL support array datatype?

Who could tell me when the MySQL support array datatype? Any reply will be appreciated. Given that you appreciate -any- reply ... I hope it never supports it. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Syba

Re: How to execute prepare statement when the placeholder is a specific table name?

On Feb 14, 2009, at 8:00 PM, Moon's Father wrote: Thanks for your fast reply. Do you know MySQL will support this feature in the future? It doesn't need to. Baron indicated how you can solve this problem. If you look at prepared statements in general (not just for MySQL), placeholders ar

updates in slow query log

Is there anyway to keep updates and deletes from showing up in the slow query logs?