Cara Repair Table di Database MySQL yang Korup/Corrupt
Namanya Masalah di Server itu nggak ada selesainya, setelah sukses pindahan eh ternyata salah satu akses salah satu domain kok tiba2 dapat pesan kalau MySQL error. Dan lha dalah.. nggak tau kenapa benar2 error seperti ini
Unhandled Exception
Message:
SQLSTATE[HY000]: General error: 1194 Table 'images' is marked as crashed and should be repaired
SQL: SELECT * FROM `images` ORDER BY `created_at` DESC LIMIT 9
Bindings: array (
)
Location:
/var/www/cakep.com/laravel/database/connection.php on line 263
Stack Trace:
#0 /var/www/cakep.com/laravel/database/connection.php(183): Laravel\Database\Connection->execute('SELECT * FROM `...', Array)
#1 /var/www/cakep.com/laravel/database/query.php(709): Laravel\Database\Connection->query('SELECT * FROM `...', Array)
#2 /var/www/cakep.com/laravel/database/eloquent/query.php(90): Laravel\Database\Query->get(Array)
#3 /var/www/cakep.com/application/routes.php(20): Laravel\Database\Eloquent\Query->get()
#4 [internal function]: Laravel\Bundle::{closure}()
#5 /var/www/cakep.com/laravel/routing/route.php(163): call_user_func_array(Object(Closure), Array)
#6 /var/www/cakep.com/laravel/routing/route.php(124): Laravel\Routing\Route->response()
#7 /var/www/cakep.com/laravel/laravel.php(167): Laravel\Routing\Route->call()
#8 /var/www/cakep.com/public/index.php(34): require('/var/www/cakep...')
#9 {main}
Akhirnya saya coba sana sini kemari saya mencoba menemukan cara HOW TO FIX DATABASE MySQL CORRUPT lah dan nemu cara mudah dan nyamannya…
Jadi begini cara mudah yang kami lakukan. Kami melakukan ini dengan Metode akses MySQL Server langsung via SSH, kalau mau make phpMyAdmin sebenarnya jauh lebih mudah.
