Where are your .frm files, are you not including them in your directory listing or are they missing? If they're missing, that's most likely your problem right there.. :)
Atle - Flying Crocodile Inc, Unix Systems Administrator On Wed, 4 Jan 2006, Simon Faulkner wrote: > An old server died during the holidays. > > I had a database with 2 tables on it on an old version of MySQL > (circa Redhat 7?) > > I have the latest backup of the files but not a dump (kick himself) > > I put the files in the correct /var/lib/mysql/gallery and restarted > MySQL. It shows the gallery database but not the tables > > > I have tried ISAM check and it seems OK but MySQL won't open the tables. > > I have even tried the files in a fresh compiled MySQL rather than the > FC4 version in case that's a problem. > > Are my tables doomed? > > TIA > > Simon > PS they are at > http://titanic.co.uk/gallery/tblGallery.ISD > http://titanic.co.uk/gallery/tblGallery.ISM > http://titanic.co.uk/gallery/tblPicture.ISD > http://titanic.co.uk/gallery/tblPicture.ISM > > if anyone needs to see them... > > There's nothing private in them. > > > [EMAIL PROTECTED] gallery]# ls -l > total 1196 > -rwxrwxrwx 1 mysql mysql 6511 Jan 4 15:30 tblGallery.ISD > -rwxrwxrwx 1 mysql mysql 2048 Jan 4 15:30 tblGallery.ISM > -rwxrwxrwx 1 mysql mysql 1185360 Jan 4 15:30 tblPicture.ISD > -rwxrwxrwx 1 mysql mysql 18432 Jan 4 15:30 tblPicture.ISM > [EMAIL PROTECTED] gallery]# mysqlshow > +-----------+ > | Databases | > +-----------+ > | gallery | > | mysql | > | test | > +-----------+ > [EMAIL PROTECTED] gallery]# mysqlshow gallery > Database: gallery > +--------+ > | Tables | > +--------+ > +--------+ > [EMAIL PROTECTED] gallery]# isam > isamchk isamlog > [EMAIL PROTECTED] gallery]# isamchk tblGallery.ISD > isamchk: error: 'tblGallery.ISD' is not a ISAM-table > [EMAIL PROTECTED] gallery]# isamchk tblGallery.ISM > Checking ISAM file: tblGallery.ISM > Data records: 17 Deleted blocks: 0 > - check file-size > - check delete-chain > - check index reference > [EMAIL PROTECTED] gallery]# isamchk tblPicture.ISD > isamchk: error: 'tblPicture.ISD' is not a ISAM-table > [EMAIL PROTECTED] gallery]# isamchk tblPicture.ISM > Checking ISAM file: tblPicture.ISM > Data records: 2640 Deleted blocks: 0 > - check file-size > - check delete-chain > - check index reference > [EMAIL PROTECTED] gallery]# isamchk -r tblPicture.ISM > - recovering ISAM-table 'tblPicture.ISM' > Data records: 2640 > - Fixing index 1 > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
