New in CWP Edge-LatestFree with every CWPpro licenceWebsites up to 300x faster

CWP now includes LSPHP, LSAPI-Cache and CWP Cage at no extra cost with all CWPpro licences. The LSAPI-Cache plugin is integrated into our WordPress and other script installers, and CWP Cage gives every user complete isolation. Available now in the CWP Edge-Latest version.

Get CWPpro ›

Wordpress/WooCommerce recommending SQL 5.6

Started by 6Sense, June 22, 2016, 04:11:36 PM

Previous topic - Next topic

6Sense

Hi All,

I just updated my WordPress site to WooCommerce 2.6.1 and it is now recommending an update to at least SQL 5.6 (currently 5.1). I run a standard CentOS/CWP set up with Nginx & Varnish & running PHP 5.6 on a small VPS.

Should I be thinking about upgrading to SQL 5.6? Does CWP work with SQL 5.6 and is there a trusted step by step guide?

I found this link in the forums which seems easy, maybe too easy I thought. https://blog.bullten.com/upgrading-mysql-to-5-5-in-centos-web-panel-cwp/ I need easy steps as my talents are in webdesign not server admin.

Any assistance is greatly appreciated.
6Sense - Web Design, Development & Web Hosting

Sandeep

Recommend you to install mariadb 10.1 which have all the functionality of mysql 5.6 and 5.7

6Sense

Thanks for the reply Sandeep. MariaDB is unfamiliar to me so I'm a little nervous about trying to integrate it into my server (I have 3 WordPress sites it would affect).

Is WebPanel looking to eventually upgrade SQL versions?

Cause if it's not even compatible with the current WordPress version it's officially obsolete.


6Sense - Web Design, Development & Web Hosting

Igor S.

Hi.

Wordpress works great with MariaDB and does not have any troubles.



You can ask me to solve any problem with your server for some money in pm  ;)






Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp

Installation Instructions
http://centos-webpanel.com/installation-instructions

Get Fast Support Here
http://centos-webpanel.com/support-services

6Sense

Thanks but migrating from MySQL with a working WordPress/WooCommerce shop to what is an unknown to me sounds risky and scary. I've never worked with MariaDB before and changing to it will bring a new learning curve & could mean huge headaches, lengthy downtime with lost revenue.

Do you think one day they will upgrade SQL?
6Sense - Web Design, Development & Web Hosting

Sandeep

No need to warry just backup all databases before upgrade

6Sense

Ok I think I'll pluck up the courage to change over to MaraDB. Do I just use the 3 commands I found in the following link http://forum.centos-webpanel.com/mysql/change-cwp-from-mysql-to-mariadb-10-1/

Once I perform the above do I just import the databases I saved earlier using PHP Admin?
6Sense - Web Design, Development & Web Hosting

Sandeep

Quote from: 6Sense on July 08, 2016, 03:46:53 PM
Ok I think I'll pluck up the courage to change over to MaraDB. Do I just use the 3 commands I found in the following link http://forum.centos-webpanel.com/mysql/change-cwp-from-mysql-to-mariadb-10-1/

Once I perform the above do I just import the databases I saved earlier using PHP Admin?
https://downloads.mariadb.org/mariadb/repositories/
follow the instruction to add repo
then yum update