Hi, Well I've tried to export 12 million rows with success from mysql to Oracle.
I used MS Access and created an ODBC connection to get the data from Mysql, then i exported all rows to a .csv file. Then i used Oracle Sql-loader, because I wanted em in an Oracle DB. But you can import it to another mysql database, if you set up another ODBC connection. It's not that difficult. Regards /Frank (Oracle DBA) ----- Original Message ----- From: "Bill Leonard" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 15, 2002 8:56 PM Subject: Export, then Import HUGE number of rows/data? > We have a client who wants to switch their hosting over to us, but has an > issue with his MySQL database. > > It's about 1.4 million rows, and about 350MB of data. PhpMyAdmin apparently > times out when he is doing the dump. > > What is the best way to go about getting this data on to one of our systems? > > Thanks for any advice! > > Bill > > -- > Bill Leonard [EMAIL PROTECTED] > www.machinemen.com 407.464.0147 > > > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
