Hi I have moved huge amounts of data around in the past, from Oracle to Oracle, and Oracle to MySQL.
The problems to consider are - export speed - load speed It can take hours to download a large database, nevermind re-loading it into another database. It is usually best to export the data into a simple file that can be read whilst you are writing to it. Load speed is tricky. Do not have any indexes. Use the MySQL LOAD command, it is fast. To do this I would do the following, - on Oracle server - - Create a NFS device - - Create a FIFO pipe, using mknod - - export data from Oracle to FIFO pipe - on MySQL server - - Mount remote NFS device - - Use MySQL Load command to load data, or write your own loader in perl - - when load is finished, build the MySQL indexes I hope that this helps Simon On Wednesday 20 Nov 2002 6:24 pm, Wesley Brown wrote: > Well, This is my first attempt at moving from Oracle to MySQL on such a > large scale and so far it isn't going well at all. We are running oracle > 7.3.4.0.1 and MySQL 4.0.4-0 standard. We are moving 101 tables with a total > of 45 millon records over. I have tried several diffrent methods including > using a MS-SQL server to act as go between using DTS services. We have run > into two problems, one, we don't get all the data over we loose rows and > the like. Two it is super slow on the order of 18 to 30 hours to do a pull. > We need a way to move the data in a resonable amount of time around 8 hours > is the goal. Things I have tried so far include using MS-SQL as a go > between fast but with data loss, using a custom ADO application to move the > data and handle any transforms we get the data but it REAL slow, and trying > to get the oracledump.pl perl script to run with no success. If anyone has > had a chance to do this type of migration please point me in the right > direction. I would really hate to stay with Oracle for the only reason that > we can't get the data off of it and on to another box :) > > Thanks, > Wes > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Simon Windsor mail: [EMAIL PROTECTED] tel: 01454 617689 mob: 07720 447385 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
