Kamis, 22 Juni 2023

SOLUSI MYSQL XAMPP GAGAL START

 https://stackoverflow.com/questions/18022809/how-to-solve-error-mysql-shutdown-unexpectedly

  1. Stop MySQL.
  2. Go to the C:/xampp/mysql directory and copy the data folder and keep it somewhere else (probably in another drive) as a backup.
  3. Go to your original data folder (C:/xampp/mysql) and sort the files by 'Type.'
  4. Select the files that have the type INFO File and delete them (screenshot below).
  5. Start MySQL. It should work now.



JIKA SBB


Pada CLI JALANKAN

C:\xampp\mysql\bin>mysql_upgrade.exe

Sehingga Normal lagi:




jika tabelnya pada kosong....
Kembalikan file ibdata1 ke aslinya




Mencari Tanggal Terakhir Suatu Bulan

  $a_date = "$tahun-$bulan-01"; $lastdate= date('t',strtotime($a_date));//Y-m-t <?php require_once"koneksivar.php&...