update mysql

arjanvr

• November 12, 2014 13:21

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?

• 

  cPanelMichael

  • November 13, 2014 13:47

  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.

  0
• 

  arjanvr

  • November 14, 2014 14:08

  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

  0
• 

  danrussell

  • November 15, 2014 09:15

  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.

  0

Please sign in to leave a comment.