更新后恢复 MySQL/var/lib/mysql [英] Recover MySQL /var/lib/mysql after update

问题描述

我在 Centos 6 服务器中从 Mysql 5.5 更新到 8.0，没有将数据库转储到 .sql 文件，我只是将/var/lib/mysql 目录复制到另一个位置.

I did an update from Mysql 5.5 to 8.0 in a Centos 6 server without dumping the databases to a .sql file, I just copied the /var/lib/mysql directory to another location.

现在，如果我尝试加载 mysqld 服务，它会崩溃.

Now if I try to load mysqld service it crashes.

天真我删除了/var/lib/mysql的所有内容并重新安装了该服务，现在它可以运行但现在我不知道如何手动将数据库文件导入目录(复制并粘贴文件夹不起作用)以检查数据库和/或修复它.

Being naive I deleted all the content of /var/lib/mysql and installed the service again, now it runs but now I do not know how to manually import the DB files to the directory (copy & paste of the folder does not work) in order to do a check of the DB and/or repair it.

推荐答案

rysnc 应该可能已经安装，但如果没有，你会:

rysnc should likely already be installed, but if it isn't you would:

sudo yum install rsync

然后

#make sure mysql isn't running
sudo service mysqld stop

#double check that there is no MySQL PID running
sudo ps aux | grep mysql

#move the new MySQL 8.0 data files out of the way
sudo mv /var/lib/mysql /var/lib/mysql.bak

#copy the original data files back to /var/lib/mysql
#note that the trailing / is required for both paths
sudo rsync -av /path/to/original/mysql/db/files/ /var/lib/mysql/

#change user and group ownership to mysql
sudo chown -R mysql:mysql /var/lib/mysql

#start MySQL
sudo service mysqld start

#run mysql_upgrade, replace {usernamehere} with the actual username
sudo mysql_upgrade -u {usernamehere} -p

更新:

您需要将二进制文件降级到 5.5.一旦 MySQL 再次运行，请备份每个数据库，然后按以下顺序升级:

You will need to downgrade the binaries to 5.5. Take a backup of each database once MySQL is running again and then upgrade in the following order:

• 5.6
• 5.7
• 8.0

您需要在每次升级后运行 mysql_upgrade.

You will need to run mysql_upgrade after each upgrade.

这篇关于更新后恢复 MySQL/var/lib/mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！