Skip to content

Instantly share code, notes, and snippets.

@fduran

fduran/gist:1870522

Created February 20, 2012 18:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fduran/1870522 to your computer and use it in GitHub Desktop.
Save fduran/1870522 to your computer and use it in GitHub Desktop.
Download ZIP
Mysql status, check & repair
Raw
gistfile1.sh
# www.fduran.com
# mysql status summary
mysqladmin -u root -pthepasswd process status
# check database mydb
/etc/init.d/mysqld stop; cd /var/lib/mysql; myisamchk --silent --force mydb/*.MYI
# repair mydb
/etc/init.d/mysqld start; mysqlcheck -u root -pthepassed --auto-repair --check --optimize --databases mydb
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment