4 messages in com.mysql.lists.mysqlRe: Export, then Import HUGE number o...
FromSent OnAttachments
Bill Leonard15 Oct 2002 11:56 
MySQL15 Oct 2002 12:33 
Paul DuBois15 Oct 2002 14:46 
Alex Pilson15 Oct 2002 15:05 
Subject:Re: Export, then Import HUGE number of rows/data?
From:MySQL (mys@tuffy.dk)
Date:10/15/2002 12:33:21 PM
List:com.mysql.lists.mysql

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" <bi@machinemen.com> To: <mys@lists.mysql.com> 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 bi@machinemen.com 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 <mysq@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-mysql=tuff@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php