Import Error 1148

[malik]

Hi

I can access the database ok and can make changes to the table data all via sqlyog. However when i try to import my csv data I get

Error No 1148

The Used command is not allowed with this mysql version.

Any ideas as to the probem?. I'm using MySQL version: 5.0.22

[peterlaursen]

No direct idea, but could you possibly upgrade the server? Latest stable is 5.0.45 and 5.0.22 is pretty old and buggy. (I would say anyone using a version before 5.0.28a should upgrade immediately).

What is the EXACT statement causing this error. Does HISTORY tell?

Can you attach a sample .csv (please ZIP it) causing this error and a screenshot of your import settings?

[malik]

I cant upgrade the mysql version unfortunately

Nothign in history as it doesnt get that far.

I can import using mysqlfront but not sqlyog and cant understand why.

Question for you. Do you know if importing a file with sqlyog is classed as “LOAD DATA INFILE syntax” ???.

Reason i ask – the isp doesnt allow LOAD DATA INFILE syntax for security reasons. But im not sure of this wording.

tia

[peterlaursen]

yes, I know it is you! 🙂

anything else you want to tell or was that it?

[malik]

peterlaursen wrote on Aug 29 2007, 01:50 PM:

yes, I know it is you! 🙂

anything else you want to tell or was that it?

I was re-editing my post 😀

[peterlaursen]

Yes, SQLyog does

LOAD LOCAL DATA INFILE ….

http://webyog.com/faq/content/28/73/en/i-h…ighlight=infile

[malik]

Peter

Can i get your input on this again.

It appears this is disabled on most servers. I've setup a windows test server and have this disabled and yet i am able to import data via sqlyog without any problem.

http://img104.imageshack.us/img104/3907/mysqlwindowsxb9.gif

However on a linux server with what appears to be the same permissions I run into error message:

http://img99.imageshack.us/img99/4711/mysqllinuxum4.gif

Any ideas?.

TIA

[peterlaursen]

Don't blindly trust 'MySQL Administrator' here. It has/had a bug with LOAD DATA INFILE. Depending on the MA version it is fixed or not!

http://bugs.mysql.com/bug.php?id=17921

Check the my.ini/my.cnf file!

[malik]

peterlaursen wrote on Sep 21 2007, 11:54 AM:

Don't blindly trust 'MySQL Administrator' here. It has/had a bug with LOAD DATA INFILE. Depending on the MA version it is fixed or not!

http://bugs.mysql.com/bug.php?id=17921

Check the my.ini/my.cnf file!

We spotted thank you peter!. I woud have expected this to have been resolved by now. Its a year ago.

I did try local-infile = 0″ but it didnt appear to work.

Can you elaborate what you mean by

.. of course will need to change display in MA from 'enable' to 'disable'

Thank you

[peterlaursen]

If there is no “local-infile” in the MySQL configuration file it is by default enabled.

MA did not realise that! And it did the opposite of what the GUI told!

Besides I do not remember that old discussion in details any more.

The '0' and '1' settings are explained here:

http://dev.mysql.com/doc/refman/5.0/en/pri…es-options.html

[Author]

Posts