[malik]

How can i double check that 'load data' is definately disabled on the server?. The error message i am getting is:

“The used command is not allowed with this MySQL version”

[malik]

'peterlaursen' wrote:

This is probably because of the escaping settings not working well with actual data in the table. Do you have “” (backslash character) or linebreaks in the data for instance? Also are you importing using LOAD DATA syntax when importing or are you using the ODBC-based option?

It is very difficult to comment on without exact data for the table. Can you share the CSV-file? If you want privacy send a mail to [email protected] and attach the file (it will create a support ticket). Also a SQL export from the table will be useful.

Edit/Added: First step should be to find out if this happens during export or during import. That is why we need the CSV-file. But best of all would be if you could 'compose' an example with only a few rows in the table where this is reproducible.

Hi Peter

The import files do have line breaks.

The files are .txt files containing rows of data (comma delimit):

xxxx,xxx,xxxxx,xxxx,xxx,xxx,xxxxx

xxxx,xxx,xxxx,xxxx,xxxxx,xxxxx,xxx

xxx,xxxxx,xxxxxx,xxxx,xxxxx,xxx,xxx

All loaded using sqlyog LOAD DATA

Any ideas?. If not i will have to do as you say and begin more detailed troubleshooting and find a small reproduceable sample I can post.

[malik]

peterlaursen wrote on Apr 10 2008, 03:50 AM:

It was renamed from 'empty table' to 'truncate table'. 'truncate table' is the correct SQL term.

Did I understand correctly?

Ahh i see, thank you Peter. The word 'Truncate' has a different meaning to me so i didn't consider it.

One other question if i may. I note there is now a character set on the import box. The default being utf8

The database i am looking at is showing as latin1

ENGINE=MyISAM DEFAULT CHARSET=latin1

No idea why this has latin1. This must be the default in Mysql when it was created. As far as i am aware there is no problem with leaving Yog set as utf8.

[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

[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

[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 😀

[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

[malik]

Hi

Thanks for reply.

My original post wasn't particularly quite clear so i have amended this.

I need export only specific columns if possible. Any suggestions how to do this/get around this problem?.

TIA

[Author]

Posts