Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 27 Jul 2007 18:00:10 +0200
From:      Gabor Kovesdan <gabor@FreeBSD.org>
To:        David Banning <david+dated+1185975235.369212@skytracker.ca>
Cc:        questions@freebsd.org
Subject:   Re: updating mysql database
Message-ID:  <46AA168A.9080306@FreeBSD.org>
In-Reply-To: <20070727133354.GA4021@skytracker.ca>
References:  <20070727133354.GA4021@skytracker.ca>

next in thread | previous in thread | raw e-mail | index | archive | help
David Banning escribió:
> I installed mysql 5.1 on a new system and I want to run a 4.1 database. I notice that
> not all tables work. Is there a conversion to take the database from 4.1 to 5.1?
>   
I think you only have to run REPAIR TABLE or OPTIMIZE TABLE on the 
broken tables. IIRC, the indexing
changed between 4.X and 5.X versions.

Regards,

-- 
Gabor Kovesdan
FreeBSD Volunteer

EMAIL: gabor@FreeBSD.org .:|:. gabor@kovesdan.org
WEB:   http://people.FreeBSD.org/~gabor .:|:. http://kovesdan.org




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?46AA168A.9080306>