From owner-freebsd-questions@FreeBSD.ORG Sun Jul 29 05:36:31 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 154D016A417 for ; Sun, 29 Jul 2007 05:36:31 +0000 (UTC) (envelope-from david+dated+1186117148.bb0221@skytracker.ca) Received: from 3s1.com (3s1.com [209.161.205.12]) by mx1.freebsd.org (Postfix) with ESMTP id B0AAA13C457 for ; Sun, 29 Jul 2007 05:36:30 +0000 (UTC) (envelope-from david+dated+1186117148.bb0221@skytracker.ca) Received: from 3s1.com (localhost [127.0.0.1]) by 3s1.com (8.13.8/8.13.8) with ESMTP id l6T4x93h081920 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Sun, 29 Jul 2007 00:59:09 -0400 (EDT) (envelope-from david+dated+1186117148.bb0221@skytracker.ca) Received: (from david@localhost) by 3s1.com (8.13.8/8.14.1/Submit) id l6T4x8gv081919 for questions@freebsd.org; Sun, 29 Jul 2007 00:59:08 -0400 (EDT) (envelope-from david+dated+1186117148.bb0221@skytracker.ca) X-Authentication-Warning: 3s1.com: david set sender to david+dated+1186117148.bb0221@skytracker.ca using -f Received: by 3s1.com (tmda-sendmail, from uid 1000); Sun, 29 Jul 2007 00:59:08 -0400 Date: Sun, 29 Jul 2007 00:59:07 -0400 To: questions@freebsd.org Message-ID: <20070729045906.GA81833@skytracker.ca> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.2.2i X-Delivery-Agent: TMDA/1.1.11 (Ladyburn) From: David Banning X-Virus-Scanned: ClamAV 0.88.5/3803/Sat Jul 28 19:12:27 2007 on 3s1.com X-Virus-Status: Clean X-Spam-Status: No, score=-1.4 required=5.0 tests=ALL_TRUSTED autolearn=failed version=3.1.6 X-Spam-Checker-Version: SpamAssassin 3.1.6 (2006-10-03) on 3s1.com Cc: Subject: 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:36:31 -0000 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?