Importing .csv in phpMyAdmin Issues
 

So I'm trying to import a .csv file into an SQL database using phpMyAdmin but it keeps quitting on me, I have already doubled the settings below from their default values, how much higher can I put them in order to get this .csv file imported?

There are over 400,000 rows across 7 columns.

404 Error

Or, as an alternative, are there any other methods that will enable me to get this information uploaded into the database in a timely manner, short of splitting the data into 8-10 smaller .csv files?

Thanks.

I would suggest to split it up into multiple files. Should only take a few minutes.

anybody launch a fiverr for adult yet? :1orglaugh

#

Use this PHP script: https://www.ozerov.de/bigdump/usage/

Below "file to import"

Partial import:
Allow the interruption of an import in case the script detects it is close to the PHP timeout limit. (This might be a good way to import large files, however it can break transactions.)

Uncheck this, and u will be able to import as much as u want without timing out. Problem was not related to the config u did.

Not Yet..........

send me a pm im buzzzed though. god u cant import that all at once.

400,000 rows is nothing. The command line (LOAD DATA command) should handle that in under a minute.

Use MySql Workbench, DATA IMPORT which is found under the server tab in menu. I have used it a few times now to import large databases.

I have only used it locally so far, but you can connect to remote (server) databases with it.