[CalEvans]

Usually, this is a compile issue, not a cnf issue. (I could be wrong here)

Grab the latest MySQLMax from http://www.mysql.com and re-install. (backup your existing data first!0

=C=

[CalEvans]

I can confirm this. It happens to me anytime SQLyog is in a modal dialog box. If I switch to another window and then try to ALT-TAB back, SQLyog is no longer in the list of windows.

I'm a bad beta tester for not reporting this sooner. (sorry.)

=C=

[CalEvans]

Bounce the server (stop and restart mysql) and try again. You've got a transaction blocking you somewhere. (Warning! Ignore this advice totally if it's a production server!)

=C=

[CalEvans]

Checking my Windows box running mysql(YES, I keep one around just to prove it CAN be done) Go to the WinMySQLadmin program. (Mine is running in my status bar) Find the variables tab. Find the variable have_innodb. Does it say yes?

=C=

[CalEvans]

Quote:

I can connect fine locally, and I can connect to the remote database using other products such as mysql front and dbvisualizer.

Are these programs connecting directly or are they using ODBC?

=C=

[CalEvans]

Quote:

Error No.1130

HOST” .my IP.” is not allowed to connect this MySQL server

This is a mysql access error. Your account is not allowed to connect to the server from your IP address. Contact your MySQL admin and get him/her/it to allow you to access it from this IP address. If you are the admin, check the manuals.

=C=

[CalEvans]

There is a 'History' TAB below the main window. The SQL it is trying to execute should be there. Snag it, paste it in here and let us all have a gander.

=C=

[CalEvans]

MySQL DOCS

use insert into tablename select * from tablename where primaryKeyName = lastKeyValue ON DUPLICATE KEY UPDATE primaryKeyName=primaryKeyName+1;

Then use the data edit feature to edit the new record.

not as easy as having it built into the FE but it will work.

=C=

[CalEvans]

Have you checked your permissions for [email protected] on the mysql server? I've yet to nail it down but I have problems with MySQL (not particularly with SQLyog) and their permissions. I end up avoiding setting permissions for gunther@% and set each instance of gunther. (Since I log in from several different machines this means I have to setup several different logins.

=C=

[CalEvans]

How big are the databases (number of tables.)

=C=

[CalEvans]

Just curious. How would this differ from the output in the History tab?

=C=

[CalEvans]

That's what is supposed to happen when you click on a DB name and select empty. It empties the DB. It's not designed to simply truncate all the tables. (Althought that would be a cool feature to add.)

=C=

[CalEvans]

Check 2 things:

1: Look in the History tab and see what is actually being executed. Copy it and past it into the command line mysql client. See if it works. Report back.

2: Check the permission on the directory vetnet. Does whatever user that mysql is running as have permission to write to this dir?

=C=

[CalEvans]

Currently, your only alternative is to re-write your queries to use left joins. This solution will allow you to work around most situations where you would use a sub select in the where clause. (That's where the majority of them exist.)

As for sub selects in the field list. I've never seen that done. I'm not entirely sure that's ANSI standard. MySQL is working towards ANSI93 compatibility. If it's not in the ANSI93 spec, it probably won't be in MySQL.

FWIW, the last version of MSSQL and Oracle I worked with did not have this 'feature'.

The other thing you can do is re-design your database so as not to require these. Not knowing your schema or problem space, I couldn't begin to suggest how. But you might want to take a step back. It might mean de-normalizing a bit.

HTH,

=C=

[CalEvans]

one other idea, have you bounces the mysql daemon? (stop/start or restart?)

=C=

[Author]

Posts