title: How to upload .csv file on hosted MySQL server (ftp access not available)
body: <p>I have an excel application exporting data in .csv format (thousands of rows) which I need to upload quickly on the mysql server located on my website hosting server (in my case it is GoDaddy). Since the dataset is large, I can't upload the data through multiple strings or one by one row.</p>
  
  <p>I have already tried importing .csv file on mysql server using <code>Load data local infile</code> method. It works great when the mysql server is installed locally but fails completely when I try this on mysql server installed on website hosting because mysql user does not have the ftp folder access due to security issues.</p>
  
  <p>My questions:</p>
  
  <ol>
  <li>What would be the best way to upload bulk data to mysql installed on my website hosting using Excel VBA?</li>
  <li>I have found out using Google that using a PHP script is an option. Can somebody please suggest a good reference on how to achieve that?</li>
  </ol>