bschultz Posted August 30, 2010 Share Posted August 30, 2010 I need to upload a .csv file created from Excel into MySQL, but the host doesn't support Load Data Infile. What are my other options? Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/212088-upload-csv-filehosts-does-not-support-load-data-infile/ Share on other sites More sharing options...
PFMaBiSmAd Posted August 30, 2010 Share Posted August 30, 2010 Does your web host support the LOCAL version - LOAD DATA LOCAL INFILE? Quote Link to comment https://forums.phpfreaks.com/topic/212088-upload-csv-filehosts-does-not-support-load-data-infile/#findComment-1105272 Share on other sites More sharing options...
bschultz Posted August 30, 2010 Author Share Posted August 30, 2010 No, they don't. Quote Link to comment https://forums.phpfreaks.com/topic/212088-upload-csv-filehosts-does-not-support-load-data-infile/#findComment-1105273 Share on other sites More sharing options...
bschultz Posted August 30, 2010 Author Share Posted August 30, 2010 I found a solution...here http://www.legend.ws/blog/tips-tricks/csv-php-mysql-import/ Quote Link to comment https://forums.phpfreaks.com/topic/212088-upload-csv-filehosts-does-not-support-load-data-infile/#findComment-1105278 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.