[peterlaursen]

Yes … you can do a one-way sync in either direction or a two-way sync.

To understand it in details read the article:

http://webyog.com/articles/Using_SQLyog_En…L_Databases.pdf

You MUST understand the basic principles of using a Primary Key with the sync before using it with improtant data.!

Also visit the FAQ http://www.webyog.com/faq

.. And try out the ENTERPRISE TRIAL for yourself. It has the restriction that it only lets you sync one table per sync, but apart form that it is fully functional. And the SJA for Linux does exactly the same thing (but is a comman line tool only .. no graphical environment to configure it)

[peterlaursen]

Hello …

anyone still experiencing that thing, please ZIP you 'favorites' and 'personal' folder (whatever you have), create a ticket and attach the zip (with a few words, thanks!). We would like to see what is REALLY inside the folders then .. also what Windows does not show!

[peterlaursen]

edit: problems with gmail … you got ordinary mail!

Something seems to have changed here with SP2. Does not look like Windows needs that file anymore in most cases. Name of it was 'desktop.ini'. I existed on both filesystems I think

It is still used sometimes. If for instance the icon for a folder is changed desktop.ini contains

[.ShellClassInfo]

IconFile=E:2. mappe LP'erLPikon.ico

IconIndex=0

Also special folder like the fonts folder has such file with [.ShellClassInfo] like

[.ShellClassInfo]

UICLSID={BD84B380-8CA2-1069-AB1D-08000948F534}

the important thing is that Windows has an option NEVER to display certain files .. even if you configure it to show 'hidden files' . The tool I sent you does .. and much more.

[peterlaursen]

@Ritesh – Manoj

Check your gmail in 5 minutes!

I think it could be interesting to know if people having this problem is using the FAT32 or the NTFS file system.

Because … if folder is configured to display for instance 'Big Icons' there is a hiiden file in the folder telling the system so on FAT32 (on NTFS this info is saved as filesystem METADATA)

[peterlaursen]

aha .. Ritesh caught the point here .. 🙂

Now even I understand the question!

I'll add an example:

You can export .sql file, edit it and import. Have a look at attached file.

The SQL-export for this looks like:

Code:

/*
SQLyog Enterprise – MySQL GUI v5.12 BETA
Host – 5.1.9-beta-log : Database – test
*********************************************************************
Server version : 5.1.9-beta-log
*/

SET NAMES utf8;

SET SQL_MODE='';

create database if not exists `test`;

USE `test`;

/*Table structure for table `tablename1` */

DROP TABLE IF EXISTS `tablename1`;

CREATE TABLE `tablename1` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`t` varchar(50) DEFAULT NULL,
`vb` varbinary(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `tablename1` */

insert into `tablename1` (`id`,`t`,`vb`) values (1,'hos John Doe (PÃ¥minn=0)\0','hos John Doe (Påminn=0)');

Note the difference between ' ' and '' in the SQL-file for the two columns

First column has an escaped followed by ''. This is valid for ''. '' alone implies that data are binary (not character data)

[peterlaursen]

http://www.sightspecific.com/~mosh/WWW_FAQ/nbsp.html

and the fund of the day: http://www.trygve.com/doomsday.html

http://www.sightspecific.com/~mosh/WWW_FAQ/nbsp.html

and the fund of the day: http://www.trygve.com/doomsday.html

[peterlaursen]

The solution is to have a Primary Key in the table. Then SQLyog will ONLY use this this PK in the where-clause.

[peterlaursen]

I am sorry ..

I guess I simply wrote this the wrong place! 🙁

[peterlaursen]

this term “Binary/Image” is not very precise any more. It means that it is a datatype that cannot be displayed in the grid for one of the reasons:

1) It is binary data, that cannot be represented in a meaningful way using characters

2) It is too long to 'fit in'

1) is BLOBs (used for images, media files etc)

2) is TEXTs (used for character data too long to be char or varchar)

Plan for the future include:

“Enhancements to the BLOB-viewer: BLOB-viewer should be resizable and there should be an option to display binary data in binary/hex view (like common hex-editors and the Windows Regedit program). Also support for the MySQL version 5 BIT datatype should be implemented. Finally it also should be considered to use (could be optional) the BLOB-viewer for very big VARCHARs. This is actualized by MySQL version 5, that allows for VARCHAR size of 65000+ characters.”

I think you may have a TEXT column and not a CHAR/VARCHAR column?

[peterlaursen]

Did you consider SJA for windows?

You are welcome to play with this, but don't expect Webyog to support!

SJA for Linux is compiled on and for LINUX and no other *nix.

Most likely it could be compiled on and for OS-X, BSD's, cygwin etc. but no plans of going into this at the moment.

[peterlaursen]

@Ritesh: Verified by Manoj and me:

We tried to find you online … 😉

To reproduce the crash:

Create a file with no extension in 'application data/sqlyog/favorites' folder and start SQLyog 5.11 and any 5.12 version (beta 1 and 2). It crashes.

[peterlaursen]

“When I edit the last column (field) of a row, and press enter, everything goes blank.”

1) I cannot reproduce anything like this from your description

2) pressing enter in a cell in the data pane does not save – arrow down or up does …

Is it a very big table? Can you explain the problem more in detail?

[peterlaursen]

I have two local and two remote servers i can connect to with HTTP-tunnel. And I don't have this issue. Do you have a chabce to conect to some other server, just to find out if the problem is related to one specific server or the problems shall be found on the client side?

[peterlaursen]

I guess you mean, THEN deleted … ?

.. just to be perfectly sure!?

[peterlaursen]

Quote:

I printed the screen shot

well you did not attach it! … PLEASE …

Now … as long as you only work with TIS620 charset SQLyog version 5.02 may be OK. However if you have some databases/tables/ columns using a unicode charset (uft8 or ucs2) containing Thai characters and others using TIS620 on the very same server you will need version 5.1.x (and choose TIS 620 for the connection) to display and save everything correctly.

@Ritesh .. you got a beta tester!

@Kai .. expect around 6 weeks for something workabale.

[Author]

Posts