Update MySQL questions

Marcosi

Marcosi

Verified User
Joined
Apr 14, 2012
Messages
40
Location
Cyprus / Sweden
How can I see what version of MySQL, custom build I'm using now? And then where do I find the latest stable update? Finally how do I o the update via SSH on my Ubuntu 10.04.4 LTS.

I have been told to make the updates manually as some releases might ask to rebuild tables etc.

Many thanks!
 
Hi, run this:

Code: 
cd /usr/local/directadmin/custombuild
./build update
./build versions

This will download all avaible packages updates and show you the current version and the newest avaible version on custombuild.

Once you know what you can update (ex. mysql) run ./build mysql (keep in mind that mysql upgrade require a php reinstall, so after that you should run ./build php n).

Regards
 
Thanks,
My MySQL don't even show up there. I fond out that the guy who installed the OS with DA did not use package installer for MySQL. The reason I can not understand. I guess I will need to reinstall MySQL from a package. That's like the whole point running i.e. Ubuntu OS?
 
By the way, running the

cd /usr/local/directadmin/custombuild
./build update
./build versions
Click to expand...

I got:

DirectAdmin 1.40.3 to 1.41.1 update is available.

Latest version of Apache: 2.2.22
Installed version of Apache: 2.2.22

Latest version of PCRE: 8.20
Installed version of PCRE: 8.20

Latest version of curl: 7.27.0
Installed version of curl: 7.25.0

cURL 7.25.0 to 7.27.0 update is available.

Latest version of FreeType: 2.4.10
Installed version of FreeType: 2.4.9

FreeType 2.4.9 to 2.4.10 update is available.

Latest version of AWstats: 6.95
Installed version of AWstats: 6.95

Latest version of dovecot: 2.1.9
Installed version of dovecot: 2.0.16

Dovecot 2.0.16 to 2.1.9 update is available.

Latest version of PHP (CLI): 5.2.17
Installed version of PHP (CLI): 5.2.17

Latest version of RoundCube webmail: 0.8.1
Installed version of RoundCube webmail: 0.7.1

RoundCube webmail 0.7.1 to 0.8.1 update is available.

Latest version of phpMyAdmin: 3.5.2.2-all-languages
Installed version of phpMyAdmin: 3.4.9-all-languages

phpMyAdmin 3.4.9-all-languages to 3.5.2.2-all-languages update is available.

Latest version of SquirrelMail: 1.4.22
Installed version of SquirrelMail: 1.4.22
Click to expand...

Can I use any command to update all of them in one go, or do I have to do them one by one? Any need for rebuilding PHP after those updates?
 
Ok. Trying to learn here :) so I have to ask Why you suggest one by one? And is there any of the above installations that requires i.e. PHP rebuild?
 
Just MySQL require PHP rebuild.

I use to do one-by-one to be sure everything is done correctly. Never used the all-in-one way, it should work im sure, but, i use to work this way :)

Regards
 
Reinstall? Use custombuild, would be more than enough.

Also, if needed, im avaible for this kind of work aswell.

Regards
 
Well custombuild is what i meant. It's just that the server is running three e-shops, so I can't afford experimenting, risking downtime. How much would a custombuild cost me?
 
Well there is not much risk unless an error come.

Custombuild for mysql use rpm packages so i doubt you should have problem.

Regarding the cost for a system update i can send you a pm with a quote if you want.

Regards
 
You must log in or register to reply here.
Back
Top