[larsen]

ok, I see.

thx =)

[larsen]

PolarBear wrote on Dec 9 2005, 07:09 PM:

I suggest a toggle in the results pane that will turn the  “Truncate Column Headers to Maximum Data Size” option that is available in the Preferences.

Could be useful, too. The advantage of “doubleclick on separator” is that I can set the width individually for each column.

Quote:

You could click it on and off and the result would refresh with the columns sized to data size or to column header size.

When resizing to data size it would be good to have the column header size as a minimum size. As it is now, you cannot see the column name when the data is just “0”s and “1”s.

[larsen]

Astonishingly, it was the DOC 🙄

[larsen]

I found it, too 😀

[larsen]

Ritesh wrote on Dec 8 2005, 11:22 AM:

Shift+f5  😀

[post=”8157″]<{POST_SNAPBACK}>[/post]

Ok, nice to know 🙂

I´m used to F5 as I´m constantly working with MS Query Analyzer. Will there be a way to assign the shortcuts myself?

Quote:

prefer to use the mouse

Mouse? What is this “mouse” thing you are talking of? 😉

[larsen]

peterlaursen wrote on Dec 8 2005, 10:00 AM:

My ignorance – what is “full insert statements” ??

BTW: I DO NOT ACCEPT the use of phpmyadmin as a reference …  😛

[post=”8146″]<{POST_SNAPBACK}>[/post]

“Full inserts” mean that the columns are stated in the sql string.

Here is an example of what SQLyog looks like:

INSERT INTO `tableX` VALUES (value1, 'value2', value3)

Here an example of phpM… I mean, ermm, another MySQL Frontend 😛

INSERT INTO `tableX` (`field1`, `field2`, `field3`) VALUES (value1, 'value2', value3)

[larsen]

Ok, I just found that I can reorder the table structure already 😀

Could you add a button to the “alter table” window, too?

Full inserts would still be nice.

[larsen]

The option should be disabled while the export is running. All the other controls are disabled already.

[larsen]

Ritesh wrote on Sep 8 2005, 03:33 PM:

Are you talking about DB -> Export Database As SQL Dump?

[post=”7102″]<{POST_SNAPBACK}>[/post]

yes

[larsen]

Hmm, perhaps it wasn´t my mistake: When you select the root entry and in the sql dump window select any DB, select all tables and click on export, the output is empty (besides the above mentioned comment).

[larsen]

Hello. I just tested this once more.

Quote:

Perhaps you tried to export an empty table!

Nope. But something very similiar 😕

I barely dare to say… I didn´t select any table to export 🙄

I´m really very sorry for that!

As a suggestion to prevent others from doing this (if anyone is as stupid as me what I can´t imagine): There should be a warning message if one hasn´t selected any table.

[larsen]

Quote:

From Laursen to Larsen …

🙂

Quote:

Could it be that the user that you log on with has only the SHOW_DB privilege but not the SELECT privilege ??

no. logged in as user root on a mysql server 4.1.12-max (installed via rpm) on our intranet.

Quote:

If you use the predefined user “test” he has only orivilges to  to the “test” database and NOT “test2” or anything else unless you have changed it!

Sorry, I had better chosen another name. I didn´t mean the predefined test db.

Quote:

And the host from where you connect is defined correctly with the user ?  (unless you specify otherwise user is only allowed to connect from “localhost” – that how MySQL works).

Everything else works fine.

When I choose the DB I want to sqldump before I select the menu item it´s ok.

It´s just when I select another DB in the sql dump screen that I get this error.

Quote:

I believe you are Danish so you might write in Danish if you want …

Sorry, but my Danish is not that good as I´m German 😉

'Larsen' is my nick for 'Lars' – a Nordic name anyway 😎

[Author]

Posts