Hold the phone - I've just realised that those tables 'missing' .ISM files are actually supposed to be MyISAM - (I have complete MYD and MYI files) - not ISAM (ISM, ISD) - how do I tell MySQL this is the case?
TIA (Again) /Phil On Sun, 02 Jun 2002 21:28:17 +0100 "Phillip Baker" <[EMAIL PROTECTED]> wrote: > Hi, > > In haste to change some server hardware I copied the /var/lib/mysql directory >directly assuming this would suffice in order to carry the data over. I'm pretty >certain I stopped mysqld, but regardless I now seem to be missing nearly all the >respective .ISM files for my databases. > > Now, I'm having babies as most of the databases now fail to function properly, and >the original state of the old server has been lost (argh!) - is there any possible >location where these ISM files or the data for them may be hiding? Why weren't they >in /var/lib/mysql like they should have been? > > TIA > > /Phil > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
