MySQL upgrade 4.1 to 5.1

Andreas

New member
Joined
Oct 14, 2010
Messages
7
Finally moving from 4.1.x to 5.1. I have some questions I would be grateful if someone could help me with.

First I upgrade to 5.0. With 5.0 I rebuild and repair my database according to "2.12.4, Rebuilding or Repairing Tables or Indexes”.

Then I upgrade from 5.0 to 5.1. With 5.1 I use the "mysql_upgrade" command.

Is the proper procedure?

Should the mysql_inst be set to 'yes' or 'no' in the custombuild conf?

Thanks in advance!
 
When running DirectAdmin it is better to use custombuild to upgrade MySQL. Here are some links:

How to upgrade mysql with custombuild: http://help.directadmin.com/item.php?id=240

Also please see the custombuild FAQ: http://directadmin.com/forum/showthread.php?t=29824

Also see the link at the bottom of this page if you want to do it manually without custombuild: http://help.directadmin.com/item.php?id=310

Thanks for your answer.

I was going to use the custombuild scripts. But I guess I still have to move 4.1 -> 5.0 -> 5.1 and do the operations I mentioned above?
 
I was going to use the custombuild scripts. But I guess I still have to move 4.1 -> 5.0 -> 5.1 and do the operations I mentioned above?

I don't know about upgrading from 4.1. But when I upgraded from 5.0 to 5.1, I was only using custombuild and nothing else.
 
Here is step by step of how I upgraded from 5.0 to 5.1:

Edit /usr/local/directadmin/custombuild/options.conf and change the line with mysql version to 5.1. Make sure you have all these three lines in options.conf:
Code:
mysql=5.1
mysql_inst=yes
mysql_backup=yes

Then navigate to custombuild:
Code:
cd /usr/local/directadmin/custombuild

Then do this (reference http://directadmin.com/forum/showpost.php?p=176255&postcount=8):
Code:
./build update

Then do this:
Code:
./build mysql

Then recompile php like this:
Code:
./build php n
 
Always backup the MySQL directory manually, also if you let custombuild backup
So you know 100% that you have a correct backup, the files can be found in /var/lib/mysql (RHEL based OS)
 
Thank you for your replies. But if anyone who upgraded from 4.1.x to 5.x can tell me their procedure I would be forever thankfull!
 
Why cant you just change the versions in options.conf and then ./build mysql d

Then make sure you have in my.cnf the old passwords option set.
 
Back
Top