Differences

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

Link to this comparison view

tech:mysql:check [2014/12/04 06:45] (current)
Line 1: Line 1:
 +====== MySQL Check ======
 +Cron this!
 +<code bash>
 +#!/bin/sh
 +#
 +# MySQL Check
 +#
 +NOW=$(date +"​%Y-%m-%d-%H-%M-%S"​)
 +#
 +MYSQLPASS="​yourootpassword"​
 +#
 +#MySQL Check
 +/​usr/​bin/​mysqlcheck -ACes -uroot --password=${MYSQLPASS}
 +#
 +exit 0
 +</​code>​
 +  * Include option ''​o''​ to optimize the tables as well
 +  * Ignore ''​Note''​
  

QR Code
QR Code tech:mysql:check (generated for current page)