rustbckt Posted February 19, 2010 Share Posted February 19, 2010 I have a very large text file that gets updated daily and need to import it into a mysql database. I am not sure what is the best way to go about getting this done. I have tried php but it times out before it gets done. The files has over 90 fields and 15,000 listings. It is a real estate database. Any help or direction would be great! The file is a .txt comma separated. Thanks, Link to comment https://forums.phpfreaks.com/topic/192669-import-a-very-large-text-file-into-mysql/ Share on other sites More sharing options...
jl5501 Posted February 20, 2010 Share Posted February 20, 2010 If you upload it by ftp and then have php process it, and it still times out, then your best bet (if you do not have control of php.ini), is to break the file into smaller ones, and import each piece. Link to comment https://forums.phpfreaks.com/topic/192669-import-a-very-large-text-file-into-mysql/#findComment-1015223 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.