From owner-freebsd-isp@FreeBSD.ORG Fri Aug 26 13:35:38 2005 Return-Path: X-Original-To: freebsd-isp@freebsd.org Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 97B4916A41F for ; Fri, 26 Aug 2005 13:35:38 +0000 (GMT) (envelope-from 000.fbsd@quip.cz) Received: from home.quip.cz (r3ar5.chello.upc.cz [213.220.235.5]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2E40843D48 for ; Fri, 26 Aug 2005 13:35:37 +0000 (GMT) (envelope-from 000.fbsd@quip.cz) Received: from [192.168.1.2] (qwork.quip.test [192.168.1.2]) by home.quip.cz (Postfix) with ESMTP id 7E98971B; Fri, 26 Aug 2005 15:35:35 +0200 (CEST) Message-ID: <430F1AAA.3040100@quip.cz> Date: Fri, 26 Aug 2005 15:35:38 +0200 From: Miroslav Lachman <000.fbsd@quip.cz> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.11) Gecko/20050728 X-Accept-Language: cs, cz, en, en-us MIME-Version: 1.0 To: ruben@bloemgarten.demon.nl References: <20050819184711.8A86C43D53@mx1.FreeBSD.org> In-Reply-To: <20050819184711.8A86C43D53@mx1.FreeBSD.org> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-isp@freebsd.org Subject: Re: migration from mysql 3.2.23 to 4.1.13 X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 26 Aug 2005 13:35:38 -0000 Don't forget to repair all tables /databases befor dump. I recommend you to convert ISAM tables to MyISAM before dump. (but do it on backup copy of data, not on original) Dump databases by newer mysqldump. If you are using non latin1 charset, maybe you will have some troubles after importing dump into 4.1. Do not blindly dump and reimport mysql users (table `user` from database `mysql`) because 4.1 has different structure and using different passwords. Manualy recreate all accounts instead. Ruben Bloemgarten wrote: > Hi Mario, > The dump was done on 3.23. I'll give 4.1 a try on that machine, sounds like > a nice hack though,using mysqldump 4.1 on a 3.23 database. Thanks for the > tip. > > Ruben > > -----Original Message----- > From: mario [mailto:mario@schmut.com] > Sent: August 19, 2005 8:37 PM > To: ruben@bloemgarten.demon.nl > Cc: james@jpri.com; freebsd-isp@freebsd.org > Subject: RE: migration from mysql 3.2.23 to 4.1.13 > > So, Ruben Bloemgarten wrote: > >>Hi James, >> >>That was the first thing I tried, unfortunately that does not work as >>the way 3.23 deals with ISAM is different to 4.1 and so it spits out >>errors when it runs into unrecognizable syntax. If you have managed to >>use mysqldump for a migration I would very much appreciate hearing about >>it as it would simplify things conisderably. > > > was this using mysldump 3.23 or 4.1? they produce different results and i > found one to work and the other not. i don't remember which did what but > just try the version you haven't yet. > > then there is also > http://dev.mysql.com/doc/mysql/en/upgrading-from-3-23.html > and then > http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html > > looking at the docs, it seems, you need to do a bit more than just a dump. > > hope this helps. i remember going from 4.0 to 4.1 was already fun. > > > mario;> > > > > >