[peterlaursen]

BTW: you can't use the CHAR or VARCHAR variable type ? They can be 255 characters long. (With MySQL ver 5 varchars can be +50000 characteres!).

TEXT in MySQL is not all the same as “text” in for instance MS-Access – VARCHAR is!

[peterlaursen]

Quote:

I can't get tinytext/text files to display as default, all I'm getting is “BLOB…”

Could you explain some more. I don't understand. Best would be to post a screenshot.

There is very little difference of BLOB and TEXT in MYSQL. TEXT have a charset defined with them – BLOBs don't.

You should not expect TEXT to dispay as CHAR or VARCHAR.

[peterlaursen]

I really don't know! With some luck 4.1 will work for you!

But Ritesh must be able to tell whether some updates of their MS-development environment have taken place between 4.06 and 4.07.

[peterlaursen]

then you'd better wait for Ritesh to have a look on it, but don't forget to answer this:

Quote:

Which OS are you using?

And also: which was the previous version that did not do this?

Do you have the chance to try another more simple mouse?

You could try the SQLyog 4.1 beta (you can have both installed at a time – just choose another installation directory).

You get it from here: http://www.webyog.com/forums/index.php?act…t=0�entry6399

Look for the next Beta – I might very well be out tonight.

4.1 is as solid as 4.07 and adds Scheduled ODBC import (and a much faster ODBC import in general). They only need to solve some very special non-standard ODBC-issues with Microsoft databases in particular to finish it completely.

[peterlaursen]

Logitech 🙁 im my humble opinion! Lots of conflicts. But all mouse control in SQLyog are from standard Microsoft VC++ library.

I always by a cheap mouse at a supermarket. They work! 😆

1) Did yoy try this trick with removing mouse device from divice manager. I have experienced before that the installation order coul fix issues with Logitech mouse (and keyboard as well!).

2) Alternatively did you check if there is a newer driver available ?

[peterlaursen]

The most simple trick you could try is to remove your mouse device from system from windows' “device manger”.

Then restart windows, and it will find the mouse and reinstall drivers.

Some of the “smartest” mouse systems such as some Logitech wireless systems can be rather tricky and conflicting. But SQLyog does nothing special in relation to mouse control!

[peterlaursen]

to get started with SQLyog:

host: IP

user: root

With SQLyog you can then create more users and modify existing.

But FIRST of all you must start MySQL command-line tool on the Linux box and give ROOT access to connect from remote machines (after install only connection from localhost is allowed). The wildcard character % used as a host lets you connect frm everywhere.

[peterlaursen]

You can sort by clicking on column header in DATApane but not in RESULTpane

However if you “SELECT * …. ” I don't see why you can't do it form DATApane ?

Alternatively you can “Select * from sys ORDER BY column_name” to sort in RESULTpane.

[peterlaursen]

It is not easy to tell whether this is a SQLyog issue or an OS-issue!

I think you better give information about about OS-version and SP-level!

You are sure that you have not exceeded the swap-file settings of your system (watch task manager!).

Some VERY BIG BLOB's in dataset? If yes, how are they defined ? And as what MySQL datatype are they imported ?

Quote:

the crash occurs on the data import stage.

any idea of how far the data writing has proceeded? (# of rows of total #of rows)

[peterlaursen]

Quote:

The event is added to Scheduled Tasks but it is not running automatically. How to fix this?

This is not an issue with SQLyog but an issue with the Windows' Scheduler. It is a wellknown issue with the Windows' Scheduler that it does not work properly if a job is assigned to a user account that has no password associated with it. Try choosing a user account that has a password.

Of course it could be a problem with your System Clock as well!

[peterlaursen]

The solution thus must be to include the NAME of the connection, ie:

DB_name – connection_name: user@server

or

connection_name – DB_name: user@server

The problem must be the same with the sync tool and any other possible feature of SQLyog that uses two connections simutaneously. Am I right ?

[peterlaursen]

I am not able to reproduce this anymore … Don't have any idea about what was happening at the time. It has worked dozens of times now. It is possible that I had two identically named tables in two databases and simply looked for data in the wrong database ……… :wacko:

[peterlaursen]

@crivera

BTW – I have experienced something similar once with some “pop-upkiller” or “adblocker”. Try to disable all you got of this ..

Attached pic show one of my programs displaying something similar, where it should display some graphics and text. It is the Ad-killer of Norton Internet Security that does this.

[peterlaursen]

Here a jpg-file opened in Notebook and a hex-editor. Actually here a chr(0) displays as but chr(1) for instance shows as . and many more.

[peterlaursen]

I believe that one possibiliy is that what is here displayed as squares are nonprintable characters (ansi 0-32). They display like that in many programs, for instance Notebook. I have no idea of how they get there …

[Author]

Posts