mysql重裝后數(shù)據(jù)恢復

jas0n_liu 2013-02-25

展開全文

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 忽略報錯

創(chuàng)建mysql目錄

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

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

安裝mysql數(shù)據(jù)庫系統(tǒng)表

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

/home/mysql/data --user=mysql

3、拷貝緣數(shù)據(jù)文件到/home/mysql/data/目錄下
     cp -r *   /home/mysql/data/
     chown mysql:mysql /home/mysql/data/ -R
4、啟動數(shù)據(jù)庫
     /usr/bin/mysqld_safe &