Christopher Juckins

SysAdmin Tips, Tricks and other Software Tools

User Tools

Site Tools


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 [2010/10/18 12:19] juckinsmysql_time_date_tips [2022/08/26 17:35] (current) juckins
Line 1: Line 1:
 +==== MySQL Tips ====
 +
 +__SELECT and JOIN__
 +
 +[[https://www.mysqltutorial.org/mysql-inner-join.aspx]]
 +
 +__Time/date__
 +
 [[http://www.richardlord.net/blog/dates-in-php-and-mysql]] [[http://www.richardlord.net/blog/dates-in-php-and-mysql]]
  
Line 9: Line 17:
 [[http://www.bennadel.com/blog/172-Ask-Ben-Selecting-Parts-of-a-Date-Time-Stamp-In-SQL.htm]] [[http://www.bennadel.com/blog/172-Ask-Ben-Selecting-Parts-of-a-Date-Time-Stamp-In-SQL.htm]]
  
 +__Performance__
 +
 +[[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
 +  
 +  
mysql_time_date_tips.1287418797.txt.gz · Last modified: 2010/10/18 12:19 by juckins