[Ritesh]

Thx for the report.

I have forwarded the issue to my development team. The bug (if there are any) will be fixed in the next BETA.

[Ritesh]

This feature is in the TO-DO list if v4.2.

[Ritesh]

While exporting data using SQLyog, just check the option Set FOREIGN_KEY_CHECKS=0. It will generate the script like:

Code:

/*
SQLyog v4.03
Host – 207.184.100.230 : Database – vah service
**************************************************************
Server version 5.0.2-alpha
*/

create database if not exists `vah service`;

use `vah service`;

set foreign_key_checks = 0;

/*
Table structure for Tech Names
*/

drop table if exists `Tech Names`;
CREATE TABLE `Tech Names` (
`Tech Name` text NOT NULL,
`Tech Number` smallint(6) NOT NULL,
PRIMARY KEY (`Tech Number`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

…………..
…………..

set foreign_key_checks = 1;

[Ritesh]

Which version of SQLyog are you using?

4.1 BETA or 4.0x?

[Ritesh]

dekamerone wrote on Feb 25 2005, 02:03 PM:

Error No. 2013.

Lost connection to MySQL server during query

Does this help:

http://dev.mysql.com/doc/mysql/en/gone-away.html

[Ritesh]

Uncheck the option Flush Logs Before Dump and try again.

[Ritesh]

Bug confirmed.

Will be fixed in 4.03.

[Ritesh]

Code:

version()    
————–
3.23.58-max-nt

Same result.

My history tab shows the following query.

Code:

load data local infile 'D:/Documents and Settings/Administrator/Desktop/Fulfillment_Catalog_exp_pricelist_prices.txt' into table `bimp`.`exp_pricelist_prices` fields escaped by '\' terminated by ',' lines terminated by 'rn' ignore 1 lines ( `printsize_id`, `pricelist_id`, `price`, `sort` )

[Ritesh]

Which version of MySQL are you using?

[Ritesh]

Click Import

[Ritesh]

Select Table -> Export/Import -> Import data from CSV… and enter the correct values.

[Ritesh]

Create table using the statement provided by you.

[Ritesh]

I was successfuly able to import 92 rows of data in the file without any problem. The screenshots depict the steps I followed.

[Ritesh]

Can you cut-n-paste the CREATE TABLE STMT… for the table?

[Ritesh]

Check out:

http://dev.mysql.com/doc/mysql/en/cursors.html

for more information.

[Author]

Posts