Advertisement
fduran

Mysql status, check & repair

Sep 22nd, 2011
270
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.32 KB | None | 0 0
  1. # www.fduran.com
  2.  
  3. # mysql status summary
  4. mysqladmin -u root -pthepasswd process status
  5.  
  6. # check database mydb
  7. /etc/init.d/mysqld stop; cd /var/lib/mysql; myisamchk --silent --force mydb/*.MYI
  8.  
  9. # repair mydb
  10. /etc/init.d/mysqld start; mysqlcheck -u root -pthepassed --auto-repair --check --optimize --databases mydb
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement