mysql日常维护杂记

ubuntu apache2 phpmyadmin的关闭

$cd /etc/apache2/conf.d
$sudo rm link phpmyadmin.conf -> ../../phpmyadmin/apache.conf
$sudo service apache2 restart

数据库备份

mysqldump -u root -p --database dbName > dbName.sql

数据库表顺坏修复
需要先停掉mysql进程

$sudo service mysql stop
$sudo myisamchk -r /var/lib/mysql/dbName/*.MYI