[peterlaursen]

@ritesh …

I guess that applies to RESULT tab in text mode too? A workaround could be to convert to non-text in the background, do the filtering, and convert to text again.

Situation is that Ron requests a 'show table in text' or a reasonable substitute.

And I request 'show in text' be a per-tab setting and an option to make a RESULT-tab 'sticky', so that it won't disappear or change (neither it's content or its style) when another query is being run.

And CalEvans request that GLOBAL 'show results -style' be written to the .ini file, so that program remembers the setting between boots.

[peterlaursen]

I recommend 5.13 beta2. Compared to 5.12 it is only bugfixes.

The most important one is the fix for slow save from DATA pane as reported here:

http://www.webyog.com/forums/index.php?showtopic=2166

Links to download from here:

http://www.webyog.com/forums/index.php?sho…t=0&#entry10244

You can 'install over' or to another folder as you prefer.

[peterlaursen]

Are you sure you use the latest version?

With 5.13 beta2 I get

/* Alter table in Second database */

alter table `test3`.`user`

add column `UserId` bigint(20) unsigned NOT NULL auto_increment first,

change `GroupId` `GroupId` bigint(20) unsigned NOT NULL after `UserId`,

add PRIMARY KEY (`UserId`);

There were such bugs in the early 5.1.x tree.

If you still think there is a bug, then please post complete 'create statements' for two tables to reproduce with.

[peterlaursen]

1)

“a keyboard shortcut solution would require two steps”

you need to move – else you will become FAT 😀

2)

” it needs to happen in such a way that the query editor is unafected.”

That is obvious, in my opinion. It will be written to HISTORY however.

There is another problem however, and that is that 'show results in text' is a GLOBAL setting – not a per-tab setting. Actually this has annoyed me a little before (I am a mouse user and absolutely not a keyboard user).

Now let us see if Ritesh has some ideas and comments tomorrow.

[peterlaursen]

@ron

I think we all understand that you and probably others as well request that feature! Since it is not implemented it most likely is not so easy. Might involve quite a lot of restructuring of the data structures and code 'behind' the DATA tab.

What about a keyboard shortcut (CTRL + * ??) that executes 'SELECT * FROM current_table (and maybe using a LIMIT too)' and opens it in a RESULT tab. That could probably be implemented easily. Combined with another pending request that it should be possible to 'freeze' a RESULT tab (or make it 'sticky' if you like), I think you get what you need?

Actually CTRL + * could use LIMIT and CTRL + SHIFT + * could use NO LIMIT.

Comment?

[peterlaursen]

Yes, that was better.

Sorry for me confusing the different installers.

[peterlaursen]

I cannot see any change from 5.12 to 5.13 beta.

[peterlaursen]

With SQLyog 5.1.x there is an option to set default charset/collation for each column In CREATE TABLE and ALTER TABLE GUI's. Which version do you use? There is no GUI facility to set charset for databases and tables. I think that should be priority now … And not hidden away behind some 'advanced' button … Actually this is a basic and not an advanced option. I even think they start understand that in Bangalore … 😛

with tables you can execute

ALTER TABLE … default charset …….

.. but does not change existing columns!

With databases you can

CREATE DATABASE … default charset …. or

ALTER DATABASE … default charset ….

… but again ALTER the default does no change existing data. has effect with new tables only.

If you have data using a 'wrong' charset you can export them and edit the backup file or copy data to another database/table created in advance with the 'right' charset.

“On mysql 5.0.19, altrough the server is started with latin2 charset, newly created varchar field has latin1 one.” Then the DATABASE or the TABLE must have another default than the server. What does the SQLyog OBJECTS tab tell in the 'create statement' for the table?

[peterlaursen]

@vygi

I know that this FAQ (actually there are a handful) most be updated. Coming soon.

Detailed planning going on …

[peterlaursen]

This is not supposed to be an answer, but some additional questions and considerations …

1) Does the ODBC-driver expose the views? Try connecting to the 'external datasource' from Access or OpenOffice Base using ODBC. If not a Migration tool using ODBC of course cannot.

2) If possible at all, I think it will only be possible to import to a table, as the view only makes sense as a VIEW when the table(s) used for its construction is available.

.. and looks like Ritesh is 'on track' …

[peterlaursen]

there is a way ..

You can create a batch file that

1) runs sja

2) next calls a zip program that can be executed from commandline. Filzip http://www.filzip.com is an excellent (free) one that has command-line option. You can add into an existing archive.

3) finally execute a 'del' command to delete the .sql file when zipping is done

it is a .bat with three lines. You can schedule the .bat and not the SJA itself then.

[peterlaursen]

Similar thing here:

http://bugs.mysql.com/bug.php?id=19969

Actually the server accepts DEFINER in 'create view' but not in 'create procedure'.

[peterlaursen]

Read:

http://www.webyog.com/whitepaper/Preparing…__Migration.pdf

whats is new is that from version 4.1 SQLyog imports not only data but also all sorts of indexes. That is why the ''metadata tables' must be unhidden. Did you use to use an earlier version?

You may also deselect indexes from behind the 'advanced' button of each table.

If you don't know to new Migration Tool yet, also read:

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

[peterlaursen]

Yup .. I know that was an 'error 40'. 🙁

[peterlaursen]

5.02 is fast too! And even 5.11 is.

[Author]

Posts