Re: 3.23.58 - 5.0.22 upgrade

2006-07-19 Thread Dan Trainor
Dan Buettner wrote: Dan T - Well, if all your data files are MyISAM, then I only see one potential problem, and that is the area of user permissions. I believe that things in that area have changed around enough that if you simply re-use those tables as-is (as-are?), you may have some

Re: 3.23.58 - 5.0.22 upgrade

2006-07-18 Thread Dan Trainor
Martin Jespersen wrote: Dan has a very good point, be mindfull of the changed password algorithm, that actually was a bit of a bother to me since i have tons of users defined in my grant tables. Dan Buettner wrote: Dan, I wouldn't bother with the intermediate steps (4.0, 4.1) . Waste of

Re: 3.23.58 - 5.0.22 upgrade

2006-07-18 Thread Martin Jespersen
Using dumps are almost always the way to go, upgrading the datafiles themselves is something you should avoid unless you are into heavy wizardry and/or pain. Dan Trainor wrote: Martin Jespersen wrote: Dan has a very good point, be mindfull of the changed password algorithm, that actually was

Re: 3.23.58 - 5.0.22 upgrade

2006-07-18 Thread Dan Buettner
Dan T - Well, if all your data files are MyISAM, then I only see one potential problem, and that is the area of user permissions. I believe that things in that area have changed around enough that if you simply re-use those tables as-is (as-are?), you may have some difficulties. All your other

Re: 3.23.58 - 5.0.22 upgrade

2006-07-18 Thread Daniel da Veiga
On 7/13/06, Dan Trainor [EMAIL PROTECTED] wrote: Martin Jespersen wrote: Dan has a very good point, be mindfull of the changed password algorithm, that actually was a bit of a bother to me since i have tons of users defined in my grant tables. Dan Buettner wrote: Dan, I wouldn't bother

3.23.58 - 5.0.22 upgrade

2006-07-13 Thread Dan Trainor
Hi - I know we've rolled this around the list a few times, but I was wondering if there's been any real development on the subject lately. I know half of you are saying Forget it... go with a newer version and get over it, and I'd really really like to, but i have a lot of data store under

Re: 3.23.58 - 5.0.22 upgrade

2006-07-13 Thread Martin Jespersen
I recently upgraded from 3.23.58 - 4.1.20 without any hickups. I simply dumped my databases with mysqldump on the 3.23.58 installation and imported them again from inside the mysql client by using the source command. Dan Trainor wrote: Hi - I know we've rolled this around the list a few

Re: 3.23.58 - 5.0.22 upgrade

2006-07-13 Thread Dan Buettner
Dan, I wouldn't bother with the intermediate steps (4.0, 4.1) . Waste of time (fine products, but you say you want to go to 5.0). I'd go direct to 5.0, using mysqldump'd data as Martin did. If you're all-MyISAM then it might also work to simply upgrade your binaries and keep your data files,

Re: 3.23.58 - 5.0.22 upgrade

2006-07-13 Thread Martin Jespersen
Dan has a very good point, be mindfull of the changed password algorithm, that actually was a bit of a bother to me since i have tons of users defined in my grant tables. Dan Buettner wrote: Dan, I wouldn't bother with the intermediate steps (4.0, 4.1) . Waste of time (fine products, but

Re: 3.23.58 - 5.0.22 upgrade

2006-07-13 Thread Dan Trainor
Martin Jespersen wrote: Dan has a very good point, be mindfull of the changed password algorithm, that actually was a bit of a bother to me since i have tons of users defined in my grant tables. Dan Buettner wrote: Dan, I wouldn't bother with the intermediate steps (4.0, 4.1) . Waste of