Import csv

Hello,

I have a csv with 3500 lines and 53 columns to import but nothing I try works.
The document is only 931kb so it’s not a size problem. I tried to split it, but nothing worked. Either the page loads emptyly, or it loads for 1/2 sec and turns white.

I also tried the zip format but it doesn’t change anything.

I hope someone can help me, thanks for your help.

Typically here the page will load for 12 hours without doing anything :frowning:
Should I wait longer? or give up

Try splitting it into 6 files or something like that. Or run a few statements at a time by copying them from the file into the SQL tab in PHPMyAdmin.

Most likely, the file you are uploading is taking longer to process then the timeout limit on the server.

5 Likes

Thank you for your answer :slight_smile:
I’lltry again today but from experience, if my query exceeds 20 lines it will not work.
It’s still very annoying when I have to record 3500, I was hoping to find a better solution

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.