Importing Large CSV Files

[EvilAsh]

Hi guys. Please can anyone offer any advice on the following?

I have been given a large csv file (about 13,000 rows) for import into a mysql db. I would normally use phpmyadmin to do this but it times out when I try.

I have adjusted the file size limit but to no avail.

I appreciate that this can be done by command line but my web hosts only allow phpmyadmin access so my hands are tied.

What solutions do I have? Do I need to break the file into smaller chunks?

Thanks.

 

[Kozusnik]

If your provider only allows phpMyAdmin access, then you will probably have to create smaller files. If you can edit the php.ini file, you could set the timeout to be larger. That may work.

Mark