kabar916 Posted September 15, 2011 Share Posted September 15, 2011 Guys! I need help. Im getting a error message in phpmyadmin saying my csv file is too large to upload. The file is 14MB in size. i can not figure how to import the data into sql through phpmyadmin. This is on my local computer. The file has in it about 50,000 rows and about 25 columns. Please help me!!! Ive been stuck for a few days now trying to figure it out. Thank you Kabar Quote Link to comment Share on other sites More sharing options...
gristoi Posted September 15, 2011 Share Posted September 15, 2011 upload the file to your servers home or root directory then in phpmyadmin use the mysql console LOAD DATA LOCAL INFILE '/importfile.csv' // wherever the file is located relative on the server INTO TABLE test_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1, filed2, field3); This function was created with large files in mind. I uploaded 1.2 million rows in around 4 seconds Quote Link to comment Share on other sites More sharing options...
fenway Posted September 15, 2011 Share Posted September 15, 2011 ...assuming the permissions are set up correctly -- LOCAL isn't allowed by default. Quote Link to comment Share on other sites More sharing options...
kabar916 Posted September 17, 2011 Author Share Posted September 17, 2011 thank alot bro. that helped. I was wordering, what kind of command would write in php. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.