Funny Steps Ketika mysql / mariadb error

Linux
mario -
2:45 pm

ketika mysql / mariadb error sbb :
socket: ‘/run/mysqld/mysqld.sock’ port: 3306 mariadb.org binary distribution2022-01-17 11:12:54 0 [Note] InnoDB: Buffer pool(s) load completed at 220117 11:12:54mariadbd(my_print_stacktrace+0x32)[0x5634951ac442]

  1. Rename atau hapus ib_logfile* files di /NFS/MONITOR/lib/mysql/
  2. Log in di Container MySQL :

mysql -u root -p


lalu jalankan perintah :


SET GLOBAL innodb_fast_shutdown=0;

lalu exit :

quit

  1. Edit file my.cnf di folder : /NFS/MONITOR/etc/mysql lalu hilangkan tanda (#) pada innodb_force_recovery=4
    lalu exit dgn ctrl+x dan y
  2. Reload kembali container-nya
No Tag

Comments are closed