I’m trying to import a CSV file into a new table with phpMyAdmin, but after the file upload is complete I’m redirect to a “This page does not work. 185.27.134.10 has not sent any data. ERR_EMPTY_RESPONSE” page.
I’ve made sure the CSV seperator is colon “,” and the encoding of the file is UTF-8, just like the default import settings for CSV.
How big is the CSV file? It’s possible that you’re running into a timeout.
Hi!
It works when I import it into a table that does already exist, I think phpMyAdmin just doesn’t have the feature to create and at the same time import into a table.
@InfiniteCustomer said:
Hi!
It works when I import it into a table that does already exist, I think phpMyAdmin just doesn’t have the feature to create and at the same time import into a table.
I’m glad the issue was resolved.
Yes, you need to create the table first before you can import data into it. Creating a table involves telling MySQL your data structure, the columns, data types and keys and indexes. A CSV file does not contain such information, so creating a new table from a CSV file would be a best guess, which is likely sub optimal.