HOW TO FIX A TABLE USING MYSQLCHECK
- MySQL in XAMPP stopped starting with corruption within the db table in the database: mysql
- https://www.a2hosting.com/kb/developer-corner/mysql/repairing-mysql-databases-and-tables
CHECK FOR ERRORS
mysqlcheck -u root -p mysql
- Runs a check on the database, mysql.
- Prompts for password since not included.
With password in command
mysqlcheck -u root -p%password% mysql
Substitute %password%
FIX A TABLE WITH ERRORS
mysqlcheck -r database table
mysqlcheck -u root -p -r mysql db
mysqldump –user root –password –all-databases > all-databases.sql
mysqldump –user root –password –all-databases > all-databases.sql
mysqldump -u root -p –all-databases > all-databases.sql
HOW TO REPAIR MYSQL FROM CRASHING
https://community.apachefriends.org/f/viewtopic.php?t=80326&p=277006
To do this please open the XAMPP Shell by clicking the Shell button in your XAMPP Control Panel and execute the following command:
Code: Select all
mysqld –console –skip-grant-tables –skip-external-locking
Leave this black command line window open and click on the Shell button in the Control Panel again to open a second command line window and execute this command:
Code: Select all
mysqlcheck -r –databases mysql –use-frm
After that you Can close both command line Windows and try to start mysql again normally from your XAMPP control panel
Recent Comments