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 Link to comment https://forums.phpfreaks.com/topic/247186-need-help-importing-large-csv-file-into-phpmyadmin/ 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 Link to comment https://forums.phpfreaks.com/topic/247186-need-help-importing-large-csv-file-into-phpmyadmin/#findComment-1269593 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. Link to comment https://forums.phpfreaks.com/topic/247186-need-help-importing-large-csv-file-into-phpmyadmin/#findComment-1269607 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. Link to comment https://forums.phpfreaks.com/topic/247186-need-help-importing-large-csv-file-into-phpmyadmin/#findComment-1270217 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.