[Resolved] phpMyAdmin 2.3.2

collegefan

I have shared hosting for my site. My web host provider recently changed from phpMyAdmin 2.2 to 2.3.2 and now I can't load data into tables using the "Insert data from a textfile into table" form. I use .csv files to update data into the table and the error message I get with this new version of phpMyAdmin is:

"The used command is not allowed with this MySQL version"

Something has changed with 2.3.2 that I can't figure out.

Could someone point me in the right direction?

CollegeFan

tsinka

Hi,

I think that phpmyadmin uses "load data local infile" where "local" is disabled per default on recent MySQL versions for security reasons. The hoster might either need to change the myadmin code not to use "local" or to enable "local" support on their MySQL installation.

This part of the MySQL manual might help you to see what security issues enabling local would cause:

http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html

collegefan

The hoster will not make any changes to any standard setup of MySQL, PHP, or phpMyAdmin. Since I am using shared hosting, they have told me they don't modify files for individual accounts to keep their cost down.

The only way I can think of to load many rows of data on-line is to dump the table structure on-line and create a table on my pc using my version of phpMyAdmin. I can upload the .cvs file to my local table and then dump the data into a .sql file that I can upload on-line. I believe this will work but what a pain.

Does anyone have any other suggestions for uploading many rows of data when you don't have any access to the setup files?

CollegeFan

tsinka

Hi,

are you allowed to download and install your own copy of phpMyAdmin (somewhere in your web space, maybe password protected) ? You could then modify the sources yourself.

Thomas

collegefan

I tested this and it seemed to work ok. I create the tables locally and test the scripts and data output local on my pc. I do have write permissions to my on-line folder where the tables are stored. I just ftp the updated tables (.MYD files) from my local machine on-line. I am not sure what kind of trouble I am asking for with this method but its not too bad to do.

CollegeFan

tsinka

If the database is online you might get in trouble if you do this when there is any activity on the database. If you change any table layout you would also have to upload the .frm files and just copying the .MYD files might corrupt the indexes since they are stored in the .MYI files.

The more recent versions of phpMyAdmin allow you to choose if you want to use LOCAL or not. Is there any chance for you to upload a more recent version to your webspace and to use that one instead ?

Thomas

collegefan

tsinka,

Thank you for your help. They have told me I can use my own version of phpMyAdmin and I will do so.

CollegeFan