Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MYSQL IMPORT

Status
Not open for further replies.
prav5110

prav5110

IS-IT--Management
Sep 17, 2003
8
US
HI All,

I am using the command line to import CSV files into a MYSQL DB. I am having problem with 1 particular file that is 84megabite. I am able to import the file if i break it into parts, however am not able to import all at once. My sql server connection looses. Could you help?

thanx
 
Sort by date Sort by votes
in winMySQLAdmin go to Environment click set server query interval and alter value, this button is at bottom left. does this work?

To err is human, to completely mess up takes a computer. [morning]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

E
  • Locked
  • Question
MySQL calculator tools
Replies
0
Views
229
EdZzy
E
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
450
lupidol
lupidol
lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
407
Chris Miller
Chris Miller
dylim
  • Locked
  • Question
Why MySQL 5.7 is still getting updates
Replies
3
Views
337
spamjim
spamjim
dylim
  • Locked
  • Question
SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29
Replies
2
Views
481
dylim
dylim

Part and Inventory Search

Sponsor

Back
Top