{"id":336,"date":"2021-11-08T11:03:04","date_gmt":"2021-11-08T11:03:04","guid":{"rendered":"https:\/\/blog.hostinger.io\/id\/support\/2021\/11\/08\/4635603-bagaimana-cara-memulihkan-database-mysql-dari-data-file-mysql-di-vps-di-hostinger\/"},"modified":"2021-11-08T11:03:04","modified_gmt":"2021-11-08T11:03:04","slug":"4635603-bagaimana-cara-memulihkan-database-mysql-dari-data-file-mysql-di-vps-di-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/id\/support\/4635603-bagaimana-cara-memulihkan-database-mysql-dari-data-file-mysql-di-vps-di-hostinger\/","title":{"rendered":"Bagaimana Cara Memulihkan Database MySQL dari Data File MySQL di VPS di Hostinger?"},"content":{"rendered":"<p class=\"no-margin\">Masalah:<\/p><p class=\"no-margin\">Anda tidak dapat mengaktifkan VPS dan ingin memulihkan database MySQL dari <b>Mode Recovery VPS <\/b>atau<b> file backup VPS.<\/b><\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Ikuti langkah-langkah di bawah ini untuk memulihkan database MySQL:<\/p><p class=\"no-margin\">\n<\/p><h1 id=\"h_d6e4143967\">Langkah 1 &ndash; Install dan hentikan server MySQL<\/h1><p class=\"no-margin\">Pertama, buat sambungan ke VPS dengan SSH. Setelah itu, install server MySQL dengan menjalankan perintah ini:<\/p><p class=\"no-margin\">\n<\/p><pre><code>yum install mysql-server<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Walaupun Anda bisa menggunakan versi terbaru, kami sarankan Anda menginstall <b>versi MySQL yang sama. <\/b>Setelah proses instalasi selesai, hentikan server MySQL dan tambahkan data folder dengan perintah berikut:<\/p><p class=\"no-margin\">\n<\/p><pre><code>service mysql stop<\/code><\/pre><p class=\"no-margin\">\n<\/p><h1 id=\"h_755e47e7c6\">Langkah 2 &ndash; Salin data<\/h1><p class=\"no-margin\">Salin data MySQL lama dan pindahkan ke lokasi data file server MySQL yang baru.<\/p><p class=\"no-margin\">\n<\/p><pre><code>cp -rf \/mnt\/var\/lib\/mysql\/* \/var\/lib\/mysql<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Kemudian, pastikan pastikan pemilik file adalah pengguna MySQL. Untuk <b>ubah kepemilikan file<\/b>, gunakan perintah ini:<\/p><p class=\"no-margin\">\n<\/p><pre><code>chown -R mysql:mysql \/var\/lib\/mysql<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Lalu <b>jalankan kembali server MySQL <\/b>dengan perintah ini:<\/p><p class=\"no-margin\">\n<\/p><pre><code>service mysql start<\/code><\/pre><p class=\"no-margin\">\n<\/p><h1 id=\"h_fa4d99171a\">Langkah 3 &ndash; Periksa &amp; ekspor<\/h1><p class=\"no-margin\">Terakhir,<b> periksa dan perbaiki semua tabel database <\/b>dengan perintah ini:<\/p><p class=\"no-margin\">\n<\/p><pre><code>mysqlcheck -rA<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\"><b>CATATAN:<\/b><\/p><ul>\n<li>\n<p class=\"no-margin\">Tergantung versi MySQL yang digunakan, Anda akan perlu menjalankan MYSQLCHECK untuk memastikan tidak ada data yang rusak\/corrupt.<\/p>\n<\/li>\n<\/ul><p class=\"no-margin\">Setelah itu, <b>ekspor database:<\/b><\/p><p class=\"no-margin\">\n<\/p><pre><code>mysqldump --all-databases &gt; all_databases.sql<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Selesai! Database Anda berhasil dipulihkan!<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\"><b>NOTE<\/b>:<\/p><ul>\n<li>\n<p class=\"no-margin\"><b><a href=\"https:\/\/support.hostinger.co.id\/id\/articles\/5098522-cara-backup-atau-pulihkan-server-vps\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">Cara backup atau pulihkan server VPS<\/a><\/b><\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Memulihkan database MySQL dari data file \/var\/lib\/mysql MySQL<\/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":[174],"tags":[],"class_list":["post-336","post","type-post","status-publish","format-standard","hentry","category-mengelola-vps"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/4635603-how-to-recover-mysql-databases-from-mysql-data-files-in-vps-at-hostinger\/","default":1},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/support\/4635603-como-recuperar-bases-de-datos-mysql-de-archivos-de-datos-mysql-en-vps\/","default":0},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/support\/4635603-comment-recuperer-des-bases-de-donnees-mysql-a-partir-de-fichiers-de-donnees-mysql-dans-un-vps-chez-hostinger\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/4635603-bagaimana-cara-memulihkan-database-mysql-dari-data-file-mysql-di-vps-di-hostinger\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/4635603-como-recuperar-bancos-de-dados-mysql-de-arquivos-de-dados-mysql-em-vps-hostinger\/","default":0},{"locale":"uk-UA","link":"https:\/\/www.hostinger.com\/ua\/support\/4635603-----mysql---\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/336","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=336"}],"version-history":[{"count":0,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/336\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/media?parent=336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/categories?post=336"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/tags?post=336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}