From owner-freebsd-questions@FreeBSD.ORG Sun Jul 29 06:31:19 2007 Return-Path: Delivered-To: questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 26BEC16A418 for ; Sun, 29 Jul 2007 06:31:19 +0000 (UTC) (envelope-from dan@dan.emsphone.com) Received: from dan.emsphone.com (dan.emsphone.com [199.67.51.101]) by mx1.freebsd.org (Postfix) with ESMTP id 366B013C457 for ; Sun, 29 Jul 2007 06:31:17 +0000 (UTC) (envelope-from dan@dan.emsphone.com) Received: (from dan@localhost) by dan.emsphone.com (8.14.1/8.14.1) id l6T65IBx018087; Sun, 29 Jul 2007 01:05:18 -0500 (CDT) (envelope-from dan) Date: Sun, 29 Jul 2007 01:05:18 -0500 From: Dan Nelson To: David Banning Message-ID: <20070729060518.GA5725@dan.emsphone.com> References: <20070729045906.GA81833@skytracker.ca> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20070729045906.GA81833@skytracker.ca> X-OS: FreeBSD 7.0-CURRENT User-Agent: Mutt/1.5.16 (2007-06-09) Cc: questions@freebsd.org Subject: Re: problems with mysql database X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 29 Jul 2007 06:31:19 -0000 In the last episode (Jul 29), David Banning said: > I have recently converted from mysql 4.1 to 5.0 and some of my tables > are not recogized. Using the mysql_upgrade utility is not effective > as -it- does not recognize certain tables. > > On closer examination I see that the tables that are -not- recognize > have the following extensions; > > -rw-rw---- 1 mysql mysql 147787 Jul 23 02:44 company.ISD > -rw-rw---- 1 mysql mysql 13312 Jul 23 02:44 company.ISM > -rw-rw---- 1 mysql mysql 9064 Dec 8 2006 company.frm > > while the tables that have no problem have different extensions; > > -rw-rw---- 1 mysql mysql 3592 Jul 28 23:49 Employees.MYD > -rw-rw---- 1 mysql mysql 1024 Jul 28 23:49 Employees.MYI > -rw-rw---- 1 mysql mysql 9174 Dec 19 2006 Employees.frm > > Any idea whats going on here? You may have missed: http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html#id2794303 Incompatible change: Support for the ISAM storage engine has been removed in MySQL 5.0. If you have any ISAM tables, you should convert them before upgrading. For example, to convert an ISAM table to use the MyISAM storage engine, use this statement: ALTER TABLE tbl_name ENGINE = MyISAM; Use a similar statement for every ISAM table in each of your databases. ISAM tables were actually deprecated back in 3.23 and the manual predicted that support would be gone in 5.0. You'll need to temporarily drop down to 4.1, or copy those table files to a 4.1 server, convert to MyISAM, then copy them back. If you have made a mysqldump of your tables recently, you can also delete your existing database files and reload from the dump; 5.0 will ignore the ENGINE=ISAM option and create MyISAM tables. -- Dan Nelson dnelson@allantgroup.com