mysql重装后数据恢复

1、停止服务
/etc/init.d/mysql stop
2、重装mysql
wget http://www./redir/downloads/Percona-Server-5.5/Percona-Server-5.5.27-28.1/RPM/rhel6/i686/

yum install cmake bison ncurses-devel gcc-c++

#rpm -ivh --nodeps --force    Percona-Server-55-debuginfo-5.5.24-rel26.0.256.rhel6.x86_64.rpm   Percona-Server-server-55-5.5.24-rel26.0.256.rhel6.x86_64.rpm

  Percona-Server-client-55-5.5.24-rel26.0.256.rhel6.x86_64.rpm      Percona-Server-shared-55-5.5.24-rel26.0.256.rhel6.x86_64.rpm

    Percona-Server-devel-55-5.5.24-rel26.0.256.rhel6.x86_64.rpm        忽略报错

创建mysql目录

#mkdir -p /home/mysql/{data,logs}

#chown mysql:mysql /home/mysql/ -R

安装mysql数据库系统表 

#/usr/bin/mysql_install_db  --defaults-file=/etc/my.cnf  --basedir=/usr/  --datadir=

/home/mysql/data  --user=mysql

3、拷贝缘数据文件到/home/mysql/data/目录下
     cp  -r  *   /home/mysql/data/
     chown mysql:mysql /home/mysql/data/ -R
4、启动数据库
     /usr/bin/mysqld_safe &