1,安装rhel4及mysql
2,导入移动硬盘的数据
3,导出mysql数据,用于导入到oracle
4,构建oracle10g,导入第3步的数据
5,查询导入oracle的表数,记录数,约束,索引是否一致
附上目前要迁移的mysql及redhat相关信息
===============================================================
Last login: Fri Jun 18 17:59:52 2010 from 124.65.46.86
[root@localhost ~]# mysql -V
mysql Ver 14.14 Distrib 5.5.0-m2, for unknown-linux-gnu (x86_64) using readline 5.1
[root@localhost ~]# more /etc/issue
Red Hat Enterprise Linux AS release 4 (Nahant Update 7)
Kernel \r on an \m
[root@localhost ~]# mysql -V
mysql Ver 14.14 Distrib 5.5.0-m2, for unknown-linux-gnu (x86_64) using readline 5.1
[root@localhost ~]# more /etc/issue
Red Hat Enterprise Linux AS release 4 (Nahant Update 7)
Kernel \r on an \m
[root@localhost ~]# more /proc/version
Linux version 2.6.9-78.ELsmp ( brewbuilder@ls20-bc2-14.build.redhat.com) (gcc ver
sion 3.4.6 20060404 (Red Hat 3.4.6-10)) #1 SMP Wed Jul 9 15:46:26 EDT 2008
[root@localhost ~]# uname -a
Linux localhost.localdomain 2.6.9-78.ELsmp #1 SMP Wed Jul 9 15:46:26 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux
[root@localhost ~]#
Linux version 2.6.9-78.ELsmp ( brewbuilder@ls20-bc2-14.build.redhat.com) (gcc ver
sion 3.4.6 20060404 (Red Hat 3.4.6-10)) #1 SMP Wed Jul 9 15:46:26 EDT 2008
[root@localhost ~]# uname -a
Linux localhost.localdomain 2.6.9-78.ELsmp #1 SMP Wed Jul 9 15:46:26 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux
[root@localhost ~]#
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-665654/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-665654/