myslqd_safe & is not starting. pls help

hi anyone can help. its urgent. iam trying to start mysql server but it is not starting. bash-2.03# ./mysqld_safe & [2] 3422 bash-2.03# Starting mysqld daemon with databases from /usr/local/mysql/var STOPPING server from pid file /usr/local/mysql/var/andd141.pid 100114 11:31:22 mysqld e

RE: Help with export and import into Oracle

>It seems that one of the tables we need to export and import >contains rows which is used for dropdown menus. > > > >This has the following effect: > > > >. Each item in the "text" field is added in the field by entering >the country name then pressing ente

Re: Help with export and import into Oracle

machiel.richards wrote: Good day guys [snip] . Each item in the "text" field is added in the field by entering the country name then pressing enter and then entering the next, etc . When exporting the data to a file (even when enclosing each field within quotes) it still wr

Help with export and import into Oracle

Good day guys I previously requested information regarding the exporting of data which needs to be imported into oracle. We are however still struggling with the data though and maybe someone can give me some ideas... It seems that one of

Re: Help for mysql@lists.mysql.com

Hi list, i am trying to add mysql support to my project using autoconf. Following flags are are generated: LIBS=-lmysqlclient -lssl -lpthread -lresolv -lm -L/usr/lib -lcrypto - lssl -lstdc++ -L/Developer/SDKs/MacOSX10.4u.sdk/usr/lib -L/Developer/ SDKs/MacOSX10.4u.sdk/usr/lib/system -L/usr/loca

Re: Help keep the Internet free

Monty, Good looking site. I just signed the petition and hope others will too. Go get'em Monty! Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Help keep the Internet free 6D7-36A

d sign the petition and tell others about it! We are also searching for volunteers that can help us with gathering names for the petition. If you have a bit a spare time and think that MySQL is worth saving, please join us on the #helpmysql IRC channel on Freenode and help us with spreading the worl

RE: Help keep the Internet free

I am from Indonesia, have been use The Great MySQL for 10 years in development and production environments. Count me in. Willy Sent from my Sony Ericsson XPERIA™ X1. -Original Message- From: Michael Widenius Sent: 29 December 2009 19:59 To: mysql@lists.mysql.com Subject: Help keep

Re: Help keep the Internet free

d sign the petition and tell others about it! We are also searching for volunteers that can help us with gathering names for the petition. If you have a bit a spare time and think that MySQL is worth saving, please join us on the #helpmysql IRC channel on Freenode and help us with spreading the wo

Help keep the Internet free

care about the future of MySQL as an Open Source product, please go and sign the petition and tell others about it! We are also searching for volunteers that can help us with gathering names for the petition. If you have a bit a spare time and think that MySQL is worth saving, please join us o

Re: HELP! "RESET MASTER" hosed replication

Yep, It might not be needed to sync, but its better to double check ;). Carlos On 12/23/2009 2:44 PM, Claudio Nanni wrote: In this case it should not be needed to sync the slave, Resetting the master basically broke the 'pipe' but events are still on the new binary logs, it might have lost s

RE: HELP! "RESET MASTER" hosed replication

> To: Carlos Proal > Cc: mysql@lists.mysql.com > Subject: Re: HELP! "RESET MASTER" hosed replication > > *Next time look for 'purge binary logs'!* > > Purge may also cause problem , before doing purge make sure > slave is in sync > with master or at

Re: HELP! "RESET MASTER" hosed replication

*Next time look for 'purge binary logs'!* Purge may also cause problem , before doing purge make sure slave is in sync with master or at least cross check slave currently which bin file getting sync. On Thu, Dec 24, 2009 at 2:05 AM, Carlos Proal wrote: > > The issue is that replication relies on

Re: HELP! "RESET MASTER" hosed replication

In this case it should not be needed to sync the slave, Resetting the master basically broke the 'pipe' but events are still on the new binary logs, it might have lost some event in some unfortunate case, but anyway it is probably for now to put slave back on track, check and eventually resync. Cia

Re: HELP! "RESET MASTER" hosed replication

