The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

update mysql

Discussion in 'Database Discussions' started by arjanvr, Nov 12, 2014.

  1. arjanvr

    arjanvr Well-Known Member

    Joined:
    Dec 13, 2013
    Messages:
    58
    Likes Received:
    1
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    I want to update MySQL from 4.2.9 to 4.2.11. I also need to upgrade PHP. Should i upgrade PHP first or does that not matter? Also, how can i make a full backup of MySQL from my VPS?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    MySQL version 4 has been end-of-life for quite sometime. Ideally, you should be using at least MySQL version 5.5. What version of cPanel is installed on your system?

    Thank you.
     
  3. arjanvr

    arjanvr Well-Known Member

    Joined:
    Dec 13, 2013
    Messages:
    58
    Likes Received:
    1
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    Maybe i do have version 5 I am unsure.. I copy pasted it below. I can only find this cPanel Pro 1.0 (RC1) and above cpanel 11 below the cpanel optimised 3 logo.. not sure where else to find it.

    Databankserver

    Server: Localhost via UNIX socket
    Servertype: MySQL
    Serverversie: 5.5.40-cll - MySQL Community Server (GPL)
    Protocolversie: 10
    Gebruiker: gezondheid@localhost
    Karakterset van server: UTF-8 Unicode (utf8)

    Webserver

    cpsrvd 11.46.0.14
    Client-versie van databank: libmysql - 5.1.73
    PHP-uitbreiding: mysqli Documentatie

    phpMyAdmin

    Versie-informatie: 4.2.9, meest recente versie: 4.2.11
     
  4. danrussell

    danrussell Well-Known Member

    Joined:
    Nov 5, 2014
    Messages:
    60
    Likes Received:
    3
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    Hello,

    You are using MySQL version 5.5.40. If you still need to upgrade the MySQL version to latest i.e. 5.6, then you should update the MySQL first then go for PHP upgrade.

    Further, you can use below steps to backup all the databases at once:

    # mkdir /backup/db_backup
    # mysql -e "show databases" > /home/mysql_db.txt

    Open /home/mysql_db.txt and remove the first the lines ( Database, performance_schema & information_schema )
    then issue the following

    # for i in `cat /home/mysql_db.txt`; do mysqldump $i > /backup/db_backup/$i.sql; done

    Thanks.
     
Loading...

Share This Page