原文连接:http://www.zhanggang.net/y2010/38170.html
大概需要4个步骤,其中第1步通过service mysql stop停止数据库,第4步通过service mysql start启动数据库。
第2步移动数据文件,与原文不一样,我是为了在ramdisk测试,所以要保留原来的数据,所以不用mv命令,直接用
cp -arf /var/lib/mysal /mnt/tmpfs
这样子不仅复制了原有的数据,并且权限也全部拷贝过来了,连chown,chmod都给省事了。
本来以为这样就没事了,启动mysql报错,查看日志输出:
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
130628 9:51:11 [Note] Plugin 'FEDERATED' is disabled.
^G/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
130628 9:51:11 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
刚才mv过去的权限都是对的,不存在还有什么权限的问题,到网上搜索大部分都是redhat系列的系统,其中的SElinux对ubuntu不适用,还差点真用chcon来修改所谓的安全之类的权限了
其实,在my.cnf中注释部分说明的很清楚(但是在我的Mysql里面就没有看到- -!)
# * IMPORTANT
# If you make changes to these settings and your system uses apparmor, you may
# also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
按照说明进行 第3步,注释掉原来的路径,增加新的路径,2行都要修改
vi /etc/apparmor.d/usr.sbin.mysqld
# /var/lib/mysql/ r,
# /var/lib/mysql/** rwk,
/tmp/tmpfs/mysql/ r,
/tmp/tmpfs/mysql/** rwk,
更新参数
/etc/init.d/apparmor reload
第4步:
重启Mysql
附上自动切换脚本一个,路径自己修改:
#!/bin/bash
MYSQLCONFIG=/etc/mysql/my.cnf
APPARMOR=/etc/apparmor.d/usr.sbin.mysqld
ORIPATH=/var/lib/mysql
TARPATH=/mnt/tmpfs/mysql
if [ $# -ne 1 ];then
echo "$0 [ harddisk | ramdisk ]"
exit 1
elif [ $1 != "harddisk" -o $1 != "ramdisk" ];then
option=$1
else
echo "unknown options"
echo "$0 [ harddisk | ramdisk ]"
exit 1
fi
change2harddist() {
sudo sed -i -e "s@^datadir\(.*\)@datadir=$ORIPATH@g" $MYSQLCONFIG
sudo sed -i -e "s@$TARPATH@$ORIPATH@g" $APPARMOR
sudo /etc/init.d/apparmor reload
}
change2ramdisk() {
if [ ! -e "/mnt/tmpfs/mysql" ];then
sudo -arfv /var/lib/mysql /mnt/tmpfs/mysql
fi
sudo sed -i -e "s@^datadir\(.*\)@datadir=$TARPATH@g" $MYSQLCONFIG
sudo sed -i -e "s@$ORIPATH@$TARPATH@g" $APPARMOR
sudo /etc/init.d/apparmor reload
}
mysql_control() {
control=$1
sudo service mysql $control
if [ $control = "start" -a $? -ne 0 ];then
exit 1
fi
}
mysql_control stop
if [ $option = "harddisk" ];then
change2harddist
elif [ $option = "ramdisk" ];then
change2ramdisk
fi
mysql_control start