HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   hpMyAdmin gives "file could not be read" error (http://www.howtoforge.com/forums/showthread.php?t=59771)

Cracklefish 2nd December 2012 19:40

hpMyAdmin gives "file could not be read" error
 
My server is Perfect Server - Suse 11.3 Tutorial, ISPC 3.0.3.3

I get a "file could not be read" error when I try to import any .csv file (<2MB)into a any table.

The machine is about 2 years old, has had no changes since being put into service apart from a HDD replacement. This function worked originally but has never been needed again, until now. I have not (yet?) encountered any other phpMyAdmin functions that fail but then this is not a busy system. Until now, all mySQL tweaks have been so trivial that an edit using pMA was all that was required.

I have checked out many posts regarding this error but not found any cure.

Any ideas anyone?

falko 3rd December 2012 09:52

Maybe the format of the CSV file is not ok?

Cracklefish 3rd December 2012 10:50

Quote:

Originally Posted by falko (Post 289138)
Maybe the format of the CSV file is not ok?

Possibly but afaik I made it the same way as before by saving an excel spreadsheet as a .csv under xp. That failed. I opened and saved it with notepad - same result then tried with notepad++ - just the same.

I tried with and without a blank line at the end of the list.
I tried terminating the fields with a colon (:)

I tried using firefox and ie8 under xp still same result.


All times are GMT +2. The time now is 17:29.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.