Forum Moderators: open

Message Too Old, No Replies

Table with 25 Millions Records

How To transfer

         

ashii

10:00 am on Jul 23, 2007 (gmt 0)

10+ Year Member



I have a big MYSQL database table with 25 Millions Records in a Linix/apache box.
I need to transfer it to a Windows Box (window 2003 running IIS PHP and MYSQL).

I tried using Navicat softeare but it fails becuase of memory failure after about 5 millions records.

what other options I have?I tried to see if navicat allow to transfer using a query ,but it does not have such option.

FalseDawn

12:28 am on Jul 24, 2007 (gmt 0)

10+ Year Member



Use mysqldump
[dev.mysql.com...]