Unable to import CVS to locally installed XAMPP

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Unable to import CVS to locally installed XAMPP

Postby jasonc310771 » 05. June 2015 09:59

I have installed V3.2.1 of XAMPP and have it all working ok for some time, but today I try to import a 2G csv file into an empty database and I just get a blank page in the main content area, all the menus and other information on the page is there, just the middle part of the page is blank.

I have tweaked the settings/php.ini and other files so allow up to 3G files to be processed/uploaded, but think there is something else I am forgetting.

in php.ini i have...

memory_limit=3000M
post_max_size=3000M
upload_max_filesize=3000M
max_execution_time=10000
max_input_time=10000

in my.ini i have...

max_allowed_packet = 3000M


but still the file is not importing.

What else can I try ?
jasonc310771
 
Posts: 2
Joined: 02. November 2014 06:55
Operating System: Windows 7 (64bit)

Re: Unable to import CVS to locally installed XAMPP

Postby Nobbie » 05. June 2015 10:48

jasonc310771 wrote:What else can I try ?


Dont use phpmyadmin for such huge imports, enter the corresponding SQL Command (it is shown in phpmyadmin) directly into mysql interpreter (mysql.exe). Look into the MySQL Docu for proper SQL syntax:

https://dev.mysql.com/doc/refman/5.1/en/load-data.html
Nobbie
 
Posts: 8775
Joined: 09. March 2008 13:04


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 40 guests