php MyAdmin

[tony16mc22]

I am tyring to import a CSV file into my dabtabase buyt it keeps timing out an gives me the following erroe: Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/sqlparser.lib.php on line 551

 

[descalzo]

Try breaking it up into smaller parts and importing them separately?

 

[tony16mc22]

The file is only 2.5MB. I figured it out, but now it keeps telling me when I try to import a cVS file that: "Invalid field count in CSV input on line 1." How do I fix that?

 

[MaestroFX1]

Try this:
--------
cPanel >> phpmyadmin
Import >> browse csv file. >> Select CSV using LOAD DATA (rather than just CSV) >>Change “Fields terminated by” from “;” to “,” >> Make sure “Use LOCAL keyword” is selected. >> Click “Go”
------
It should work !

Have you tried importing the database/table on your desktop mysql server ?

Are you sure it is 100% error free there?

Is your CSV old (those geoIP)?

Also, try importing CSV on your desktop mysql server, then export it as sql(gzipped or zipped)and then upload it here.