{"id":13759,"date":"2019-03-27T16:44:35","date_gmt":"2019-03-27T13:44:35","guid":{"rendered":"https:\/\/www.hyyat.com\/knowledgebase\/%d8%aa%d8%b1%d9%82%d9%8a%d8%a9-mysql-%d8%a5%d9%84%d9%89-mariadb-%d8%b9%d9%84%d9%89-%d8%ae%d8%a7%d8%af%d9%85-cpanel-whm\/"},"modified":"2022-05-26T12:48:48","modified_gmt":"2022-05-26T09:48:48","password":"","slug":"upgrading-mysql-to-mariadb-on-a-cpanel-whm-server","status":"publish","type":"docs","link":"https:\/\/www.hyyat.com\/en\/knowledgebase\/upgrading-mysql-to-mariadb-on-a-cpanel-whm-server\/","title":{"rendered":"Upgrading MySQL to MariaDB on a cPanel\/whm server"},"content":{"rendered":"

Upgrading MySQL to MariaDB on a cPanel\/whm server<\/span><\/h4>\n

\u00a0\u0645\u0627 \u0647\u064a MySQL \u061f<\/strong><\/span><\/p>\n

MySQL<\/a><\/strong> (sometimes pronounced MySQL) is a relational database management system based on SQL.It is named after the daughter of its original programmer, Michael Widenius, whose name is My. MySQL is an open source product that publishes its source code under the GNU General Public License as well as some proprietary agreements. It was owned and sponsored by the Swedish for-profit MySQL AB, but is now owned by Sun Microsystems (which is currently a subsidiary of Oracle).<\/p>\n

Important: Take a full backup of your database and a copy of var\/lib\/mysql\/ before taking a backup.<\/strong><\/span><\/p>\n

Make sure to stop mysql before taking a backup of var\/lib\/mysql\/<\/strong><\/span><\/p>\n

We highly recommend upgrading it to MariaDB 10.2 MariaDB 10.1 or MariaDB 10.0 MariaDB 10.2 is the latest version so here we are upgrading MySQL to MariaDB on the cPanel server.<\/span><\/span><\/p>\n

If you already have a database on the server take a copy of var\/lib\/mysql\/ you can use this using below commands.<\/span><\/span><\/p>\n

cp -rvf \/var\/lib\/mysql \/var\/lib\/mysql_backup\r\n<\/strong><\/pre>\n
and<\/p>\n
mysqldump --all-databases > all-databases.sql<\/strong><\/pre>\n
\n
Upgrading MySQL to MariaDB on a cPanel\/whm server<\/span><\/h3>\n
1- We log in to the server control panel as in the previous lessons<\/span><\/h4>\n
2- We refer to “SQL Services”<\/span><\/span><\/h4>\n
<\/div>\n
\"\"<\/a><\/div>\n
<\/div>\n
3- Then to “MySQL\/MariaDB Upgrade”<\/span><\/h4>\n
<\/div>\n
\"\"<\/a><\/div>\n
4- We choose “MariaDB 10.3” which is the latest recommended version<\/span><\/h4>\n
<\/div>\n
\"\u062a\u0631\u0642\u064a\u0629<\/a><\/div>\n
5- Wait for the “Upgrade Warnings” page to finish downloading.<\/span><\/span><\/h4>\n
\"\u062a\u0631\u0642\u064a\u0629<\/a><\/p>\n
\u2460 Read and acknowledge each warning message by enabling each check box.
\n<\/span><\/span><\/p>\n
\u2461 Click the “Continue<\/strong>” button.<\/span><\/p>\n
6- Wait for the “Upgrade Type” page to finish downloading.<\/span><\/span><\/span><\/h4>\n<\/div>\n
\u2460Select “Unattended Upgrade<\/strong>” for a seamless upgrade experience.<\/p>\n
\u2461Click the “Continue<\/strong>” button.<\/span><\/span><\/p>\n
7- Wait for the upgrade process to complete.<\/span><\/span><\/span><\/h4>\n
Greetings from the Hyyat Host<\/a> team<\/span><\/h4>\n","protected":false},"excerpt":{"rendered":"
Upgrading MySQL to MariaDB on a cPanel\/whm server \u00a0\u0645\u0627 \u0647\u064a MySQL \u061f MySQL (sometimes pronounced MySQL) is a relational database management system based on SQL.It is named after the daughter of its original programmer, Michael Widenius, whose name is My. MySQL is an open source product that publishes its source code under the GNU General […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_eb_attr":"","inline_featured_image":false,"wprm-recipe-roundup-name":"","wprm-recipe-roundup-description":"","footnotes":""},"doc_category":[2734],"doc_tag":[2792],"class_list":["post-13759","docs","type-docs","status-publish","hentry","doc_category-whm-cpanel-control-panels","doc_tag-mariadb-en"],"year_month":"2026-05","word_count":290,"total_views":"5345","reactions":{"happy":"1","normal":"0","sad":"0"},"author_info":{"name":"ahmed fathy","author_nicename":"ahmed-fathy","author_url":"https:\/\/www.hyyat.com\/en\/author\/ahmed-fathy\/"},"doc_category_info":[{"term_name":"whm\/cpanel control panels","term_url":"https:\/\/www.hyyat.com\/en\/kb\/whm-cpanel-control-panels\/"}],"doc_tag_info":[{"term_name":"MariaDB","term_url":"https:\/\/www.hyyat.com\/en\/docs-tag\/mariadb-en\/"}],"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/docs\/13759","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/comments?post=13759"}],"version-history":[{"count":0,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/docs\/13759\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/media?parent=13759"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/doc_category?post=13759"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/doc_tag?post=13759"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\"\u062a\u0631\u0642\u064a\u0629<\/a><\/p>\n