The issue is that replication relies on this logs !!!, so when you deleted them . Generally speaking you have to: > stop the slave > sync the master with the slave (there are several ways to do this and depending how busy is your master) >grab the master status (position) >change the sla

Re: HELP! "RESET MASTER" hosed replication

That was a wrong operation to do. Anyway, issue a show master status, and set the replucation again on the slave with the new values. Next time look for 'purge binary logs'! Ciao Claudio On 23 dec 2009 21:21, "Daevid Vincent" wrote: I got an alert that one of the drives was filling up (3% free).

HELP! "RESET MASTER" hosed replication

I got an alert that one of the drives was filling up (3% free). So I figured out that a large chunk was from /var/log/mysql r...@pse10:~# find / -type d -print0 | xargs -0 -n1 du -sk | sort -rn | head -n20 > ~/dir-sizes.txt r...@pse10:~# cat ~/dir-sizes.txt 159121012 / 70442396 /var 70127764 /v

RE: help design the table

>-Original Message- >From: Mikhail Berman [mailto:mikhail...@gmail.com] >Sent: Wednesday, December 23, 2009 9:16 AM >To: Eva >Cc: mysql@lists.mysql.com >Subject: Re: help design the table > >Hi Eva, > >It seems to me that you might want to have two tables th

Re: help design the table

e IPs, each IP has two attributes: "disabled","noticed". > > For example, the table: > > > domainIP > www.aol.com 64.12.245.203 64.12.244.203 64.12.190.33 64.12.190.1 > > > But I don't know how to control the IP's attributes if I se

help design the table

#x27;t know how to control the IP's attributes if I set this table-stru. Please help,thanks. Eva. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Help Save MySQL

On 12/18/09 12:41 PM, "Douglas Nelson" wrote: > You guys are incredibly naive, Oracle has promised to support MySQL for > the next 5 years. thanks. you too. > Who better to have stewardship of a database product > then the leading database supplier. almost anyone, since you ask. > I think you

Re: Help Save MySQL

hands of half cocked want-a-be's would surely be the > death > blow to MySQL faster then Oracle would ever hope too.. should they > decide to. So at least for the next 5 years sit back and enjoy the > ride! > > Thanks Doug > > Peter Brawley wrote: >

RE: Fwd: Re: Help Save MySQL

t: Re: Fwd: Re: Help Save MySQL You guys are incredibly naive, Oracle has promised to support MySQL for the next 5 years. Who better to have stewardship of a database product then the leading database supplier. I think you guys have visions of grandeur to think you could spend this kind of

Re: Fwd: Re: Help Save MySQL

he next 5 years sit back and enjoy the ride! Thanks Doug Peter Brawley wrote: Actually just $8.95/year, I just registered save-mysql.org. Anybody want to help set up the page? PB - Peter Brawley wrote: Twenty bucks a year to hold the domain name. I'll do it if a couple of folks v

Re: Fwd: Re: Help Save MySQL

Actually just $8.95/year, I just registered save-mysql.org. Anybody want to help set up the page? PB - Peter Brawley wrote: Twenty bucks a year to hold the domain name. I'll do it if a couple of folks volunteer to help set up the page. PB - Bruno B. B. Magalhães wrote:

Re: Fwd: Re: Help Save MySQL

domain name. I'll do it if a couple of folks volunteer to help set up the page. PB - Bruno B. B. Magalhães wrote: Lets register the domain www.keep-mysql-open.com, build a champain, and ask all our partners, clients and friends to support to it? And let's make some noise... Let&#x

Re: Help Save MySQL

You wanna help MySQL? Here's an idea - buy something. Everyone wants great software for free but the paid conversion rates on open source are a joke. I know nothing of MySQL numbers for conversion to paid versions but I would guess they are low. Unfortunately the reality is that

Re: Fwd: Re: Help Save MySQL

Twenty bucks a year to hold the domain name. I'll do it if a couple of folks volunteer to help set up the page. PB - Bruno B. B. Magalhães wrote: Lets register the domain www.keep-mysql-open.com, build a champain, and ask all our partners, clients and friends to support to it? And

Fwd: Re: Help Save MySQL

