导入旧的mysql数据文件夹 [英] Importing old mysql data folder

查看:222
本文介绍了导入旧的mysql数据文件夹的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

重新安装后,所有旧数据仍显示在MySQL / data文件夹中,但实际上并未加载到数据库中。

After a reinstall, all of the old data still shows inside the MySQL/data folder, but is not actually loaded into the database.

有没有办法有MySQL扫描它的数据文件夹和/或重新导入它以前安装的旧文件夹吗?

Is there any way to have MySQL scan it's data folder and / or reimport the old folders it has from its previous install?

[有些数据在上次备份/导出后被更改 - 部分是我的错 - 所以我宁愿它识别文件夹而不是重新导入SQL文件。]

[Some data was changed after the last backup / export - partially my fault - so I would rather it recognize the folders rather than reimporting the SQL files.]

推荐答案

如果数据在正确的文件夹中,它将在MySQL中可见,或者在服务器启动时会出现错误。检查 / var / log / messages 和您的MySQL错误日志(在配置中定义)。

If the data is in the correct folder, it will be visible in MySQL, or you will get errors when the server starts. Check /var/log/messages and your MySQL error log (as defined in your config).

如果你没有任何错误,也看不到数据, my.cnf 中的数据路径可能指向不同的文件夹。

If you don't get any errors and can't see the data, it's likely that the data path in my.cnf is pointing to a different folder.

这篇关于导入旧的mysql数据文件夹的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