From owner-freebsd-questions@FreeBSD.ORG Sun Jul 29 05:48:12 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 7329D16A418 for ; Sun, 29 Jul 2007 05:48:12 +0000 (UTC) (envelope-from cyberleo@cyberleo.net) Received: from pizzabox.cyberleo.net (alpha.cyberleo.net [198.145.45.10]) by mx1.freebsd.org (Postfix) with ESMTP id 39AFE13C465 for ; Sun, 29 Jul 2007 05:48:12 +0000 (UTC) (envelope-from cyberleo@cyberleo.net) Received: (qmail 75626 invoked from network); 29 Jul 2007 05:48:11 -0000 Received: from adsl-75-3-94-126.dsl.chcgil.sbcglobal.net (HELO ?172.16.44.14?) (cyberleo@cyberleo.net@75.3.94.126) by alpha.cyberleo.net with ESMTPA; 29 Jul 2007 05:48:11 -0000 Message-ID: <46AC1489.5070201@cyberleo.net> Date: Sat, 28 Jul 2007 23:15:46 -0500 From: CyberLeo Kitsana User-Agent: Thunderbird 2.0.0.4 (X11/20070604) MIME-Version: 1.0 To: David Banning References: <20070729045906.GA81833@skytracker.ca> In-Reply-To: <20070729045906.GA81833@skytracker.ca> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 05:48:12 -0000 David Banning wrote: > 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? ISM files are from the old (depreciated, removed) ISAM table engine. This was superseded by the MyISAM table engine. As detailed in the upgrade documentation for MySQL 5, you must change the database engine prior to upgrading, as MySQL 5 no longer has support for the old ISAM engine. This can be accomplished by logging in as a user with ALTER privileges on the tables in question, and issuing an ALTER TABLE table_name TYPE MyISAM; or ALTER TABLE table_name TYPE InnoDB; before upgrading to MySQL 5. If you've already upgraded, you must find a copy of 4.x recent enough to understand the tables, and use that to convert or dump them. -- Fuzzy love, -CyberLeo Technical Administrator CyberLeo.Net Webhosting http://www.CyberLeo.Net Furry Peace! - http://wwww.fur.com/peace/