[peterlaursen]

correct syntax for GRANT is

GRANT ALL on newtest.* to 'basis'@'somehost' …

(note how to use quotes).

with 'basis'@'localhost' the client program runs on the same computer as the server.

'%' is a wildcard and means 'any host'.

[peterlaursen]

A few examples form here that are both OK:

Select * from a TABLE .. copy all to clipboard

Code:

“5” “a” “b” N
“6” “c” “d” N
“7” “a” “q” N

SELECT … from a VIEW .. copy all to clipboard

Code:

## “Kunstner” “Genre” “Albumtitel”
9 “'Papa' John DeFrancesco” “Jazz” “Hip Cake Walk”
1 “12 Apostles Church Choir” “World” “The Rough Guide to South African Gospel”
17 “3eme concours flamenco” “Flamenco” “Nimes”
1 “A Falta De Pan” “Folk/Fusion” “Rough Guide to the Music of Spain”
12 “Aaron Neville” “Jazz” “Nature Boy: The Standards Album”
1 “Abaji” “Afrikansk/Vest” “Rêves d'Oasis: Desert Blues 2 (1 of 2)”
16 “Abaji” “Folk/Fusion” “Oriental Voyage”
11 “Abbey Lincoln” “Jazz” “A Turtle's Dream”
10 “Abbey Lincoln” “Jazz” “Abbey Is Blue”
10 “Abbey Lincoln” “Jazz” “Over the Years”

and three rows randomly selected from the last query:

Code:

## “Kunstner” “Genre” “Albumtitel”
9 “'Papa' John DeFrancesco” “Jazz” “Hip Cake Walk”
1 “A Falta De Pan” “Folk/Fusion” “Rough Guide to the Music of Spain”
11 “Abbey Lincoln” “Jazz” “A Turtle's Dream”

.. if there there is an issue then we will ned a 'reproducable test case'

[peterlaursen]

Please check this 'pre-beta5-release':

http://www.webyog.com/downloads/betas/not_…SQLyog52Ent.exe

[peterlaursen]

there is actually another bug in the first create statement (I assume it is created with SQLyog GUI):

“create table `logfiles`.`tester` ( `id` int NOT NULL AUTO_INCREMENT UNIQUE , `field1` varchar (250) , PRIMARY KEY ( `id`)) “

UNIQUE keyword should not be there when PRIMARY is! You get a UNIQUE index and a PRIMARY key as well and autoincrement 'is linked' to the UNIQUE KEY this way – not the PK. We know that there are issues with this UNIQUE keyword introduced with beta4! One more here is that 'dublicate …' does not handle autoincrement attribute with a UNIQUE (non-PK) KEY.

[peterlaursen]

it happens with 'dublicate structure' not with 'copy table'.

Agreed?

[peterlaursen]

I think you asked the same question in a ticket?

Please keep it one place!

I replied this:

“

SQLyog 'export' tool and 'backup' powertool allow for backup of one database at a time. Wiht the 'backup powertool' you can create a batch-job like explained here:

http://webyog.com/faq/27_35_en.html

a comment to ” .. and related users / priviliges”

BTW: It is NOT advisable to backup User Privileges and restore at another server unless you backup and restore a COMPLETE server. MySQL privileges' system is not designed for that!

In a shared environment that will give you problems if it is possible at all! All users and privileges are stored in tables in the 'mysql' database.

If it is your own server you can use the mysql 'mysqldump' program for a server side backup of the complete server.”

[peterlaursen]

@jexxer

are you sure that you tried beta4?

[peterlaursen]

read the screen!

enter your databases at the bottom didided by semicolon!

[peterlaursen]

hmmm..

SJA for Linux does not send mail on my SuSE 10.0 either.

SJA for Windows with Wine does.

What is your distro?

I can add that I have mailer-daemon 'postfix' and not 'sendmail' installed.

.. but switching between the three different ones that I have available makes no difference.

[peterlaursen]

you cannot!

when you delete you execute SQL like “DELETE FROM .. WHERE … “

How would you write a WHERE-condition that distinguishes between identical rows? You cannot, and SQLyog cannot either!

That is one good reason to have a PRIMARY KEY in the table!

http://webyog.com/faq/28_70_en.html

Simply add a autoincrement INTEGER column to the table and define that column as the PK – and there will NEVER be identical rows!

[peterlaursen]

I asked for the 'create statement for the tables' . the log does not tell anything here.

'create statement for the table' in on the OBJECTS tab – or execute 'show create table tablename' …

What makes me suspicious is that you have THREE tables, but you only use TWO of them in the where?

what about

Code:

where region1titles.DVDTitle = ukdvdtitles.DVDTitle And region1titles.DVDTitle = ratings.DVDTitle And ProductionYear > 1900

.. but to discuss the query in detail I need to understand your tables first!

[peterlaursen]

I have no problem wit accessing preferences in Wine, see attached.

The two known problems with Wine is

1) favorites does not work

2) a few keyboard shortcut do not work

.. refer to issue 12 here: http://code.google.com/p/sqlyog/issues/list

What is your Wine version and Linux distro?

maybe you should consider to upgrade Wine?

Quote:

althought it definately has problems in this scenario

Please be SPECIFIC about the problems. A statement like this completely unusable.

There is no development being done at the time on a native Linux version. With the vast progress of Wine (and now it being ported also to Mac – and running great on FreeDSD and PC-BSD too) we are in doubt actually if it would not be better to work with Wine. We may consider to built and distribute our own 'yogwine' being built from only the Wine components that we need. Just like Google Picassa did.

[peterlaursen]

MySQL client ran out of memory

(7681 ms taken)

it should normally take much more time than 7-8 sec's to fill that memory.

You are sure that your JOIN-query dos not return a 'astronomic' set of data?

How many rows would you expect to be returned here?

Try attach the 'Create statement' for the tables.

[peterlaursen]

You can use any column that has unique values.

It is widely use to add a autoincrement-integer for the PK (and nothing else), but it need not be so.

[peterlaursen]

What file need run? Answer: SQLyog.exe or SQLyogEnt.exe!

You cannot run 'part of it'. SQLyog is a compiled binary. It does not run scripts in the background. The functionalities of SQLyog are GUI functionalities of the program itself. It does not execute external code. The code that is executes is compiled in the SQLyog binary.

Exception is the SJA ('SQLyog Job Agent'). SJA functionalities can be called from command line or anothe application. Read about it here: http://webyog.com/faq/27_114_en.html

So for executing from a C# program the 'backup powertool' could be a solution if I understand you right.

[Author]

Posts