phpMyAdmin Import timeout

[cqfamily]

I have a table in Access, which I want to import into my database in phpMyAdmin.
I export the table to a csv file. It is 55078kb.
In phpMyAdmin console

• Choose my Database
• Choose the file I want to import
• Choose Import
• Choose the file (969340 records, 55Mb)
• Character set utf-8 (default)
• Partial Import = tick off
• Skip number of queries =0 (default)
• Enable foreign key checks =on (default)

Format

• CSV
• -Update on duplicate keys=off
• -Cols sep =,
• - Cols encl ="
• - Col escaped with ="
• - Lines term =auto
• - Col names =blank (data is in same order)
• Do not abort =unticked

It runs for a bit then says "Request Timeout" - This request takes too long to process, it is timed out by the server. If it should not be timed out please contact administrator of this web site to increase 'Connection Timeout'.

Well...I guess 'I' and the administrator of the website, but I can't see 'where' I can increase the 'Connection Timeout'.

Any suggestions as to what I'm doing incorrectly and what else I could try?
I 'should' add that I was able to add a table a few years back, which worked, but was smaller, but now this isn't working
Thanks!

 

[garrettroyce]

Can you break the file up into smaller pieces? You should be able to split it after one table is complete and all the rows have been INSERT'ed.

 

[cqfamily]

Thanks for replying. Sorry I've been traveling so not able to reply.
I tried breaking it up and that hasn't worked either.

 

[garrettroyce]

does every file after you broke it up time out, or only some?

 

[cqfamily]

Have eventually 'kind-of' resolved the issue/s.

• First issue was that there were illegal/reserved characters in the data. Now I know about these I can fix these before new uploads.
• Second issue is the php timeout. I would really love to know how to increase the timeout, as it takes many hours to upload the data, and sometimes it only uploads 600 records at a time (and I have over a million), so it takes many hours of continually deleting the records already uploaded and trying again. (The php timeout happens even with smaller files).