to another party. What we need is ACTION. So if someone could provide us with the names of these regulatory parties and their email addresses, we can try to light a fire under them to put pressure on Oracle. A web page to SaveMySQL would also help get our message across. What do you think guys? Ca

Re: Help Save MySQL

MySQL to another party. What we need is ACTION. So if someone could provide us with the names of these regulatory parties and their email addresses, we can try to light a fire under them to put pressure on Oracle. A web page to SaveMySQL would also help get our message across. What do you

Re: Help Save MySQL

I am in! Bruno B. B. Magalhaes wrote: Hi Guys, Let's say that every mysql developer (here I am thinking only persons, not companies) that wants mysql to go forward would contribute from $500,00 to $1500,00, how much are we talking about? And we would have a 100% community owned and community

RE: Help Save MySQL

== Sent via HP IPAQ mobile device -Original Message- From: Bruno B. B. Magalhaes Sent: 17 December 2009 17:06 To: mysql@lists.mysql.com Subject: Re: Help Save MySQL Hi Guys, Let's say that every mysql developer (here I am thinking only persons, not companies) that wants m

Re: Help saving MySQL

Martjin, I really don't like to point fingers or anything like that, but the simple fact Oracle owns the MySQL copyrights is by it self very concerning, as all our investments (time and money) could be lost over night, if Oracles decides to close de source or change it's licensing policies. Man

Re: Help saving MySQL

John, Another read on the subject: http://blogs.the451group.com/opensource/2009/12/10/the-case-against-the-case-against-oracle-mysql/ Enjoy. With regards, Martijn Tonies Upscene Productions http://www.upscene.com I see some of your point Martin but I think the eu would look at that letter a

Re: Help Save MySQL

Maybe a three-years consul composed from and elected by the community (by community I mean the people >that contributed with funds, not the user community) by voting? I have been quite closely involved in doing this for the Firebird project, you would be amazed as to how hard it is to get thing

Re: Help Save MySQL

Maybe a three-years consul composed from and elected by the community (by community I mean the people that contributed with funds, not the user community) by voting? Regards, Bruno B. B. Magalhães BLACKBEAN CONSULTORIA Rua Real Grandeza 193, Sala 210, Botafogo Rio de Janeiro, RJ, 22281-035, Br

Re: Help Save MySQL

Hey, Let's say that every mysql developer (here I am thinking only persons, not companies) that wants mysql to go >forward would contribute from $500,00 to $1500,00, how much are we talking about? And we would have a >100% community owned and community driven open source initiative... Course

Re: Help saving MySQL

t;Regards > >John > >-Original Message- >From: Martijn Tonies >Sent: 16 December 2009 13:16 >Cc: mysql@lists.mysql.com >Subject: Re: Help saving MySQL > >> It's still not too late to save MySQL and everyone that is using MySQL >> > > can

Re: Help Save MySQL

Hi Guys, Let's say that every mysql developer (here I am thinking only persons, not companies) that wants mysql to go forward would contribute from $500,00 to $1500,00, how much are we talking about? And we would have a 100% community owned and community driven open source initiative... Course

RE: Help Save MySQL

> If that’s what the price is going to be then perhaps I should > offer 2€ or maybe MySQL users should get together submit a > realistic offer. This sounds interesting... Get a community effort to accept donations and purchase MySQL. Then, put it under the GPL and make sure nobody owns it.

Re: Help saving MySQL

I see some of your point Martin but I think the eu would look at that letter and see the author is stating 'MySQL has been used as a pricing lever'. That single factor should be enough for them to be very concerned by an acquisition as removing an effective pricing lever from the market by acqui

RE: Help saving MySQL

m can boast the performance benefits (especially with ndbcluster) or the availability of suitably trained and certified people to support their products. Regards John -Original Message- From: Martijn Tonies Sent: 17 December 2009 09:44 To: mysql@lists.mysql.com Subject: Re: Help saving

Help Save MySQL

Just wanted to see what people thought about the offer from Nexedi for MySQL http://www.nexedi.com/NXD-MySQL.Takeover/view They obviously have more reason to protect and develop MySQL but are they serious? 1€ for a profitable business unit with a turnover of around $100m. If that’s what the pr

