Differences

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

--- mysql_time_date_tips [2020/05/16 15:57] – juckins
+++ mysql_time_date_tips [2022/08/26 17:35] (current) – juckins
@@ Line 21: / Line 21: @@
 [[https://tableplus.com/blog/2018/11/error-1040-too-many-connection-increase-max-connections-mysql.html|Max connections]]
+__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
+__Repair a database__
+  mysqlcheck -r DATABASE_NAME -u root -p