Differences
This shows you the differences between two versions of the page.
|
tech:mysql:check [2014/12/04 06:45] |
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'' | ||