Re: Help saving MySQL

or commercial projects!) to do the same. > Please visit > http://monty-says.blogspot.com/2009/12/help-saving-mysql.html > and write a message to EC! Guess you don't want them to write letters like this? http://kirkwylie.blogspot.com/2009/12/my-open-letter-to-european-comp

RE: Help saving MySQL

ysql@lists.mysql.com Subject: Re: Help saving MySQL > It's still not too late to save MySQL and everyone that is using MySQL > can help making a real difference. > Please visit > http://monty-says.blogspot.com/2009/12/help-saving-mysql.html > and write a message to EC! > >

Re: Help saving MySQL

It's still not too late to save MySQL and everyone that is using MySQL can help making a real difference. Please visit http://monty-says.blogspot.com/2009/12/help-saving-mysql.html and write a message to EC! Regards, Monty Guess you don't want them to write letters like

Re: Help saving MySQL

written an analyse of this at: > http://monty-says.blogspot.com/2009/10/importance-of-license-model- of-mysql-or.html > > The promises that Oracle has done regarding MySQL are not enough to > protect MySQL from being killed as an Open Source project; When you > analyse them, they are a

Re: Help saving MySQL

g MySQL are not enough to protect MySQL from being killed as an Open Source project; When you analyse them, they are actually promising very little now and nothing after 5 years! It's still not too late to save MySQL and everyone that is using MySQL can help making a real difference. Please vi

Re: Help saving MySQL

> Tom Worster : > my guess is that it would be better if mysql did not need to fork. > the harm would be the confusion caused to users. I really dont think it is a problem. _Users_ lazzy to follow the fork will stay with MySQL under Oracle. _Users_ less lazzy will switch. Developpers will always

RE: Help saving MySQL

gt; To: f...@thefsb.org ; claudio.na...@gmail.com > Cc: mysql@lists.mysql.com > Subject: RE: Help saving MySQL > > MySQL is a huge and trusted brand, yes you could run with a > fork but at the end of the day it will never be MySQL. Its > that MySQL brand name which sells the u

RE: Help saving MySQL

PAQ mobile device -Original Message- From: Tom Worster Sent: 14 December 2009 20:02 To: claudio.na...@gmail.com Cc: mysql@lists.mysql.com Subject: Re: Help saving MySQL and thanks for sharing your view. here's mine: mysql was sold to sun, a company with a long and deep commitment

Re: Help saving MySQL

I think we are on the same line, I put it to excess to spotlight the crucial point, how it was based on the 'good will' of Sun, which I simply adhore and thank only for existing I was actually happy when that happened because with Sun, MySQL was perfectly fitting in the big picture of Sun produc

Re: Help saving MySQL

and thanks for sharing your view. here's mine: mysql was sold to sun, a company with a long and deep commitment to oos. while there were obviously risks to the sale, one plausible motive (among others) is that a company like sun would be better placed to further develop, market and support mysql,

Re: Help saving MySQL

You build a green park where children can play. Then you sell the park to a private company. The company can: not mantain it so that the park becomes junkies place, have people pay to access it or even close it. I, the builder, would not start a crusade or weep after I have sold it, Once it is on t

Re: Help saving MySQL

On 12/13/09 11:23 AM, "Neil Aggarwal" wrote: > Doug: > >> I do not >> see anyone willing to put up anything to support mysql... you >> don't like >> it... put up a billion dollars an take control or shut the heck up! > > Assuming MySQL as it stands today is 100% open source, > I think an easi

Re: Help saving MySQL

On 12/14/09 1:49 AM, "Claudio Nanni" wrote: > If he really cared about MySQL he would have not sold it or prevent from > selling it to Sun. i don't see the logic in this sentence. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.my

Re: Help saving MySQL

e: +44(0)1283 537111 Mobile: +44(0)7812 451238 Email: john.dais...@butterflysystems.co.uk === Sent via HP IPAQ mobile device -Original Message- From: Claudio Nanni Sent: 14 December 2009 06:30 To: mo...@askmonty.org Cc: mysql@lists.mysql.com Subject: Re: Help saving MySQL "Due to sel

