How to Fix MySQL Error “Stopping MySQL database server : mysqld failed!” on Debian Squeeze

This problem happens when you modify user table in mysql database. In Debian system, there is a user named debian-sys-maint. We can’t restart mysql daemon if the password is not correct. We have to update the password for that user. First, we check the password: Login to mysql shell as root Now use the following…

Read More

How to Repair Corrupted MySQL (MyISAM) Table

Platform: Windows (should work on Linux) Database name: activity Table name: mamain 1. Copy myisamchk.exe to database folder C:\xampp\mysql\bin>copy myisamchk.exe ..\data\activity 2. Run the executable C:\xampp\mysql\bin>cd ..\data\activity C:\xampp\mysql\data\activity>myisamchk -r mamain – recovering (with sort) MyISAM-table ‘mamain’ Data records: 81619 – Fixing index 1 Data records: 81618 3. Finish Note: Make sure you have turned off…

Read More