Select Page

MySQL / MariaDB Commands for mysqldump and mysqlcheck

Sep 2, 2022 | Back-End, Software

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

How to Automate MySQL Database Backups in Windows

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