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] > >