|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
Are there any Gotcha's to be aware of when migrating a back up from a mysql 4 to a mysql 5
History : I have been running Mysql 4.1 (I think) and due to a cock up on my part my server is being re-installed. Ive asked them if Mysql 5 can be installed, but are there any factors i need to be aware of or may catch me out?
Or should it be fine?
Thanks in advance Mark.
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
When we went from Plesk 8.01 to 8.1.1 (and from MySQL 4 - 5) we lost all the auto_increment fields in every database. I had to go back and manually re-do them. It was probably just a fluke, but was very time consuming none-the-less :smash:
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
Hummmm << -- (That's not spam i am thinking)I guess your very experienced with Mysql and the correction wasnt out of your scope. But for me who breaks things and then shouts "HELP" Would i be able to fix a simular issue? btw - i'm on Direct Admin. (Cheap cp panel )
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
Importing from 4 to 5 i see no problem with this, especially as an import (vs a direct upgrade like allen's issue).
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
As a new install no issue. If it was an upgrade then yes a couple things "could" bite you like passwords etc..
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
yeh, the password format changed in 4.1; it's more secure now... the only real change that was too big
|
|
|
|
Joined: Jul 2006
Posts: 116 Likes: 4
Member
|
Member
Joined: Jul 2006
Posts: 116 Likes: 4 |
When we went from Plesk 8.01 to 8.1.1 (and from MySQL 4 - 5) we lost all the auto_increment fields in every database. I had to go back and manually re-do them. It was probably just a fluke, but was very time consuming none-the-less :smash: Interesting. This usual happens after you downgrade from MySQL 5 back to 4 using mysqldump. I never had any issue upgrading directly from MySQL 4 to 5, but I am using Debian
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
I never had any issue upgrading directly from MySQL 4 to 5 ditto lol
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
It went ok, no real problems only my inexperience at the command prompt, and a half installed server, but i'm up and running again Just got a Gizmo stuck in there at the mo. But i'm about to fleece him out of there lol...
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Aug 2006
Posts: 1,358
Veteran
|
Veteran
Joined: Aug 2006
Posts: 1,358 |
My current install was a backup from MySQL 4.x at server A. That backup was imported on a MySQL 5.x at server B, and has worked without a problem. I don't see why you would have any problem with the change to MySQL 5.x.
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
I do! His webhost b0ggering the permissions and chmods on the data in the MySQL directory lol... Most files belonged to root, and some where chmodded 700... Took me like 15 minutes to notice and bit to repair lol... The beginning of the night :falls over:
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
no probs upgrading here and i've done it on 5 boards now.
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
When we went from Plesk 8.01 to 8.1.1 (and from MySQL 4 - 5) we lost all the auto_increment fields in every database. I had to go back and manually re-do them. It was probably just a fluke, but was very time consuming none-the-less :smash: Interesting. This usual happens after you downgrade from MySQL 5 back to 4 using mysqldump. I never had any issue upgrading directly from MySQL 4 to 5, but I am using Debian My host did the deed, so I'm not sure exactly what steps they took, I *do* know it took me days to fix the fallout
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
You know, i don't think they used the CentOS yum repo to upgrade yours allen; I think they simply removed MySQL then re-installed it; as tha'ts the "clean" route to upgrade
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
It's an FC server
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
FC and CentOS are still RH builds, I don't care what anyone says ... Besides, FC still uses yum; i set everything up for that ...
|
|
|
|
Joined: Jun 2006
Posts: 1,344
veteran
|
veteran
Joined: Jun 2006
Posts: 1,344 |
|
|
|
Test
by Phun - 05/28/2024 7:31 PM
|
|
|
|
|
|