From owner-freebsd-questions@FreeBSD.ORG Sat Mar 26 20:56:33 2011 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 52E0D106566B for ; Sat, 26 Mar 2011 20:56:33 +0000 (UTC) (envelope-from freebsd.user@seibercom.net) Received: from mail-gx0-f182.google.com (mail-gx0-f182.google.com [209.85.161.182]) by mx1.freebsd.org (Postfix) with ESMTP id 076098FC18 for ; Sat, 26 Mar 2011 20:56:32 +0000 (UTC) Received: by gxk28 with SMTP id 28so930256gxk.13 for ; Sat, 26 Mar 2011 13:56:32 -0700 (PDT) Received: by 10.150.13.7 with SMTP id 7mr2325757ybm.201.1301172992190; Sat, 26 Mar 2011 13:56:32 -0700 (PDT) Received: from scorpio.seibercom.net (twdp-174-109-142-001.nc.res.rr.com [174.109.142.1]) by mx.google.com with ESMTPS id q29sm2128315yba.2.2011.03.26.13.56.31 (version=TLSv1/SSLv3 cipher=OTHER); Sat, 26 Mar 2011 13:56:31 -0700 (PDT) Received: from scorpio (zeus [192.168.1.1]) (using TLSv1 with cipher DHE-RSA-AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: FreeBSD.user@scorpio.seibercom.net) by scorpio.seibercom.net (Postfix) with ESMTPSA id A25C9E5480D for ; Sat, 26 Mar 2011 16:56:29 -0400 (EDT) Date: Sat, 26 Mar 2011 16:56:29 -0400 From: Jerry To: FreeBSD Message-ID: <20110326165629.738ce74e@scorpio> In-Reply-To: <4D8E3CA4.8040808@shopzeus.com> References: <20110326174100.1617.qmail@joyce.lan> <4D8E3CA4.8040808@shopzeus.com> Organization: seibercom.net X-Mailer: Claws Mail 3.7.8 (GTK+ 2.22.1; amd64-portbld-freebsd8.2) Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAAJFBMVEUeH4oAAI3//v8LDHmw s8gyNZ/b3ej7+vn+/v////+PjIc8Plaj/TnQAAACNElEQVQ4jaXUvW/aQBQAcFtKGZLFT+YY 3D1SR9SKoRMncE3IggU4kicGi1JYOgQwyYrgnLlSzhsoNkTuVJEp+ef6ztiAoV3aJ+QPfufn s987S/5fQvoXYPjztmfc514Ks+5JfGUCfrzt4+VabF+jwEV4DGEXN8N4p16sPLxHX07/V3qX yfF5D2H6K4V8j9NkyAphvkjBembD5PDFk3zeTzP1jcksyaV9w+d4ELmUoOp8N2p8uQVyhTAT uawnKNH2mie5lJp48mscUcbJUvg0mR6APwAoye9AMyWozY4gAh0vcxa5FJ4TKCuODESWtfkB 8AEQSupUXNIYH8FSC2w8X3eMBNbbVJpJ7MgECO5yJ9DUEWCYkzNAlsRsgwLQ1GkWqELbkDOh 1bUzoHagYkNh9MXlK/MQoA42gTxz2bhPM2DJedm8MZx6cNfJgEZJ5cmwPp5FZ/Ye8O2qTrFV dgOrHkZRBoheJiGrRquwAhnQ6GeTePPerWVmQelAQ5lwNqtvQd2lcooAV74/zR1BIRS19fy5 ru+B/8ReW9pYKMPjt609zDaitHHTGOO+Zu7gHvsKE7XbeE1QVuJXomIFuZgUJdXQdhpqEELc /e8RLjfi+cQ01yMdWot8UcCVxEWHEkcUrsDGuhaIEoM9kfgAR6jxHcmEV7tNURAl8KTHN9iF McKGFHGO62O62UMpbmlVuogQ7ndL8zXCiLeBy3xpfrqaXS/+AHDG4o8AvhuPeezD/3xL/hy/ Adjlg2odglF2AAAAAElFTkSuQmCC Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Subject: Re: MySQL 3 needed but how? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: FreeBSD List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 26 Mar 2011 20:56:33 -0000 On Sat, 26 Mar 2011 20:21:08 +0100 Laszlo Nagy articulated: > On 2011-03-26 18:41, John Levine wrote: > > In article<4D8E1E4A.5000609@shopzeus.com> you write: > >> Hi, > >> > >> I have an old backup from a MySQL data directory. It was created > >> with MySQL version 3. If I install MySQL 4 then I get this message > >> telling that the table was created with a different MySQL version. > > You should be able to restore the individual database directories > > under mysql 4 and use ALTER TABLE to upgrade the file formats. > > You'll lose the user access stuff, but that's usually easy enough to > > reconstruct. > > > > In MySQL, each database is self-describing. That is, for database > > foo, the files in the foo/ directory are both the description of > > the tables and the data in them. > > > > http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-3-23.html > Okay, I tried to follow the instruction. So instead of installing > 4.1, I have installed 4.0. After replacing /var/db/mysql with my > archived directory: > > gw# /usr/local/etc/rc.d/mysql-server start > Starting mysql. > gw# /usr/local/etc/rc.d/mysql-server status > mysql is not running. > gw# > > > There is nothing in /var/log/messages. > > It was working with 4.1 server, but I just uninstalled that (because > the upgrading faq told me to install 4.0 instead.) Do you have the following in your "/etc/rc.conf" file: mysql_enable="YES" -- Jerry ✌ FreeBSD.user@seibercom.net Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the Reply-To header. __________________________________________________________________ Microbiology Lab: Staph Only!