import table problem

[kbgaddis]

I have been using the SQLyog 3.6 beta over the last few days and I've found

something i thing might be a bug.

when I export a table to CSV, everything goes smoothly.  however, when i try

to import the same table back into a matching structure in a different

database (which may be a red herring; it seems to happen regardless) i get an

error message as follows:

 Error No. 1064

You have an error in your SQL syntax.  Check the manual that corresponds to

your MySQL server version for the right syntax to use near 't' enclosed by

'|' lines terminated by 'n'( ID, Keyboard, St

the options i'm using for import are

fields terminated by t

fields enclosed by |

lines terminated by n

i'm attaching the error file in the sqlyog directory; i don't know if that

will give you any additional information. let me know what else i can do to

give you more information.

[Ritesh]

Can you mail me the CSV file with the Table structure?

A screenshot of the Escaping Character dialog will be nice 🙄

[apmuthu]

SQLYOG v3.61

on Win98 with MSIE v6.0 SP!

Export a table as CSV

Import into another database's table.

A blank record appears along with the imported data.

SQLYOG.INI file's relevant portion:-

Code:

[CSVESCAPING]
ESCAPEDBY=\
FESCAPE=,
LESCAPE=rn
ENCLOSEDBY=
ISESCAPED=1
ISFIXED=0
LINETERMINATED=1
ISENCLOSED=0
ISOPTIONALLY=0
FIELDSTERM=1

Ap.Muthu

[Ritesh]

Can you paste the LOAD LOCAL SQL syntax that SQLyog sends to the MySQL server? You can get it from the History.. tab.

[Author]

Posts