SHOW ENGINES says no support for ISAM. So that explains it. Which other server would you suggest I try installing? Do you mean I should try installing an earlier version of mysql? Where should I find one?
I'm worried about messing up my new installation by installing an old one. Is there an alternative? Thanks, Bagus (ugh) > -----Original Message----- > From: Paul DuBois [mailto:[EMAIL PROTECTED] > Sent: Saturday, January 22, 2005 7:46 PM > To: Bagus; mysql@lists.mysql.com > Subject: RE: isam to myisam > > > At 19:41 -0600 1/22/05, Bagus wrote: > > > According to the help message, the --type option is for > specifying the > >> table type that you want to convert the tables *to*. So it should be > >> --type=MyISAM, I think. > >> > >> You could also execute this statement for each table that you want to > >> convert: > >> > >> ALTER TABLE tbl_name ENGINE=MyISAM; > >> > > > >Both of these led to a similar error: Can't find editors.MYI. > > Hmm. Perhaps your server doesn't have support for ISAM compiled in. > What does the output of SHOW ENGINES indicate about the ISAM storage > engine? If it says NO, it won't be able to read ISAM tables at all. > You'll need to find another server that does support ISAM. > > > > > > >So I guess I need to change the subject to: > >HELP! I can't access my old tables! > > > >or > > > >Didn't find any fields in table. > > > >or something. > > > >Any ideas? Anyone: I have one database that I'd like to recover. > >The database had 5 tables in it. > >Each one had three files associated with it, ie editors.ISD, > editors.ISM and > >editors.frm. I have access to the files, but not the old server > that ran the > >old version of mysql. > >I copied them into /usr/local/mysql/data/BagusDatabase > >I made sure the permissions were the same as my test directory that was > >created on install... ie mysql owns everything. > >When entering the command mysql> use BagusDatabase; > >mysql reports that: > >Didn't find any fields in table 'editors' > > > >How can I get my old tables into my new database? > > > >Thanks, > > > >Bagus > > > >> -----Original Message----- > >> From: Paul DuBois [mailto:[EMAIL PROTECTED] > >> Sent: Thursday, January 20, 2005 10:58 PM > >> To: Bagus; mysql@lists.mysql.com > >> Subject: Re: isam to myisam > >> > >> > >> At 22:46 -0600 1/20/05, Bagus wrote: > >> >Hi there, > >> > > >> >I'm running Freebsd 5.3 and just installed > >> >mysql-standard-4.1.9-unknown-freebsd4.7-i386. I'm able to > run mysqld and > >> >mysql, etc. I used to run Freebsd 2.2 and I think it was mysql > >> 3.21.33b... > >> >I'm not sure. My old system faded away rather abruptly and I > didn't get a > >> >chance to do database backups or anything. > >> > > >> >I have one database that I'd like to recover. The database had 5 > >> tables in > >> >it. Each one had three files associated with it, ie editors.ISD, > >> editors.ISM > >> >and editors.frm. I have access to the tables but can't load them > >> into my new > >> >mysql. I copied them into /usr/local/mysql/data/BagusDatabase > >> and made sure > >> >the permissions were the same as my test directory. > >> > > >> >I have been reading around and thought I came across the > answer with the > >> >mysql_convert_table_format script. I tried changing into my new > >> >BagusDatabase directory and running: > >> >mysql_convert_table_format --user='root' --password='mypassword' > >> --type='ISA > >> >M' BagusDatabase > >> > >> According to the help message, the --type option is for specifying the > >> table type that you want to convert the tables *to*. So it should be > >> --type=MyISAM, I think. > >> > >> You could also execute this statement for each table that you want to > >> convert: > >> > >> ALTER TABLE tbl_name ENGINE=MyISAM; > >> > >> > >> > > >> >The script then reports: > >> >Converting tables: > >> >converting editors > >> >Can't convert editors: Error Can't find file: 'editors.MYI' > (errno: 2) > >> > > >> >I bet this is old hat for some of you out there. Can someone > >> help me figure > >> >out how to recreate my database? > >> > > >> >Thanks, > >> > > > > >Bagus > > > -- > Paul DuBois, MySQL Documentation Team > Madison, Wisconsin, USA > MySQL AB, www.mysql.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]