Thanks for the resource!
However, I am loading into a MyISAM table, while logging is disabled.
In a matter of fact, I was able to load the data at the end, after
disabling the keys. But now, as I try to create the keys, it takes a
huge amount of time. there are 250 Million rows in one of the
Hello Shuly,
Try this.
http://www.mysqlperformanceblog.com/2008/07/03/how-to-load-large-files-safely-into-innodb-with-load-data-infile/
On Tue, Feb 24, 2009 at 1:08 PM, Shuly Avraham wrote:
> Hi,
>
> I have a huge table with about 50 millions of rows.
> I dumped the table using mysqldump -T ,
Hi,
I have a huge table with about 50 millions of rows.
I dumped the table using mysqldump -T , as text dump, and now trying
to import it to a database on another server, but it keeps hanging.
Are there any options or server variables I can set to help out with it?
Thanks,
Shuly.
--
MySQL Ge