Re: Help saving MySQL

283 537111 > Mobile: +44(0)7812 451238 > Email: john.dais...@butterflysystems.co.uk > > === > > Sent via HP IPAQ mobile device > > -Original Message- > From: Claudio Nanni > Sent: 14 December 2009 06:30 > To: mo...@askmonty.org > Cc: mysql@lists.mysql.com >

RE: Help saving MySQL

erflysystems.co.uk === Sent via HP IPAQ mobile device -Original Message- From: Claudio Nanni Sent: 14 December 2009 06:30 To: mo...@askmonty.org Cc: mysql@lists.mysql.com Subject: Re: Help saving MySQL "Due to selling MySQL to Sun, Widenius earned about 16.6 million €

Re: Help saving MySQL

Claudio Nanni wrote: If he really cared about MySQL he would have not sold it or prevent from selling it to Sun. Initially her was convinced that MySQL as a division of Sun would really benefit the future of MySQL [1]. Obviously his relationship with Sun changed "a bit" later on. It shows tha

Re: Help saving MySQL

Totally agree. But in the moment you sell something you lose control on it, and one of the more or less foreseeable risks is exactly what is happening, and worst nightmare become truth. Cheers Claudio Neil Aggarwal wrote: "Due to selling MySQL to Sun, Widenius earned about 16.6 million € in

RE: Help saving MySQL

> "Due to selling MySQL to Sun, Widenius earned about 16.6 million € in > capital gains in So, he got paid for his contribution to the world. Is that so bad? MySQL has allowed people to make much more money than that. It is a small amount of the worl

Re: Help saving MySQL

If he really cared about MySQL he would have not sold it or prevent from selling it to Sun. Cheers Claudio Jigal van Hemert wrote: Claudio Nanni wrote: "Due to selling MySQL to Sun, Widenius earned about 16.6 million € in (...) I fail to see the relevance of this quote for this thread...

Re: Help saving MySQL

Claudio Nanni wrote: "Due to selling MySQL to Sun, Widenius earned about 16.6 million € in (...) I fail to see the relevance of this quote for this thread... Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.co

Re: Help saving MySQL

l Widenius wrote: Subject: Help saving MySQL from Oracle! I, Michael "Monty" Widenius, the creator of MySQL, is asking you urgently to help save MySQL from Oracle's clutches. Without your immediate help Oracle might get to own MySQL any day now. By writing to the European Commission (EC)

Re: Query help

SELECT count(distinct trans_no) from SEARCHES WHERE comp_id=675 and result='o'; - Original Message - From: "Richard Reina" To: Cc: Sent: Sunday, December 13, 2009 11:36 AM Subject: Query help I was wondering if someone could lend a hand with the following q

Re: Help saving MySQL

> Michael Dykman : > Are we such sheep that we leave this in the hands of the highest > bidder? I dont understand: Dont'you like the idea of forking? Why exactly? -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche & Developpement +261

Re: Query help

675 got a result 'o' which would be 2 (455 & > 302). I have tried different group by columns but to no avail. Can > someone help? > > Thanks, > > Richard > select count(trans_no), comp_id from SEARCHES group by comp_id I think that should do it...haven'

RE: Query help

gt; From: Richard Reina [mailto:rich...@rushlogistics.com] > Sent: Sunday, December 13, 2009 12:37 PM > To: mysql@lists.mysql.com > Cc: rich...@rushlogistics.com > Subject: Query help > > I was wondering if someone could lend a hand with the following query. > I have table. > > SEARC

Query help

x27;o' GROUP BY trans_no; gives me a count of 3. However, what I need is a count for how many different (unique) transactions company number 675 got a result 'o' which would be 2 (455 & 302). I have tried different group by columns but to no avail. Can someone help? Th

Re: Help saving MySQL

I am astonished that this attitude could exist in the open source world. MySQL has *always* been open source, since the early days when it was a handful of us lurking on Monty's mailing list waiting breathlessly for the next feature to be released so we could release the projects we had built agai

RE: Help saving MySQL

