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

2008-10-28 Thread Fish Kungfu
Great. Glad to hear you sorted it out. On Tue, Oct 28, 2008 at 9:02 PM, Dr Michael Daly <[EMAIL PROTECTED]>wrote: > Hi > Thanks for your help everyone > > I was overwriting the files into the existing database dir. Maybe there > was some additional files there that were causing a problem. I jus

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

2008-10-28 Thread Dr Michael Daly
Hi Thanks for your help everyone I was overwriting the files into the existing database dir. Maybe there was some additional files there that were causing a problem. I just extracted the backed up files into a new database dir within the /var/lib/mysql dir, pointed my database program towards the

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: Deleted user

2001-04-23 Thread Samuel
enzel" <[EMAIL PROTECTED]> To: "jessica" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, April 23, 2001 4:24 PM Subject: Re: Deleted user > >From the very fine manual: > > http://www.mysql.com/documentation/mysql/bycha

Re: Deleted user

2001-04-23 Thread Ken Menzel
>From the very fine manual: http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.htm l#Resetting_permissions - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "jessica" <[EMAIL PROTECTED

Re: Deleted user

2001-04-09 Thread Gerald Clark
THe manual recommends restarting the server with --skip-grants. Fix your user table, and flush privileges to reload the grant tables. Bob Dushok wrote: > > I've made a stupid error. While logged in as root I was deleting > records from the user table. Someone was talking to me while I was > en

Re: Deleted user

2001-04-09 Thread René Tegel
stop mysql service, restore the backup from the mysql.user table (or: copy from a other mysql with known users, or: copy from the installation files), restart mysql. - Original Message - From: "Bob Dushok" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 09, 2001 1:09 PM Su

RE: Deleted user

2001-04-09 Thread Mate Visky
I've made a stupid error. While logged in as root I was deleting records from the user table. Someone was talking to me while I was entering a command and I didn't realize what I entered until it was too late. I entered: delete from user where user='root'; I immediately used an insert statemen