Just a quick heads up so that when one of your clients runs into this one you won't pull your hair out like I did for a couple of days...

If you try to use the Upload Text File feature in phpMyAdmin with the later versions of Plesk it's not going to work. RS won't support it since you've "upgraded" so you have to go to Plesk to get an answer. Which is what I ended up doing.

Plesk support initially told me to install another version of phpMyAdmin separate from the one available through the GUI. Don't bother, it won't help.

The long and short of it is that the latest versions of Plesk compile MySQL so that "Load Data Local Infile" is disabled server wide because of security concerns. (read someone feeling malicious would be able gain as much access to your server as you, the Admin has because they could get all of your passwords.)

Fixes? You could always recompile MySQL I suppose and enable that function, but that kind of defeats the purpose. If it's just you on the server then you could always access MySQL from the command line to get it done, which is what I ended up doing until I could find a better solution.

What I finally ended up doing after a few days of research was to grab Jack Lumbruso's csv to sql converter ( http://www.lumbroso.com/scripts/ ) and installed this script for the client I have who likes to use Excel update their database. It's just a matter of a quick conversion, saving the new file as a .sql file and using that to update the database. Easier, more secure and the only change they had in their routine was to make sure they put the Header info into their .csv's before saving them.

Hope the heads up saves someone some time and trouble down the road.

Squire