[peterlaursen]

Quote:

This obviously runs slower than my previous method.

It is not clear to me what was the previous method! Syncing 40 tables takes the time it takes

1)

You can try instead of

sja job1.xml

sja job2.xml

etc

to use

call sja job1.xml

call sja job2.xml

etc

(with path's as before of course)

.. then all jobs will run simutaneously. (And you will have 40 command-boxes displayed on the screen while it runs – a 'Virtual Desktop Manager' is preferable here ….. 🙂 ) If bandwidth is sufficient that may speed up things considerably. (Actually I have bandwidth corresponding to about ten times the speed of my ISP-MySQL server in outgoing direction from my local and much more the other way)

Of course you can combine things like having a my.bat calling for instance

5 bat files like my1.bat, my2.bat .. my5.bat. Each of those would then have 8 successive sja statements …

2)

But first of all read

http://www.webyog.com/articles/Using_SQLyo…L_Databases.pdf and understand how to use the and options effectively

[peterlaursen]

Quote:

when you press F9 …

I never do. I can afford to have a mouse! 😀

Now .. If I rename a database, and highlight the database and refresh, it does not change. If I highlight user it does. Well obviously it cannot refresh the old databasename, as it (the old one) does not exist anymore. .. But still a little confusing.

This is not exactly the same behaviour as with tables. If I rename a table (not from GUI but by writing SQL myself), highlight the table and refresh, an error occurs (MySQL server error 1146: table does not exist)

[peterlaursen]

Or maybe better: simply allow for a … to specify a (sequence of) SQL-command(s) to be executed as the first command(s) executed after connection.

To let user for instance

Code:

“set @job_start = now(); set character_set_results = latin9; set sql_mode = 'strict_all_tables, no_zeros_in_date”

With this example you might for instance include this code in a Notifications Job

Code:

set @start = now() + 0;
…
…
select concat(((now() + 0) – @start ), ' seconds passed since job started');
…
…
select concat('Job finished after ',((now() + 0) – @start), ' seconds');

