Results 1 to 19 of 19
  1. #1
    Join Date
    May 2009
    Location
    India
    Posts
    54

    Arrow How to update mysql from 5.0 to 5.1

    Hey,

    how to upgrade mysql from 5.0 to 5.1 in ubuntu?

  2. #2
    Join Date
    Sep 2007
    Posts
    368

  3. #3
    Join Date
    May 2009
    Location
    India
    Posts
    54
    i took the backup using mysqldump now how can i update it to the newer version?

  4. #4
    Join Date
    Sep 2007
    Posts
    368

  5. #5
    Here is the MySQL documentation on upgrade from version 5.0

  6. #6
    Join Date
    Aug 2009
    Location
    Bangalore
    Posts
    59
    does any control panel installed there ?

  7. #7
    Join Date
    May 2009
    Location
    India
    Posts
    54

    Talking

    no just a simple dedicated server

  8. #8
    Join Date
    Sep 2007
    Posts
    368

  9. #9
    Join Date
    May 2009
    Location
    India
    Posts
    54
    it's not done yet, I really don't know how to do it

  10. #10
    You can use apt-get update then install 5.1 by using
    #apt-get install mysql-server-5.1
    Support Facility | 24/7 web hosting technical support services
    Technical support | Server management | Data migration

    Technical Articles

  11. #11
    Join Date
    Aug 2009
    Location
    Bangalore
    Posts
    59
    If there is no control panel installed in the server, then it should be a bit tough task to function mysql though we can install it easily.
    Sometimes there might be compatibility issues with apace or php.

    Why dont you contact any support companies. contact them, they will install/upgrade and do all kind of work which is required to function mysql.


    ---
    Thanks,
    Mike

  12. #12
    Join Date
    May 2009
    Location
    India
    Posts
    54
    @Mike
    I know how to setup mysql and php, but i don't know how to update it to recent release

    btw this my average load on my dedicated server in peak hours
    load average: 18.72, 19.59, 20.68
    @inspiron
    i dosen't work
    see here http://i38.tinypic.com/30nao8l.png

  13. #13
    Join Date
    Sep 2007
    Posts
    368

    *

    Quote Originally Posted by MixMasters View Post
    @Mike
    I know how to setup mysql and php, but i don't know how to update it to recent release

    btw this my average load on my dedicated server in peak hours


    i dosen't work
    see here http://i38.tinypic.com/30nao8l.png
    Please check this with care

    Edit file :



    #vi /etc/apt/sources.list


    add new line :



    deb http://ppa.launchpad.net/monty/ubuntu gutsy main universe restricted multiverse
    deb http://ppa.launchpad.net/smurf/ubuntu gutsy main universe restricted multiverse



    save and exit


    Update & Upgrade
    #apt-get update
    #apt-get upgrade


    Install MySQL 5.1
    #apt-get install mysql-server-5.1

  14. #14
    Join Date
    Jul 2009
    Posts
    70
    Hello,


    Make sure that you are in the server with root privileges.

    Before you proceed with the upgrade run the following command tp know the currently installed mysql packages,

    "dpkg -l | grep mysql" (this would list out the currently installesd mysql packages)

    Once you get the verion of the installed mysql package you can search in the search engines for compatibilty between the version that is already installed and the one that is availabe in the repository for upgrade.

    If you are afraid that upgrading your mysql would break some fuction in the server i recommend that (if possibel )you setup a copy of the server in a virtual environment or another physical server and try upgrading. Now you can check if all is functioning properly. If everything checks out fine you can upgrade in your main server.

    Instructions on how to upgrade;

    1, make sure that you have your repositories setup correctly

    You can find more info regarding this in the followig link,

    "https://help.ubuntu.com/community/Repositories/CommandLine"

    The only thing here you have to note is that you add the repository links in the "sources.list" according to the version of ubuntu installed in the server.
    If you open your current "/etc/apt/sources.list" it would have info regarding the version of the ubuntu. You can also run command "cat/etc/debian_version". You can then search repository for that version in the search engine like yahoo, google etc.

    2, Once you have the correct repository info you can run "sudo apt-get update" and you repositories may get updated with some authentication error(authentication key).

    To fix this please see following link,
    "https://help.ubuntu.com/community/Repositories/Ubuntu". Here go to the title that says "Authentication Tab" . Though this is for graphical interface setting of the repositories you can use the command

    "gpg --keyserver [name of keyserver] --recv-keys [keyhash]"

    and

    "gpg --export --armor [keyhash] | sudo apt-key add - "

    Example:
    "gpg --keyserver subkeys.pgp.net --recv-keys 1135D466"
    and
    "gpg --export --armor 1135D466 | sudo apt-key add -"

    Note here for "[name of keyserver]" is "subkeys.pgp.net"
    I think you can use the same but for "[keyhash]" you will have to add the correct key that appeared(the error show whic key its is that needs authentication) after running command "sudo apt-get update".

    3, After adding the correct gpg keys for the repositories that you have added run the update command again this time if all keys have been added correctly there would be no key error at the end .

    Now your repository is set correctly,

    4, Now run .

    "apt-cache search mysql"

    or

    "apt-cache search mysql-server mysql-client"

    This would list out the available package for installation or upgrade for mysql incliding the mysql server and client and also the mysql-php version.

    Example:

    "apt-cache search php5-mysql"


    5, To upgrade to available package ,

    "sudo apt-get install mysql-server mysql-client"

    If the available package in the repository is newer than that of the one installed in the server it would proceed with the upgradation.

    It is not that complicated hope you find it likewise too

    Cheers
    Last edited by manhalab; 09-19-2009 at 10:15 AM.

  15. #15
    Join Date
    Mar 2003
    Location
    California USA
    Posts
    13,294
    Quote Originally Posted by MixMasters View Post
    @Mike
    I know how to setup mysql and php, but i don't know how to update it to recent release

    btw this my average load on my dedicated server in peak hours


    @inspiron
    i dosen't work
    see here http://i38.tinypic.com/30nao8l.png
    Upgrading the mysql version is unlikely to fix that load issue. Have you optimized your my.cnf and ensured you are running the latest kernel?
    Steven Ciaburri | Industry's Best Server Management - Rack911.com
    Software Auditing - 400+ Vulnerabilities Found - Quote @ https://www.RACK911Labs.com
    Fully Managed Dedicated Servers (Las Vegas, New York City, & Amsterdam) (AS62710)
    FreeBSD & Linux Server Management, Security Auditing, Server Optimization, PCI Compliance

  16. #16
    Join Date
    May 2009
    Location
    India
    Posts
    54

    *

    @nomankhn
    mysql Ver 14.14 Distrib 5.1.22-rc, for pc-linux-gnu (i486) using EditLine wrapper
    finally i was able to update it to 5.1 thanks nomankhn
    and thanks to others too

    @Steven
    Yeah i know it's not a great solution, but still i can say it's a security measure

    yeah one more question may be irrelevant to topic but still how can i update php5 to php 5.2.10

  17. #17
    Join Date
    Sep 2007
    Posts
    368

    *

    Quote Originally Posted by MixMasters View Post
    @nomankhn

    finally i was able to update it to 5.1 thanks nomankhn
    and thanks to others too

    yeah one more question may be irrelevant to topic but still how can i update php5 to php 5.2.10

    Good to hear, i am sure your databases are fine and working good.

    regarding php updation, i think you will check.

    apt-get install php5-cli

    Its better you will update your complete operating system so it will automatically update all things rather than you are doing one by one software.

  18. #18
    Join Date
    May 2009
    Location
    India
    Posts
    54

    *

    that's a nice idea but again how to do that?

  19. #19
    Join Date
    Sep 2007
    Posts
    368

Similar Threads

  1. mysql 4.1.13 update 4.1.14
    By Eser in forum Hosting Security and Technology
    Replies: 3
    Last Post: 03-05-2006, 03:09 PM
  2. How can I update mysql
    By nawialkair in forum Hosting Security and Technology
    Replies: 3
    Last Post: 08-04-2005, 11:07 AM
  3. mysql update
    By xprimer in forum Programming Discussion
    Replies: 6
    Last Post: 04-16-2003, 05:43 AM
  4. mysql error & mysql.sock missing after cpanel update
    By sbhmike in forum Hosting Security and Technology
    Replies: 0
    Last Post: 04-03-2003, 11:10 PM
  5. PHP mySQL UPDATE
    By kneuf in forum Programming Discussion
    Replies: 10
    Last Post: 03-26-2003, 11:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •