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:41] – juckinsmysql_time_date_tips [2024/11/27 21:38] (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
Line 29: Line 33:
   mysqlcheck -r DATABASE_NAME -u root -p   mysqlcheck -r DATABASE_NAME -u root -p
      
-  +__Checking Size of Indexes__ 
 + 
 +https://releem.com/blog/check-mysql-database-table-size 
mysql_time_date_tips.1661546518.txt.gz · Last modified: 2022/08/26 16:41 by juckins