Re: deleted user...lost access to appointment data

2008-10-27 Thread Fish Kungfu
I'm not really sure why that might have happened. I was going to suggest looking on the PCBS Forum for assistance too, but I see you've asked them as well. How did you actually delete the user, 'michael'... through MySQL or through a PCBS admin tool? I am not a guru btw, and encourage anyone to

Re: deleted user...lost access to appointment data

2008-10-27 Thread Rob Wultsch
I sooo hear that now. That is the funniest thing I have heard this month. On Mon, Oct 27, 2008 at 8:36 PM, Fish Kungfu <[EMAIL PROTECTED]> wrote: > For some reason when I started reading this, I heard Humphrey Bogart's > voice > speaking it like the beginning of one of his dark and rainy black &

Re: deleted user...lost access to appointment data

2008-10-27 Thread Fish Kungfu
For some reason when I started reading this, I heard Humphrey Bogart's voice speaking it like the beginning of one of his dark and rainy black & white detective movies. ;-) On Mon, Oct 27, 2008 at 10:25 PM, Dr Michael Daly <[EMAIL PROTECTED]>wrote: It all started when I deleted one of the user

Re: Getting more info from "show full processlist"

2008-10-27 Thread Jim Lyons
One way to do it (maybe the only way for selects) is to use the general log. The Id number, 30399, is the thread id. You can look up the thread id in the general log and see the entire command. But you have to have the general log running. If the command changes data (update, delete, insert) th

mysql on power6

2008-10-27 Thread Facundo Garat
Hi, anyone have any experience with mysql on power6 for web applications workload?. cheers

deleted user...lost access to appointment data

2008-10-27 Thread Dr Michael Daly
It all started when I deleted one of the users, 'michael', from within a database program --> lo and behold 'michael' disappeared from all groups along with the data. 'michael' was an admin user as was another admin user, but the data belonged to 'michael' I recreated this user but could not see t

Re: How could i check the following values in MySQL Server 5.0

2008-10-27 Thread Moon's Father
Setting is difficult but checking is simple. On Thu, Oct 9, 2008 at 9:26 PM, Amit Sharma <[EMAIL PROTECTED]> wrote: > Hi Sudhir, > #show table status command will give you most of what all is required. Have > a look at the results & post any further query if you have. > > Regards, > Amit Sharma >

Re: Deployment of Database in a DEB package.

2008-10-27 Thread Moon's Father
I'm sorry that if I can ask a question.What is DEB? On Fri, Oct 3, 2008 at 9:49 PM, US Data Export <[EMAIL PROTECTED]>wrote: > > > >-Original Message- > >From: Ellison, David [mailto:[EMAIL PROTECTED] > >Sent: Friday, October 03, 2008 2:35 AM > >To: mysql@lists.mysql.com > >Subject: RE: D

Re: Changing the location of my.ini and the order option files are read

2008-10-27 Thread Moon's Father
I advise that you should put your my.cnf in mysql installation location. On Mon, Oct 6, 2008 at 11:06 PM, Varuna Seneviratna < [EMAIL PROTECTED]> wrote: > Armin > I did what you said, now I understand what you say that there is no > sence in what I wanted to do.But I gave these commands as

Re: Getting more info from "show full processlist"

2008-10-27 Thread Moon's Father
I also want to know the answer to this question.If it's for me.I'll scan all the source code manually.But it's too complicated. On Tue, Oct 7, 2008 at 1:02 AM, Olaf Stein < [EMAIL PROTECTED]> wrote: > It specifies the query in the Info field. > In your case the connection is "sleeping", nothing i

Re: Any easier way to compare mysql schema of 50 databases?!

2008-10-27 Thread Moon's Father
Just use command line tools called fc on windows or diff on linux if you are patient and perfer trouble. On Tue, Oct 7, 2008 at 10:07 PM, Duzenbury, Rich <[EMAIL PROTECTED]>wrote: > > I just used mysqldiff for a project, and was successful. > > -Original Message- > From: Uma Bhat [mailto:

MySQL 5.1.29-rc has been released

2008-10-27 Thread Kent Boortz
Dear MySQL users, We are proud to present to you the MySQL Server 5.1.29-rc release, a new "release candidate" version of the popular open source database. Bear in mind that this is still a "candidate" release, and as with any other pre-production release, caution should be taken when installi

MySQL University session on October 30: Quick and Easy Testing With MySQL Sandbox

2008-10-27 Thread Stefan Hinz
The next MySQL University session will take place this Thursday, 30th October. Giuseppe Maxia will get you up to speed with using MySQL Sandbox for quick and easy testing of MySQL. This session will start at 15:00 Central European Time (14:00 UTC, 14:00 BST). MySQL University is an educational pr

RE: Finding gaps

2008-10-27 Thread US Data Export
Thanks for the suggestion. Unfortunately that doesn't fit my need, because I need to go back in time. From: Moon's Father [mailto:[EMAIL PROTECTED] Sent: Saturday, October 25, 2008 2:57 AM To: Jerry Schwartz Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: Finding gaps Create an e