如何从 mysql 5.1 迁移到 5.5?
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/4500881/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to migrate from mysql 5.1 to 5.5?
提问by Arman
I am just migrating from 5.1 to 5.5. I copy my data from mysql5.1 data forlder to mysql5.5/data.
我只是从 5.1 迁移到 5.5。我将我的数据从 mysql5.1 数据文件夹复制到 mysql5.5/data。
I just wondered if I can overwrite the file ibdata1in mysql 5.5 data directory?
我只是想知道是否可以覆盖mysql 5.5数据目录中的文件ibdata1?
Thanks Arman.
谢谢阿尔曼。
EDIT
编辑
Yes I can copy 5.1 to 5.5 and then I need to run mysql_upgrade
是的,我可以将 5.1 复制到 5.5,然后我需要运行mysql_upgrade
回答by Brad Christie
Have you visited the MySQL 5.5 FAQ: Migrationportion of the reference manual? They have a specific page dedicated to moving from 5.1 to 5.5with step-by-step guide (including making a backup).
您是否访问过MySQL 5.5 常见问题解答:参考手册的迁移部分?他们有一个专门的页面,专门介绍从 5.1 到 5.5的逐步指南(包括制作备份)。