[peterlaursen]

Quote:

but I can't connect

now what error messages do you get?

This FAQ may explain things for you: http://webyog.com/faq/23_15_en.html

or this: http://webyog.com/faq/23_18_en.html

[peterlaursen]

no idea!

Unlike Putty SQLyog is designed for multible connections.

[peterlaursen]

It is a little bit tricky with this setup. But try to learn the tool

You could do like

1) run import jobs creating empty tables (using a where that is never fullfilled (like WHERE 'a' = 'b')

2) run ALTER TABLE statements (form a Notifications Service Job) creating FK's

3) run import job again without the 'silly where' and choose the option not to delete existing tables.

[peterlaursen]

Quote:

Where to put the data of 3 or 4 access DB colums into adequate collums in the mysql tables.

That is another problem then. it is columns but not rows that you want to 'split'.

Well you just select what columns should be imported with each job? See attached.

Do I completely misunderstand you?

[peterlaursen]

Why do you use Excel and CSV as an intermediary format? You can import directly from Access with SJA/Migration tool.

Do you use Migration Tool with the text-ODBC-driver or is it is SJA for Linux and a Notification Service job? Or … ?

Please explain more in detail!

With direct migration from Access you will need to run 5 different jobs then and use the parameter with each of them. You can create one batch-file with the 5 jobs, as described here:

http://webyog.com/faq/27_35_en.html

read about the option here

http://www.databasejournal.com/features/my…p/10897_3550146

[peterlaursen]

Thanks …

That explains! We will have to test with more data than we did I think.

Now we know what we are hunting!

But we still can't reproduce!

For use on windows systems I would alwasy use rn for line change (>LF> in ASCII/ANSI terms).

@Tom: we need a dump with structure (with the exact datatypes) and data and a screenshot of your settings in the export dialogue and te EXACT query.

Did you tell what was the MySQL version? Server platform?

[peterlaursen]

Not it is not possible that way!

Are you sure that you understand the connections manager?

See attached picture!

You give every connection a NAME and the connection details for each is saved in the sqlyog.ini file.

[peterlaursen]

wine is ported til Mac OS-X

http://darwine.opendarwin.org/

and a more 'polished' commercial port

http://www.codeweavers.com/products/cxmac/

.. there is a free beta.

We cannot offer any more at the moment ..

[peterlaursen]

sorry Tom but we do not understand you here:

do you complain about a crash or a missing ” ??

We

Code:

CREATE TABLE `tt` (
`memberid` int(11) NOT NULL default '0',
`lastid` int(11) default NULL,
`status` int(11) default NULL,
PRIMARY KEY (`memberid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

next insert some rows and execute like

Code:

select concat('delete from ss_members where memberid=', s1.memberid,';') from tt s1 where s1.lastid=5 and s1.status=6;

copy the returned row(s) to clipboard. paste into Notepad and get results like

Code:

“delete from ss_members where memberid=2;”

no crash .. no missing ” . Please explain so that even I can understand this!

[peterlaursen]

OK …

you can read about the max. storage size of different variable types here:

http://dev.mysql.com/doc/refman/5.0/en/sto…quirements.html

BLOB: 2^16 byte ~64 KB

MEDIUBLOB: 2^24 byte ~ 1.6 MB

LONGBLOB: 2^32 byte ~ 4 GB

Data are truncated if they are too big. However I did not notice because my image was a Interlaced TIFF image and with that resolution it displayed OK actually (there were lots of 'holes' in it but they were not visible). A .JPG on the opposite will simply be cut off!

[peterlaursen]

There is no such (known) issue with SQLyog. Attached a BLOB of almost 3 MB (SQLyog 5.2 beta5)

But please upgrade SQLyog and try again – though I am 99% sure that there was no such issue with 5.16 either.

Are you connecting with HTTP-tunneling? There could be some buffer or time-out issue on the network.

PHP/webserver(Apache)/releay server settings are my best guess. Neither SQLyog nor MySQL, I think.

SQLyog sends the data, it is all delivered to the remote network, but inside that netwok some of it gets lost.

If you create a ticket I can arrange access to a database on another server (tomorrow!).

Upgrades: http://www.webyog.com/en/download_latest_sqlyog.php

Tickets: http://www.webyog.com/support/ttx.cgi

[peterlaursen]

I forgot a detail:

A table created with a 'select .. union .. select … ' construct does not have indexes. So you could include a ALTER TABLE statement that builds the indexes that you want.

I you cannot write such ALTER TABLE statement you can do it from SQLyog GUI .. and copy the SQL from the HISTORY pane.

[peterlaursen]

No not possible. But you do not need a sync tool for this if I understand right. Plain SQL like

Code:

create table db1.newtable as
select * from db1.oldtable
union
select * from db2.sourcetable where .. — here goes your where;
rename table db1.oldtable to db1.trashtable;
rename table db1.newtable to db1.oldtable;

… will do. You can of course create a Notifications Service -job for it.

[peterlaursen]

Both issues confirmed with 'word wrap' active. I can reproduce the 'garbaging' too with very long strings.

[peterlaursen]

probably the database has not been updated with your details yet.

[Author]

Posts