Doug: > I do not > see anyone willing to put up anything to support mysql... you > don't like > it... put up a billion dollars an take control or shut the heck up! Assuming MySQL as it stands today is 100% open source, I think an easier path is to create a new project from the currently existi

Re: Help saving MySQL

h... All this is what might happen...that true...But yet I do not see anyone willing to put up anything to support mysql... you don't like it... put up a billion dollars an take control or shut the heck up! Doug Ryan Chan wrote: On Sun, Dec 13, 2009 at 11:48 AM, Michael Dykman wrote:

Re: Help saving MySQL

> Ryan Chan : > On Sun, Dec 13, 2009 at 11:48 AM, Michael Dykman > wrote: > > I hope the only reason this thread  is so quiet is because we are > > all busy notifying our friends.  There are a hell of a lot more > > users invested in MySQL than those who read this list.  Spread the > > word! > >

Re: Help saving MySQL

On Sun, Dec 13, 2009 at 11:48 AM, Michael Dykman wrote: > I hope the only reason this thread  is so quiet is because we are all > busy notifying our friends.  There are a hell of a lot more users > invested in MySQL than those who read this list.  Spread the word! > Let's stand up today to face t

Re: Help saving MySQL

I hope the only reason this thread is so quiet is because we are all busy notifying our friends. There are a hell of a lot more users invested in MySQL than those who read this list. Spread the word! Monty is not asking us to help him: he is asking you to help yourselves. MySQL has never been

Help saving MySQL

Subject: Help saving MySQL from Oracle! I, Michael "Monty" Widenius, the creator of MySQL, is asking you urgently to help save MySQL from Oracle's clutches. Without your immediate help Oracle might get to own MySQL any day now. By writing to the European Commission (EC) you c

Help with SELECT clause

I'm stuck again ... and perhaps it's just not designed right, but I inherited this setup, so if anyone has suggestions on how to make it better, I'm all ears. This is all one table ... describe approvals; +---+--+--+-+-++ | Field

Re: mysql performance issue. pls help..

s. it taking more > time to execute query.. > > developers created tables on myIsam and Innodb. i have a doubts whether we > can use both storage same time.. > > i have 2 thinks in my minds to check this performance. > 1. to check innodb and myisam db memory pools. > 2. to ch

mysql performance issue. pls help..

myisam db memory pools. 2. to check any index are required. based on the above to points i plan to investigate. so please help I am not familiar with mysql and first time iam working with developers. can any help to fix the problem. please assist me what i have to check now?. Best Regards Faizal

Database design and query help

Hello, Currently, I have four tables (Items, UpdatePrice, UpdateStatus and UpdateRelease). All the Update tables are linked to Items.ItemID via Update(Price|Status|Release)ItemKey. Personally, I don't feel that this is the best database design I could have, but I can't seem to come up with one tha

RE: 50M records each year, help me choosing the stretegy

Sudhir, please remove the || from your name in your email: "|| Sudhir Nimavat ||" We have about 1 BILLION rows of data here and we do a few tricks which may or may not be of interest to you. For starters, setup replication and write to a master and have at least 2 slaves. This makes backups MUCH

Re: Fw: 50M records each year, help me choosing the stretegy

ow write operation. > > Thanks > SN > > > > > > > > Personally I'm always ready to learn, although I do not always like being > taught > > > > > - Forwarded Message > From: "sudhir543-nima...@yahoo.com" > To: Jay Ess > Sent

Fw: 50M records each year, help me choosing the stretegy

learn, although I do not always like being taught - Forwarded Message From: "sudhir543-nima...@yahoo.com" To: Jay Ess Sent: Mon, 2 November, 2009 3:34:52 PM Subject: Re: 50M records each year, help me choosing the stretegy Its a very simple table that will store messages

Re: 50M records each year, help me choosing the stretegy

sudhir543-nima...@yahoo.com wrote: I have come across a requirement where I need to store a very large amount of data in a table. In one of our app.. we can have around 50 Million records each year.. Can any one guide me in choosing a strategy than can handle this load. 50M records is not th

50M records each year, help me choosing the stretegy

