Why won't string work??
I am trying to load over 300,000,000 millions rows of data into a mysql table and I am trying to make it faster. However, when I move the prepare statement out of the loop and place the $uwind and $vwind in the execute it won't work. It says the data for $uwind is truncated. Can someone help me out here? Or, if you know of a faster way to load 300,000,000 millions rows of data from text files into mysql that would be greatly appreciated! Thanks a lot.
Re: Why won't string work??
I just attended this seminar yesterday and today I'm recommending it. COOL :)
Try this one, Oracle Data Integrator.
This just suites your requirement.
1] Load data from Text files to MySQL
2] Load tons of data in min amount of time
The presenter had loaded data from a 30GB file in around 30 minutes.
|All times are GMT +5.5. The time now is 10:00.|