[CalEvans]

Just a guess but try checking you max_connections in your my.cnf file.

=C=

[CalEvans]

Using your script and moving the users table to the top of the list, I was able to re-create your structure without a problem.

If you have data in the tables already, could it be failing the new constraints? If you have to create the tables out of order, use

set foreign_key_checks=0;

first. That keeps mysql from freaking out until after you've finished.

HTH,

=C=

[CalEvans]

I assume you mean when you hit F8 to view the contents of a table and possibly change it.

It's a place for you to add a new record. If you don't add anything in that record, nothing will be added to the table.

It's safe to ignore.

=C=

[CalEvans]

delete from table where primaryKey = keyToDelete?

Or on smallish tables highlight the table, press F8 and check the box next to the record to delete. (This will only work if you have primary key defined.)

=C=

[CalEvans]

Sounds like your user@MYNAME does not have permission to access the server. If you are getting an error with a number, I'm guessing that you are actually connecting to MySQL.

Make sure user@MYNAME has permission to do what you want to do. If that doesn't work, add user@'%' but that's more dangerous.

HTH,

=C=

[CalEvans]

Ritesh wrote on Jan 5 2005, 01:28 AM:

The above feature is planned for SQLyog v4.1. You can expect the first BETA of v4.1 by mid-April 2005.

YEA!

I'm so tired of doing the 3-Finger salute to get out of them. 🙂

=C=

[CalEvans]

I do not believe it is possible to connect that way. To use tunneling, your mysql server has to be listening to at least one IP address. (i.e. not skip-networking)

HOWEVER, you may be able to connect to localhost on the server side of the tunnel.

=C=

[CalEvans]

Turn on logging for MySQL and see where it's failing. This is almost always a problem with your server and not the client. (At least I've never seen it as a problem with the client…I could be wrong.)

=C=

[CalEvans]

I agree with 1 & 2. Those would be great features.

I'm confused by #3 as MySQL does not have the concept of Row Numbers. (Like Access or FoxPro do) The only thing I can think that would be analogous to what you are asking is if they put the row number of the grid that is displaying. If they do that I hope they make it an option as it's not something I particularly want to see.

#4. MySQL has a Windows help file you can download. (It's not nearly as good or complete as the PHP one but it's a start)

=C=

[CalEvans]

I'm sure it wouldn't be difficult to add but other than as a reference to the current sort of that local query window, it's not very relevant. (i.e., I'm sure they can show you what row of the grid you are on but it has nothing to do with what record in the database you are on.)

=C=

[CalEvans]

14k rows is a lot of info no matter what your connection is. I've got one table on my local lan (100k) that takes 30 seconds to select 5k rows. Why? Because I've got 2 honkin big text fields in it and moving that kind of data takes time.

I would suggest that there are very few legitimate reasons for selecting all fields, all data on a 14k row table. Narrow your select statement down and only select the fields you need instead of select *.

If you are backing the database up then I would suggest you use a tool like mysqldump instead as it's faster. (Because it does not have a graphical interface.)

=C=

[CalEvans]

This is an issue with your server. (If I'm reading it right) There is a setting in your my.cnf on how big that statement can be. It's usually limited to 1MB but you can change it and then your statements will work. (I've had it up to 8MB before!) 🙂

=C=

[CalEvans]

Yuri wrote on Aug 30 2004, 01:29 PM:

Quote:

Don't know about the references. I'm not having that problem.

Do you mean that the display size of the window i've added as screenshot in my first post differs from yours?

No, I just don't use that editor to edit relationships. I'm old-school if I have to change a relationship, I do it by hand.

=C=

[CalEvans]

Hi,

This is an issue with mysql on windows, not with sqlyog. It's been discussed here before.

=C=

p.s., It's not an issue with mysql on any other platform.

[CalEvans]

The answer is not to use mysql keywords as database, table or field names.

This is not a bug in SQLYog.

=C=

[Author]

Posts