Christopher Juckins

SysAdmin Tips, Tricks and other Software Tools

User Tools

Site Tools

Trace:
mysql_time_date_tips

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
mysql_time_date_tips [2022/08/26 16:38] – juckinsmysql_time_date_tips [2022/08/26 17:35] (current) – juckins
Line 22: Line 22:
  
 __Checking for errors in all tables/databases__ __Checking for errors in all tables/databases__
 +
 +  * In phpMyAdmin, select database and then check the table you want to investigate.  In the dropdown box "With Selected", choose the Check / Repair option, etc.
 +
 +Alternately:
  
   mysqlcheck -c -u root -p --all-databases   mysqlcheck -c -u root -p --all-databases
 +  
 +__Repair a database__
 +
 +  mysqlcheck -r DATABASE_NAME -u root -p
 +  
 +  
mysql_time_date_tips.txt · Last modified: 2022/08/26 17:35 by juckins