(though I know that the 'set @job_start = now()' can be included in the 'main SQL block as well allready)

Default for this could then be simply

Code:

“set character_set_results = default; set sql_mode = ''”

and user might simply specify

Code:

“”

if she does not want any executed.

[peterlaursen]

@ritesh:

BTW – a question 🙂

How does the SJA SET NAMES or set_character_results ?

Should such option not be added to theand sections of the jobfile?

Like

Code:

latin1

or

Code:

default

[peterlaursen]

I simply overlooked the space in 'Program files'

Maybe it works without quotes in a .bat file – I am not sure.

[peterlaursen]

Quote:

What should I do from here, Should everything be in the same dir (SJA, batch file, and xml job files?

that would be the easiest! but also

pathsja.exe pathjobfile.xml should work no matter where all the three files are. What is happening to you now is that ift does not find the jobfile in the folder that you specified with “CD …”

You can also use the s and l parameters to specify paths to the session file and the log file, like.

sja jobfile.xml ssessionfile.xml llogfile.text

It also always is a good idea to quote folder or file names with a space like cd C:Program Files”SQLyog Enterprise”

[peterlaursen]

Quote:

Do I have to give the full path to SJA?

Yes, if the bat file and the sja.exe is not in the same folder.

[peterlaursen]

You should use the 'rename database' with care! The native MySQL command does not migrate privileges, stored routines and events.

http://dev.mysql.com/doc/refman/5.1/en/rename-database.html

[peterlaursen]

I see that MySQL have started the changelog for 5.1.9. So probably binaries for 5.1.8 will be available in a few days.

There is a small issue to take into cosideration. If I have a DB named 'test1' and execute:

Code:

rename database test1 to test2;

then the neme in Object Browser does not change. Not even a 'refresh' changes it. However if I 'infold' the connection by doubleclicking the user name on the top of the tree, refresh and 'outfold' again the new database name is displayed.

Generally I would like the Object Browser to me more 'interactive' …

[peterlaursen]

I don't think this is related to SP2. I use it with SP2 and have no such issue.

A new BETA is planned for Monday afternoon Indian time. But I can't tell how much focus there have been on this. Ritesh will be able to Monday morning.

[peterlaursen]

Now I wrote this FAQ: http://www.webyog.com/faq/34_102_en.html

It will be adjusted as needed…

But I have no issue with the latin1 subset of utf8 and ucs2 data when working from SQLyog if only I choose 'latin1' and not 'default' from connections manager.

[peterlaursen]

And to work with UTF8 and UCS2 data with HTTP-tunnelling I simply replace everything in the function SetName() in the tunnelling file

with

Code:

$query = “set character_set_results = latin1”;

The server will transform any Latin1 character to UTF8 or UCS2 and vice versa 'on the fly' as needed.

This might not work with all character sets, as the tunneller file uses ISO-8859 internally, and only these characters http://www.natural-innovations.com/wa/doc-charset.html will be transferred correctly (I believe). Cental European (Czech, Polish for instance) special consonants are not supported so working with central/eastern European UNICODE characters from a latin2-client for instance using HTTP-tunnelling won't be possible this way. To support a wider character set with HTTP-tunnel the tunneling file must use UTF-8 internally (what is possible with PHP, but SQLyog cannot communicate with the tunneller using UTF-8 yet)

Sorry Szodono :huh:

[peterlaursen]

Now even with this table definition:

Code:

CREATE TABLE tt (id bigint, utftext CHAR(20) CHARACTER SET utf8, ucstext CHAR(20) CHARACTER SET ucs2, latintext CHAR(20) CHARACTER SET latin5);

.. I can write correctly to all columns from keyboard if only I execute 'Set character_set_results=latin1;' no matter what the server default because my keyboard layout and my Windows localisation corresponds to latin1! The server does anything else 'silently'!

Everything I enter from SQLyog is displayed correctly by MySQL tools. And 'edit' from QB is 'greyed out' actually. (I know entering latin1 data into a latin5 table is nonsence .. this was just to point it out!)

@jwh …

I think you are using utf8 as default set for the server.

Then SQLog sends 'Set character_set_results=utf8;' or 'Set character_set_results=default;' (with 5.02 and 5.1 beta respectively). It is a bad idea, as it does not support the default charset utf8 yet! As long as multibyte charsets are not supported, it was better to get the windows localization an 'set character_set_result' accordingly or display a message box like 'Default (multibyte) character set for server is not yet supported by SQLyog – you should choose a charset correspondidng to your windows localisation'

With SQLyog 5.02 you may write this statement manually: 'Set character_set_results=latin1;'. With SQLyog 5.1 BETA4 you can choose the Latin1 charset from connections manager.

[peterlaursen]

However if I change server default to UTF8, the information that I entered before is displayed correctly by MySQL tools but not by SQLyog. Se attached. SQLyog has just been restarted and sent “Set character_set_results=default”

I now think that the server 'silently' converts any comment to utf8 when storing them and back to character_set_result when sending them to a client.

Actually if I execute ” Set character_set_results=latin1 ” they are again displayed correctly by SQLyog.

Now this is VERY INTERSTING! 😀

Because I tested not only with comments and also with data. Actually I can use UTF8 for the server (or a database or a table) and use it with SQLyog and the subset of the UFT8 charset included with Latin1, if I only choose LATIN1 from Connections Manager! The server does the conversion 'silently' – but of course only with the subset of UTF-characters supported by LATIN1.

basically when working with unicode data, choose a single-byte CHARSET that corresponds to your keyboard!

@ritesh: did you know? Did we understand one another coreectly?

[peterlaursen]

I cannot reproduce any issue, as long as server has a single byte charset as default.

Table and column comments can be written here with SQLyog and are displayed correctly by Query Browser and vice vesa. (server default is Latin1). The 'Table Editor' of MySQL Administrator and Query Browser is the same.

@jwh: I think I must ask you to explain somewhat more in detail. Is your server running UTF8 as default?

Also check your my.ini file: there might be a 'default-character-set=' in both the [client] and the [mysqld] section. I think the MySQL GUI tools read from the [client] section (and maybe phpmyadmin does too).

Do you have such statements in both sections and how do they read?

[Author]

Posts