> 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. 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 > > > > > >-- > >MySQL General Mailing List > >For list archives: http://lists.mysql.com/mysql > >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > 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]
