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

mysql遷移oracle週末計劃

相關文章