[Mahesh]

Currently there is no way to achieve this without creating individual database backups.

I have added your feature request here :

http://code.google.com/p/sqlyog/issues/detail?id=1417

Thanks for your suggestion.

[Mahesh]

Hi,

You need to copy the 'sqlyog.ini' file from v5.15 installed folder to Application Data folder where new .ini is created.

Note: If you install v8.5 on the same path of v5.15, “sqlyog.bak” will be created in installed folder and all the connections would have been moved to AppData folder.

The file position is:

Windows 2K/XP/2003:

C:Documents and SettingsUserApplication DataSQLyog

Windows Vista/2008/7:

C:Users{user}AppDataRoamingSQLyog

Note that 'AppData' folder is a hidden folder (you unhide from Control Panel … Folder Options) and also note that some folders may have localized names.

Please feel free to ask any questions.

[Mahesh]

During connection you can specify “Session idle timeout” value by default it is 28800 secs( 8 hours) also as you have mentioned that your server is in another country check “Compressed protocol” option too in connection wizard.

Can you please tell,

1) Program version you are using?

2) Please mention exact error ?

[Mahesh]

Yes .. You are absolutely right in this way hacker will not get access to XML file.

[Mahesh]

We have added your feature request here:

http://code.google.com/p/sqlyog/issues/detail?id=1409

We will discuss within the team and update here about priority to implement.

[Mahesh]

We are unable to reproduce this issue at our end.

Can you please attach .SQL file having a table structure along with sample data ?

[Mahesh]

OK .. there is another option to Copy Database/tables from one host to another.

In your case you can select target server as TestServer and check “Drop if exists in target”.

[Mahesh]

Quote:

In my case, a client had added a few products in a table on the live site. So I had to copy over those products into our closed test server. I manually copied field content between the two databases. Luckily it was only 3 products this time.

— OK .. You want to synchronize rows(records) between two similar tables then you can use a feature called “Database Synchronization” it “synchronize” data (complete database or individual tables) on two servers/host. It utilizes advanced checksum algorithms for comparison

of the data and can be very effective in “finding out” which data must be INSERTed, UPDATEd or DELETEd on either of the hosts to bring them “in sync”.

Please read this documentation regarding Database synchronization:

http://www.webyog.com/en/whitepapers/Using_SQLyog_Enterprise_to_Effectively_Synchronize_MySQL_Databases.pdf

As I understood that you have a Live server and testserver and you want newly added records in live site should get updated in testserver right ?

You can achieve this using Database Synchronization tool of SQLyog ( Goto Powertools –> Database Synchronization)

Please feel free to ask any question.

[Mahesh]

You can't paste those rows into other table, you can copy those selected rows and paste those in an editor ( like in SQLyog editor, Notepad etc…)

[Mahesh]

'gonterm' wrote on '25:

My company is looking to upgrade from an outdated, free version of SQLyog (v5.22a) to the latest commercial version. I've been testing to find issues and something that is causing me a huge headache is that in the old version of SQLyog, a table that has a lot of french characters in strings is displaying them appropriately, while the new version of SQLyog treats them like they don't exist. String like MÉTAG end up looking like MTAG instead.

That table is type latin1 and I tried changing it to utf8 and that didn't help. The most confusing part of it all is that the old version works perfect but the newer version doesn't. Please, any insight would be helpful!

Thanks,

Michael

SQLyog is fully UNICODE-compliant since version 6.0.

We tried this case at our end :

CREATE TABLE `test` (

`name` varchar(20) character set utf8 default NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `french_chars`.`test`(`name`) VALUES ( 'MÉTAG');

(See the screenshot attached here with)

Also Please read these FAQ:

http://www.webyog.com/faq/content/34/152/en/my-special-characters-display-as-_noisy_-latin-characters-in-sqlyog.html

http://www.webyog.com/faq/category/34/character-set-and-localization-issues.html

Please tell,

1) Program version you have used ?

2) Can you attach a sample table structure along with sample data, this will be helpful for us to debug a problem?

[Mahesh]

If I add a column to one of the tables that is sent in the datasync, and if he hasn't made a corresponding change on his side, we are curious what will happen. Will the entire datasync fail? Or will it succeed on all but the one table that has been altered?

— Entire Datasync will not fail, it will fail only for a particular table for which “field count does not match”.

And regarding the modified table, will the sync fail on that table? Or will sqlyog sync the existing columns and just throw away the extra column? Or will the table on his end be modified by the change in the table on my end? Or something else?

— Sync will fail as field count varies, also remember one thing to perform database synchronization table structure should be same.

He doesn't need the extra column, so we don't actually care if he gets the new data, just concerned whether the rest of the data will still sync okay or not, or if he needs to modify his table to match.

— It is not possible to sync data if there is a difference in table structure, he should modify his table to match.

I suggest if there is any change in source OR target table structure you should perform Schema synchronization operation first then perform Database synchronization operation.

In this way table structure and data both will be in sync.

[Mahesh]

No worry..

You can retrieve(see) all rows of large table, but it will take some time to display records in grid.( Depends on Server performance, System performance etc..) also as I have mentioned there is a STOP option to STOP retrieval of records.

[Mahesh]

MySQL server Load depends on Query you are executing.

If limit is set to 50 then “Select Query will be appended by limit clause”

and

If you are viewing all records of a large table then it depends on MySQL server performance, Number of records, Datatypes used etc..

Also if you have selected “ALL rows” option by mistake, there is a STOP button on toolbar to stop retrieval of records.

i.e. You can click on STOP button if you do not want to retrieve all records of a large table OR you want to move to limit.

[Mahesh]

These operations depends on MySQL server performance, Network bandwidth etc..

Can you please tell,

1) Program version you are using ?

2) How much time it takes to perform a particular operation for example to Optimize a single table?

3) Can you give us a temporary access to the server, for privacy you can create a support ticket from here:

http://webyog.com/support

[Mahesh]

We have released v8.5 GA with many useful features along with this fix.

Please read our blog from here:

http://www.webyog.com/blog/2010/06/15/sqlyog-mysql-gui-8-5-ga-brand-new-tabbed-interface/

[Author]

Posts