I have come across a requirement where I need to store a very large amount of data in a table. In one of our app.. we can have around 50 Million records each year.. Can any one guide me in choosing a strategy than can handle this load. Thanks SN Sudhir NimavatSenior software engineer

Re: help with group by

works perfectly, i didn't know you could use multiple columns in the group by. thanks a bunch! Michael Dykman wrote: try this: select accepted_by, problem_type, count(*) from form where problem_type is not NULL AND problem_type != 'Test' AND accepted_by is not null group by accepted_by, probl

Re: help with group by

try this: select accepted_by, problem_type, count(*) from form where problem_type is not NULL AND problem_type != 'Test' AND accepted_by is not null group by accepted_by, problem_type On Wed, Oct 28, 2009 at 12:05 PM, Adam Williams wrote: > I've written a helpdesk ticket problem and am working

help with group by

I've written a helpdesk ticket problem and am working on the statistics module. I'm having problems with group by. For instance, I want to get the count of the number of different problem types, by how many were solved by each person. This is my statement: mysql> select distinct accepted_by

RE: Help! Can't get my MySQL service started!

: mysql@lists.mysql.com Subject: Help! Can't get my MySQL service started! I'm trying to configure and start a MySQL 5.1 service for the first time, and I'm having trouble. The MySQL Server 5.1 system was installed on a separate drive from the system drive (if that's an issue). My

Help! Can't get my MySQL service started!

open and lock privilege tables: Table 'mysql.host' doesn't exist So this sounds bad. I don't know if this has anything to do with it, but I followed the advice at this site: http://dev.mysql.com/doc/refman/5.1/en/windows-start-service.html and added the MyQL bin path (E:

GRANT USAGE (was: Re: login issue..pls help)

what is the purpose of 'Grant usage ' command http://search.mysql.com/search?site=refman-50&q=grant+usage&lr=lang_en Check the documentation, if you have more questions after that, get back to us. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Wo

Transations? (was: Re: login issue..pls help)

Hi, (better change the message subject if you change, well, the subject) user will create more number of tickets per day. so INSERT, UPDATE, SELECT will use highly. in document says' Myisam will not support transaction but it has self backup and restoration method. but in InnoDB good for tr

Re: login issue..pls help

This particular reference is little too vague to be of much use. MyISAM may outperform innodb in signle process situations but in contentious mixed read/write traffic (suchas a typical webapp), innodb is much faster for a variety of reasons. > > 13.1. Comparing Transaction and Nontransaction Engin

RE: login issue..pls help

-transactions.html best regards liuyann > From: sac.fai...@gmail.com > Date: Thu, 1 Oct 2009 15:06:54 +0530 > Subject: Re: login issue..pls help > To: aim.prab...@gmail.com > CC: mysql@lists.mysql.com > > user will create more number of tickets per day. so INSERT,

Re: login issue..pls help

; >>>>>>> >>>>>>> a. INFORMATION_SCHEMA is the information database ie metadata, the >>>>>>> place that stores information about all the other databases that the >>>>>>> MySQL >>>>>>> server

Re: login issue..pls help

, so there are no files >>>>>> associated with them. >>>>>> >>>>>> Each MySQL user has the right to access these tables, but can see only >>>>>> the rows in the tables that correspond to objects for which the user has >>>>

Re: login issue..pls help

ght to access these tables, but can see only >>>>> the rows in the tables that correspond to objects for which the user has >>>>> the >>>>> proper access privileges. >>>>> >>>>> http://dev.mysql.com/doc/refman/5.0/en/informa

Re: login issue..pls help

ser will perform only DML >>>> query or also want DDL operations. >>>> >>>> http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html >>>> >>>> >>>> On Thu, Oct 1, 2009 at 12:08 PM, F.A.I.Z.A.L wrote: &g

Re: login issue..pls help

r also want DDL operations. >>>> >>>> http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html >>>> >>>> >>>> On Thu, Oct 1, 2009 at 12:08 PM, F.A.I.Z.A.L wrote: >>>> >>>>> thanks kumar.. >>>>>

<    1   2   3   4   5   6   7   8   9   10   >