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 chime in who has ideas. :-) ~~Fish~~ On Mon, Oct 27, 2008 at 11:55 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > 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 & 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 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 the data >> > >> > So I restored the respective mysql database, named pbcs7, from a tar >> > backup (I now understand this is not the best way to backup mysql), but >> > the data remained elusive. >> > >> > The database program - PBCS which is an appointment system - resides in >> > /home/www/public_html and the respective mysql database (MySQL Vers >> > 4.1.20) is in /var/lib/mysql >> > >> > What am I missing please? >> > >> > Steps for restoration of the backup (permissions were found to be >> > preserved): >> > 1. the backed up 'pbcs7' database files were temporarily restored using >> > the tar -zxvf command to: >> > /var/lib/restore/var/lib/mysql/pbcs7/ >> > >> > 2. made copy of files in use (ie the files from which data was missing) >> > to...restore2 directory >> > cp -a /var/lib/mysql/pbcs7/* /var/lib/restore2/ >> > >> > 3. /sbin/service mysqld stop >> > >> > 4. restored pbcs7 database files to the working mysql directory >> > cp -a /var/lib/restore/var/lib/mysql/pbcs7/* /var/lib/mysql/pbcs7/ >> > >> > 5. /sbin/service mysqld start >> > >> > Any help would be great >> > >> > Michael >> > >> > >> > >> > -- >> > MySQL General Mailing List >> > For list archives: http://lists.mysql.com/mysql >> > To unsubscribe: >> > http://lists.mysql.com/[EMAIL PROTECTED] >> > >> > >> > > > > -- > Rob Wultsch > [EMAIL PROTECTED] > wultsch (aim) > >
