导入旧的mysql数据文件夹 [英] Importing old mysql data folder
问题描述
重新安装后,所有旧数据仍显示在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屋!