[zzapper]

Ritesh,

I can duplicate this from my local copy!!

I 'm using your latest beta.

I find the error by searching for lines ending

valuess+$

insert into db73723442.pdownloadtrialsp values

insert into db73723442.pleaddetailsp values

insert into db73723442.pwebsiteproductsp values

insert into db73723442.pdownloadtrialsp values

insert into db73723442.pleaddetailsp values

insert into db73723442.pwebsiteproductsp values

[zzapper]

Ritesh,

It's client data so I dont' feel I can send it to you.

But I've noticed:-

0) The Rogue inserts always end with “values”

1) the rogue inserts are superfluous ie they are preceded and followed by good inserts eg

insert into `db73723442`.`downloadtrials` values ('1844','cashbookwin','…..'01614831435');;

insert into db73723442.pdownloadtrialsp values

insert into `db73723442`.`downloadtrials` values ('1845','cashbookwin','…….'

2) The previous good insert always has ;; (double semi-colon)

3) The quotes round the table name are replaced by a pair letter of letters sometimes p sometines x

[zzapper]

eg

insert into `db73723442`.`downloadtrials` values ('3032','cashbookwin','Neil','fred Software Ltd','[email protected]','07977464839');;

insert into db73723442.pdownloadtrialsp values <<==== ERROR HERE <<==== insert into `db73723442`.`downloadtrials` values ('3033','payroll','Steve Pass

[zzapper]

Hi,

In the mean time I use

http://www.structurise.com/kleptomania/

to grab any text I draw a box round from the screen. But be aware uses OCR so confuses 1 & l etc

[zzapper]

Ritesh,

the freshly brewed 4.1.Beta

BTW I have just successfully used Copy DB to a different DB/HOST.

SQLyog Enterprise v4.1 BETA

[zzapper]

Ritesh,

I forgot to say if I resist the tempation to switch windows application the “Execute Batch” runs fine.

(BTW Ritesh, minor feature request:- when a “execute batch file” ends could the acknowledgement be more explicit , I make it visually obvious that it's ended)

[zzapper]

Ritesh,

I mean say I'm doing a “execute a batch file” with 46000 inserts I see that little status window , with the number of inserts steadily increasing, when it finishes running it says 46000 inserts took 250 seconds. However if during these 4 minutes I decide to read my email and bring up my emailer/browser doesn't matter YOG will then freeze (not responding), and I have to kill it's task from the task manager

c:mysqlbinmysql.exe Ver 12.22 Distrib 4.0.20a, for Win95/Win98 (i32)

WinXP Home SP2 etc

Yog-ENT 4.02

[zzapper]

Ritesh,

Sorry was me having a bad-hair day.

The csv line terminator I required was rn

Non-ascii characters inserted into mysql all seem to display as a hollow box

The mysql I needed to filter it out (having got the line terminator wrong) was

update test set txt = replace(txt,'r','');

[zzapper]

Ritesh,

I tried alternatively r and n w/o success.

The query I tried to use to clean up the data was

update tbl_county_lookup set countyname=replace(countyname,'&','and');

That works for a character such as '&' but I couldn't get it to work for null where I tried N and NULL.

Come on folks this must be a fairly common problem!!!

[zzapper]

Ritesh,

altho i've reordered tables successfully b4, I am now getting this error with yogent4.0

SQLyog Enterprise ×

Error No. 1005

Can't create table 'c:TEMP#sql10c_c_1.frm' (errno: 140)

just about to try 4.1

sorry still in 4.1

it's a real simple table

Field Type Null Key Default Extra

ID mediumint(9) PRI (NULL) auto increment

DivisionID char(3) YES (NULL)

DivisionName varchar(30) YES (NULL)

DivisionEmail varchar(50) YES (NULL)

DivisionPhone varchar(20) YES (NULL)

AssertaCode varchar(10) YES (NULL)

divisionShortName varchar(20) YES (NULL)

[zzapper]

Tunneling NOW working superfine thanx,

All I had to do was use the PHP connection data I was using in my PHP code, and NOT the phpMYADMIN login /password!!

what a wally!!

Perhaps you want to mention this is your FAQ!!!!

Ritesh Super thanks to you and your Team.

DON't BE SCARED OF USING TUNNELING IT's dead easy to set up (when you know how)!!

[zzapper]

Ritesh

(x123456 has been used to obscure the real domain for security reasons)

SQLYOG Configuration

MySQL Host Address db123.x123456.co.uk

User Name sxxn

Password 

Port 3306

Database(s) db73723452

Use HTTP Tunneling _

URL: http://www.xy1234.co.uk/SQLyogTunnel.php

Timeout: 30 (in seconds)

sqlyog error message

Error No. 1045

Access denied for user: '[email protected]' (Using password: YES)

What phpmyadmin says when I login

MySQL 4.0.20-standard-log running on db123.x123456.co.uk as [email protected]

[zzapper]

Hi Y'All

Edit->Execute Query->Execute for Update…. or you just need to execute the query by pressing F8 instead of F5.

Just the answer I woz a lookin' for!!!

That is sooo cool!!!

[zzapper]

Ritesh

Now we're sucking diesel' (Now we're making progress! of Irish origin)

[zzapper]

Ritesh,

That's it Uncheck “Truncate column headers to Max. data size in Tools -> Preferences?”

Now we're sucking diesel!!!

[Author]

Posts