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 ~]# 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 ~]#

ITPub博客

mysql迁移oracle周末计划

最新文章