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, Quote Link to comment 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. 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.