{"id":238,"date":"2021-11-08T10:47:57","date_gmt":"2021-11-08T10:47:57","guid":{"rendered":"https:\/\/blog.hostinger.io\/id\/support\/2021\/11\/08\/5496540-bagaimana-cara-upgrade-downgrade-mysql-mariadb-di-vps-di-hostinger\/"},"modified":"2025-08-26T20:10:27","modified_gmt":"2025-08-26T20:10:27","slug":"5496540-bagaimana-cara-upgrade-downgrade-mysql-mariadb-di-vps-di-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/id\/support\/5496540-bagaimana-cara-upgrade-downgrade-mysql-mariadb-di-vps-di-hostinger\/","title":{"rendered":"Bagaimana Cara Upgrade\/Downgrade MySQL (MariaDB) di VPS di Hostinger?"},"content":{"rendered":"<p class=\"no-margin\">Jika versi MariaDB yang terinstall di server Anda sudah tidak didukung oleh CMS website, maka Anda harus upgrade atau downgrade paket MySQL MariaDB.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Di artikel ini, kami memberikan contoh downgrade dari MariaDB 10.5 ke MariaDB 10.4. Anda dapat mengubah versinya di command SSH.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Berikut ini adalah langkah-langkah downgrade MariaDB.<\/p><p class=\"no-margin\">\n<\/p><h1 id=\"h_d25fcb7222\">Langkah 1 &ndash; Backup database<\/h1><p class=\"no-margin\">Pertama, buat sambungan ke server <b>dengan SSH<\/b> dan cek CyberPanel dan MySQL root <b>password<\/b>. Caranya, jalankan:<\/p><p class=\"no-margin\">\n<\/p><pre><code>cat .db_password<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Kemudian <b>buat backup baru<\/b>:<\/p><p class=\"no-margin\">\n<\/p><pre><code>mysqldump -u root -p --all-databases &gt; databasedump.sql<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Gunakan password yang ada di file .db_password<\/p><p class=\"no-margin\">\n<\/p><h1 id=\"h_64d175c87d\">Langkah 2 &ndash; Ubah versi MariaDB<\/h1><p class=\"no-margin\">Jika sudah punya backup, maka Anda dapat <b>menghapus<\/b> versi MariaDB. Kemudian, tambahkan <b>repositori YUM MariaDB<\/b>: vim<\/p><p class=\"no-margin\">\n<\/p><pre><code>\/etc\/yum.repos.d\/MariaDB.repo<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Kemudian <b>update file<\/b> ke:<\/p><p class=\"no-margin\">\n<\/p><pre><code>[mariadb]<br>name = MariaDB<br>baseurl = http:\/\/yum.mariadb.org\/10.4\/centos7-amd64<br>gpgkey=https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB gpgcheck=1<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Selanjutnya, update <b>cache index yum<\/b>:<\/p><p class=\"no-margin\">\n<\/p><pre><code>yum makecache fast<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Install MariaDB versi terbaru:<\/p><p class=\"no-margin\">\n<\/p><pre><code>yum install MariaDB-server MariaDB-client<\/code><\/pre><p class=\"no-margin\">Jangan lupa untuk <b>mengaktfikan MariaDB<\/b>:<\/p><p class=\"no-margin\">\n<\/p><pre><code>systemctl start mariadb<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Setelah itu, mulai jalankan:<\/p><p class=\"no-margin\">\n<\/p><pre><code>systemctl start mariadb<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Dan <b>amankan MariaDB:<\/b><\/p><p class=\"no-margin\">\n<\/p><pre><code>mysql_secure_installation<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Gunakan password yang sama di file .db_password. MariaDB dengan versi terbaru kini sudah aktif di VPS Anda. Gunakan <code>mysql --v<\/code>: untuk mengeceknya<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/id\/support\/wp-content\/uploads\/sites\/57\/2021\/11\/bd33be32-db20-413e-93fa-dd1d9f31471f.jpg\" alt=\"image\"><\/div><p class=\"no-margin\">\n<\/p><h1 id=\"h_7dca996fe1\">Langkah 3 &ndash; Impor database<\/h1><p class=\"no-margin\">Terakhir, <b>impor<\/b> backup database:<\/p><p class=\"no-margin\">\n<\/p><pre><code>mysql -u root -p root &lt; databasedump.sql<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Dan <b>ulangi<\/b> (restart) MariaDB:<\/p><p class=\"no-margin\">\n<\/p><pre><code>systemctl restart mariadb<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Selesai! VPS kini sudah menggunakan MariaDB versi 10.4!<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\"><b>CATATAN:<\/b><\/p><ul>\n<li>\n<p class=\"no-margin\"><b><a href=\"https:\/\/mariadb.com\/kb\/en\/upgrading\/\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">Dokumentasi resmi tentang upgrade MariaDB<\/a><\/b><\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Upgrade dan downgrade paket MySQL MariaDB di CyberPanel VPS<\/p>\n","protected":false},"author":581,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"include_on_kodee":true,"footnotes":""},"categories":[175],"tags":[],"class_list":["post-238","post","type-post","status-publish","format-standard","hentry","category-cyberpanel-vps"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/5496540-how-to-change-the-mariadb-version-on-cyberpanel-vps\/","default":1},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/support\/5496540-como-actualizar-degradar-mysql-mariadb-en-vps-en-hostinger\/","default":0},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/support\/5496540-comment-mettre-a-niveau-modifier-mysql-mariadb-sur-un-vps-chez-hostinger\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/5496540-bagaimana-cara-upgrade-downgrade-mysql-mariadb-di-vps-di-hostinger\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/5496540-como-atualizar-ou-voltar-para-a-versao-anterior-do-mysql-mariadb-na-vps-hostinger\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/238","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/comments?post=238"}],"version-history":[{"count":1,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/238\/revisions"}],"predecessor-version":[{"id":2656,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/238\/revisions\/2656"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/media?parent=238"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/categories?post=238"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/tags?post=238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}