RE: isam to myisam
Hello, Does anyone out there have a working version of MySQL that supports the ISAM and MyISAM engines and who might could convert my old database for me? I'd really appreciate it. Please reply off the list. Thanks, Bagus -Original Message- From: Bagus [mailto:[EMAIL PROTECTED] Sent: Saturday, January 22, 2005 10:48 PM To: mysql@lists.mysql.com Subject: RE: isam to myisam 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]
RE: isam to myisam
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]
RE: isam to myisam
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]
isam to myisam
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 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]
RE: isam to myisam
I did try --type='myisam' --type='isam' --type=myisam --type=isam --type='MYISAM' --type=MYISAM --type='ISAM' --type=ISAM All produced identical errors. Specifying the individual tables didn't change the error note. Any other ideas? Is this the right way to go about changing these ISD, ISM, and frm files to MYD, MYI and frm? Do I need to do this? Is there another way to get mysql to read the old ISD, ISM and frm files? 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]