[Cialug] Mysql upgrades

[Tony Bibbs]

I've done some preliminary tests upgrading from 4.0.22 to 5.x.  I simply 
did a mysqldump (offline which is important if you use innodb) and 
reimported it and it seemed to work just fine on a fairly large database 
(180M dump file).  Haven't had a chance to really check out all the 
nook-and-crannies but it seems to have works so far.

--Tony

Nathan C. Smith wrote:
> I've already exported the databases just in case.
> 
> One of the guides mentions exporting the databases, and then importing them
> into the Mysql 5 system.
> 
> If somebody has upgraded please chime in.
> 
> -Nate
> 
> -----Original Message-----
> From: David Champion [mailto:dave at visionary.com] 
> Sent: Monday, December 05, 2005 11:42 AM
> To: Central Iowa Linux Users Group
> Subject: Re: [Cialug] Mysql upgrades
> 
> 
> Nathan C. Smith wrote:
> 
>>I have some odds and ends in mysql tables- version 4.01 I think.  Has 
>>anybody 'upgraded' to 5, and are there any gotchas?  Looking for any 
>>first-hand experience.
> 
> 
> I was reading up on this. The official MySQL upgrade guide (somewhere on 
> MySQL.com I think) says you should go to 4.1, then 5.
> 
> If it were me, I'd back it up, then try going from 4.0 to 5, and test it 
> to see if it worked.
> 
> I have seen a system that updated from 3.x to 5.0, I don't know the 
> exact steps they took, but the DB performance improved.
> 
> -dc
> 
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug