XAMPP merupakan aplikasi terkenal yang mengintegrasikan server web Apache dengan server Database MySQL. Kendala yang menyebalkan saat menggunakannya adalah XAMPP control panel tidak bisa menghidupkan MySQL.
XAMPP is a popular application that integrates the Apache web server with the MySQL database server. An annoying issue encountered while using it is that the XAMPP control panel is unable to start MySQL.
Jika kita mengalami hal tersebut, langkah pamungkas adalah instal ulang XAMPP. Tentu saja tidak ada masalah jika MySQL masih kosong atau baru sedikit, jika sudah banyak tentu saja merepotkan. Postingan ini sedikit berbagi pengalaman bagaimana menyelesaikan hal tersebut ketika problem terjadi.
If you encounter such an issue, the final step would be to reinstall XAMPP. Of course, this is not a problem if your MySQL database is empty or contains only a few entries, but it can be quite troublesome if there is a large amount of data. This post shares a little experience on how to resolve such a situation when the problem occurs.
1. Backup
Sebagai langkah awal backup database kita, bernama ‘data’, yang berlokasi di xampp/mysql. Simpan di lokasi baru, misalnya old_data.
As an initial step, let’s backup our database named ‘data’, which is located in xampp/mysql. Save it to a new location, for example, ‘old_data’.
2. Restore
Buka folder ‘backup’ di xampp/mysql lalu copy seluruh isi ke folder ‘data’. Hal ini bermaksud membuat mysql seperti baru kembali. Pastikan XAMPP control panel bisa menjalankan MySQL.
Open the ‘backup’ folder in xampp/mysql and then copy all its contents to the ‘data’ folder. This is intended to make MySQL start fresh. Make sure the XAMPP control panel can run MySQL.
Kemudian di folder ‘old_data’ pindahkan folder berisi database yang akan dijalankan (jika semua ingin diaktifkan, berarti seluruh folder-folder databasenya). Copy ke folder data.
Next, in the ‘old_data’ folder, move the folder containing the database that needs to be run (if you want to activate all of them, it means moving all the database folders). Copy them to the ‘data’ folder.
3. Run
Di sini jika kita buka PhpMyAdmin tampak database kita berhasil dibuka. Tetapi terkadang ada kendala karena tidak bisa diakses. Oleh karena itu timpa saja file ‘ibdata1’ yang berlokasi di xampp/mysql/old_data ke folder xampp/mysql/data. Oiya, pastikan confirm untuk replace ketika muncul jendela konfirmasi. Restart kembali MySQL kita lewat XAMPP Control Panel, kemudian cek kembali, dan pastikan database bisa dibuka di PhpMyAdmin. Sekian, semoga bermanfaat.
Here, if we open PhpMyAdmin, it appears that our database has been successfully accessed. However, sometimes there may be issues with accessing it. Therefore, simply overwrite the ‘ibdata1’ file located in xampp/mysql/old_data with the one in the xampp/mysql/data folder. Oh, and make sure to confirm the replacement when prompted. Restart MySQL through the XAMPP Control Panel, then check again and ensure that the database can be opened in PhpMyAdmin. That’s all, hope it’s helpful.
Rahmadya Trias Handayanto 