|
Replies:
0
-
Pages:
1
|
Threads:
[
Previous
|
Next
]
|
|
Posts:
3
Registered:
10/26/12
|
|
|
|
How to import Large CSV - Arithmetic operation resulted in an overflow.
Posted:
Dec 6, 2012 9:35 AM
|
|
|
I'm using MySql 5.5.28 and TOAD 6.3.0.642 in a Windows 7 64 environment with 8G of Ram and an Intel Corei7
I'm trying to load a HUGE CSV file into a extremely large table - width wise.
The table has 329 fields
The csv is 4.5G
When I attempt to use the import, it fails with the error:
Arithmetic operation resulted in an overflow.
I can load a file of 4000 records with the same layout with no problem.
I tried opening the TIM file with an editor an replacing the file names, but the same error occurred when I tried to run it throughthe Import utility
If I could get at the SQL for the small table, I might be able to use it for the larger one. Is there a way perhaps to capture the SQL that is used for the import?
Anyone have any ideas?
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
