Can't Import Csv Data – Error 1148

[CNN]

I need to import data and got this SQLYOG Enterprise version.

On import getting message

Error 1148

The used command is not alloweded with this MySQL version.

Can anyone help here?

I need to import data in webhosting (GoDaddy) server.

thx.

[Mahesh]

Please tell,

1) Program version you are using ?

2) Which import option you used “Import from External data” OR “Import CSV data using LOAD LOCAL..” ?

3) Can you please attach a table structure and CSV file used while importing ?

[CNN]

'Mahesh' wrote on '09:

Please tell,

1) Program version you are using?

2) Which import option you used “Import from External data” OR “Import CSV data using LOAD LOCAL..” ?

3) Can you please attach a table structure and CSV file used while importing ?

1- v5.21

2- Right click table > Import / Export > Import Data from CSV > Select local CSV file and hit button and it bring error message immediatly.

?? where is Import from External Data. This may be issue here??

3- files attached.

[Mahesh]

We tried with latest version v8.53 and import of data works fine except warnings.

Please try with latest version and let us know the status? as v.5.21 is very old (almost 3+ years)

[CNN]

'Mahesh' wrote on '09:

We tried with latest version v8.53 and import of data works fine except warnings.

Please try with latest version and let us know the status? as v.5.21 is very old (almost 3+ years)

I paid for v5.21 which has this advertised feature. If some feature is not working in that version then I should get fix or patch. Buying upgrade as this version does not work as advertised or 3 yrs old is not good answer, and is not acceptable.

I have hard time to understand that issue was with v5.21 and you are spending time and testing v8.53. How that will help me or for this issue?

I just need working copy of v5.21 which I paid.

[peterlaursen]

There is no option to patch old versions.  Our support and upgrade policy is described here:

http://webyog.com/faq/content/30/129/en/upgrade-policy.html

.. and it was also like that when you purchased. As per policy we support the latest stable version only.  You will have to accept that that is how the software industry is.  You have to check features in the evaluation period. 

The reason is that LOAD LOCAL is disabled/nonfunctional on this server. Read http://dev.mysql.com/doc/refman/5.0/en/loading-tables.html (including comments). It is not a problem with the client program (SQLyog) but the server configuration.

What does

Code:

SHOW GLOBAL VARIABLES LIKE 'local_infile'

return on this server?

[peterlaursen]

One more link: http://dev.mysql.com/doc/refman/5.0/en/load-data-local.html

[Author]

Posts