no data import functionality from text file into db

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

no data import functionality from text file into db

Postby bartolo » 04. November 2008 21:34

I have been trying to get a simple test db (1 table - 4 columns) to import from a simple .csv file (4 columns - 4 rows).

I keep getting the same phpMyAdmin error - no file chosen or file too big. Neither is the case.

When I go online and use a test db (using the same version of phpMyAdmin) it works fine.

I have re-installed xampp 3 times.

I'm at the point of finding someone who speaks German to post this for me on the German forum.

Needless to say any and all info would be greatly appreciated!!!
bartolo
 
Posts: 10
Joined: 06. October 2008 22:41
Location: Los Angeles

I found an answer.

Postby bartolo » 05. November 2008 00:34

I found the solution to my import problem. It was buried in another posting dealing with a problem that had nothing to do with my situation. See XAMPP and Leopard - 2007-11-30. I found it by searching for "import" in XAMPP for Mac OS X.

It was an xampp default setting for the php.ini file. For some reason, xampp has chosen to set "upload_tmp_dir" to being commented out. Hence, there was no temp holding area for the file I was attempting to import.

By changing the parameters of "upload_tmp_dir" in the php.ini file -
1) by uncommenting it and
2) setting it to "/tmp"
everything is working fine.
bartolo
 
Posts: 10
Joined: 06. October 2008 22:41
Location: Los Angeles


Return to XAMPP for macOS

Who is online

Users browsing this forum: No registered users and 46 guests